|
More site info...
Access World Forums - www.access-programmers.co.uk | Site profile
|
|
Site profile page for http://www.access-programmers.co.uk.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.access-programmers.co.uk.
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.access-programmers.co.uk is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Access World Forums:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
0
|
0
|
0
|
|
Post:
|
0
|
0
|
0
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Access World Forums (http://www.access-programmers.co.uk)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Access World Forums posting activity graph:
|
|
http://www.access-programmers.co.uk Alexa graph:
|
Top authors on Access World Forums during last week:
user's latest post:
peculiar problem
Published (2009-11-06 19:51:00)
Something, somewhere is dirtying the form (setting a value to some control or field) in some event.
user's latest post:
Syntax for putting multiple...
Published (2009-11-06 08:26:00)
Unix only uses the 10 not the 13, windows requires both @ Rick Stanich Quote: Originally Posted by Rick Stanich vbCrLF example: Code: Sub aaa() MsgBox "This is my message for line one" & _ vbCrLf & "This is my message for line two" & _ vbCrLf & "This is my message for line three" End Sub oh noooos... please... no... forget the line continuations! (look up in...
user's latest post:
How to import textfile
Published (2009-11-07 13:06:00)
i've just said the NAME command NAME oldfile newfile (or maybe the other way round - check help)
user's latest post:
Acess 2003 - Form will not...
Published (2009-11-06 13:55:00)
Quote: Originally Posted by Orson9750 Sorry you are correct -- my error the command button is on the frmClientMain Figured as much...just wanted to make sure Quote: and yes to your question There in lies your problem. Subforms should be the Many part of a One to Many Relationship. When I read your post, my perception is that there can be many AppProcesses for each Client. So you would open up the Client Form with the Client you want. The...
user's latest post:
Data from two tables
Published (2009-11-07 13:46:00)
You need a UNION query to join the two tables together, then a totals query based on that UNION query. You might be able do it with a join, but I think the UNION will be more flexible.
user's latest post:
How to talk to a programmer -...
Published (2009-11-07 21:21:00)
ah I see, the topic seems to be off to user names in the forum. like my nick genesis, rommelgenlight, marianne, accessuser2007. true, because we are friends here in my country, city. we share common problems. would that answer the queries. we actually post in different forums with different username because we taught that some helpers would prefer some members in the forum. but nevermind, username is not the issue. well still in the loop now.
user's latest post:
To Create or Not to Create...
Published (2009-11-07 22:09:00)
I use multiple back ends a lot. I have for years without any issues. I even have back end in different formats. Some table in an Access database and some table in an SQL server. With multiple back ends, you can not enforce RI between table in different back ends. You have to write your own code to enforce it. I am really curious: What was the reason not to have multiple back ends?
user's latest post:
Link field on form1 to field on...
Published (2009-11-07 16:33:00)
Your code using OpenArgs would be something like this. In the first form: Code: Private Sub OpenSecondForm_Click() If Me.Dirty Then Me.Dirty = False DoCmd.OpenForm "SecondFormName", , , , , , Me.AutoNumberFieldName End Sub In the second form: Code: Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec If Len(Nz(Me.OpenArgs, "")) > 0 Then Me.ForeignKeyFieldName = Me.OpenArgs End If End Sub If you will...
|
|
|
Top 10 active forums on Access World Forums during last week:
|
|
Top 10 forums on Access World Forums:
Forms
- 81,712 posts
|
Modules & VBA
- 59,870 posts
|
General
- 55,415 posts
|
Queries
- 51,206 posts
|
The Watercooler
- 29,365 posts
|
Reports
- 20,120 posts
|
Tables
- 17,182 posts
|
Politics & Current Events
- 16,669 posts
|
Excel
- 5,155 posts
|
Theory and practice of database design
- 4,393 posts
|
|
|
|
|
Latest active threads on Access World Forums:
Started 1 month, 3 weeks ago (2009-09-18 23:47:00)
by Atomic Shrimp
+1
I would add:
Don't get shirty and defensive when we ask for details of your existing application/code/data
or if we ask for an explanation of what you're trying to do in a real-world context.
We're not the slightest bit interested in stealing your idea, or data - it's just impossible to help you unless you properly explain what it is you're trying to do.
Started 1 day, 13 hours ago (2009-11-07 22:09:00)
by HiTechCoach
I use multiple back ends a lot. I have for years without any issues. I even have back end in different formats. Some table in an Access database and some table in an SQL server.
With multiple back ends, you can not enforce RI between table in different back ends. You have to write your own code to enforce it.
I am really curious:
What was the reason not to have multiple back ends?
Started 1 day, 20 hours ago (2009-11-07 15:08:00)
by dcb
Your gonna have to help out a bit here...
To do the search you:
Press a button, macro, type in a check box?
It comes up in a form, report?
Started 23 hours, 49 minutes ago (2009-11-08 11:26:00)
by williamlove
Update: I got the combo box color to stay the same by changing the form's
Alternate Back Color to white. I'm not sure if I might suffer any
unintended consequences or not...any thoughts?
Started 1 day, 8 hours ago (2009-11-08 02:24:00)
by dcb
3067 = ?
Try doing a debug
Comment out the
doCmd
and do a
debug.print query
Take the actual query from the immediate pane and have a look at that
Started 1 week, 1 day ago (2009-11-01 06:03:00)
by Fifty2One
Did you need to Refresh the data or Requery ?
Started 1 day, 1 hour ago (2009-11-08 09:34:00)
by ajetrumpet
you need a subquery, not an equality. THIS:
PHP Code:
WHERE table1 . field NOT IN (
SELECT [ field ] FROM table2 )
not this:
PHP Code:
WHERE table1 . field = table2 . field
Started 1 month ago (2009-10-05 05:43:00)
by DCrake
Are you referring to User Level Security in Access or Active Directory?
|
|
Hot threads for last week on Access World Forums:
Started 1 month, 3 weeks ago (2009-09-18 23:47:00)
by Atomic Shrimp
+1
I would add:
Don't get shirty and defensive when we ask for details of your existing application/code/data
or if we ask for an explanation of what you're trying to do in a real-world context.
We're not the slightest bit interested in stealing your idea, or data - it's just impossible to help you unless you properly explain what it is you're trying to do.
Started 4 days, 6 hours ago (2009-11-05 04:40:00)
by namliam
If the text is english, you can "simply" use CDate to convert the month/text to a real date then search on that...
Started 4 days, 10 hours ago (2009-11-05 00:36:00)
by Arjuna80 Arjuna80 is offline Registered User
Hi
Situation:
Trying to read out of a Table(Old) to set each Fields value in another Table(New) i had to write some routines to change the values.
In this situation, after reading out 15 other fields, for this one it (below variable: tmp) returns NULL, allthough the field contains a string: "x".
The fieldName "PerDu" is a boolean field in access 2000.
Code:
tmp = mGetValue...
Started 6 days, 7 hours ago (2009-11-03 03:43:00)
by DCrake
You code is wrong
There are three things you need to provide
1 the time value you want to see (days, months, years, etc)
2 the lower date
3 the upper date
Example
Elapsed = DateDiff("d",Date(),[DOB])
This shows the differenc ein days between the date of birht and today.
Form more help type in DateDiff and press F1.
David
Started 4 days, 23 hours ago (2009-11-04 11:51:00)
by boblarson
Are you using the FORM's before update event or the control's? It should be the FORM's event that you are using. That way if any other control has something either entered in it by someone or an edit is made, it dirties the form (provided it is a BOUND form). Then the Before Update event WILL fire whenever you either try to navigate to another record OR even closing the form.
Started 6 days, 15 hours ago (2009-11-02 19:56:00)
by pbaldy
An append query adds new records, an update query modifies existing
records.
Started 3 days, 3 hours ago (2009-11-06 07:27:00)
by someboddy
What do you mean by "can not seem to create the combobox"? Is access not letting you draw it on the form? Or is the problem in populating it?
Started 4 days, 1 hour ago (2009-11-05 09:26:00)
by music_al
Your post is a bit unclear, but if you are asking how to increment a value in a textbox by one each time a button is clicked, then on the click event of your button you need something like...
YourTextBox.Value = YourTextBox.Value + 1
Started 1 week ago (2009-11-02 09:33:00)
by boblarson
My suggestion -
Visual C#.NET
Started 4 days, 9 hours ago (2009-11-05 01:30:00)
by AstroDonut Registered User
I un-tick the 'Display Database Window' option on the startup dialog box, close the database and re-open it, everything is fine until I open a form in maximised state, after this the database window is visible for everybody to see!!!
Have I missed something???
Please help
|
|