Forum: Database Design
June 5th, 2010, 12:05 AM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 10
Views: 5,373
|
|
Forum: New Users
June 4th, 2010, 07:21 PM Posted to microsoft.public.access.gettingstarted
|
|
Replies: 17
Views: 4,999
|
|
Forum: New Users
June 4th, 2010, 07:18 PM Posted to microsoft.public.access.gettingstarted
|
|
Replies: 17
Views: 4,999
|
|
Forum: Using Forms
June 4th, 2010, 07:14 PM Posted to microsoft.public.access.forms
|
|
Replies: 1
Views: 2,451
Forms or Tables
Rach
If you have "comboboxes in your table", you probably used the lookup
datatype. This can cause you headaches later on because Access stores one
thing (the primary key of the looked-up value),...
|
|
Forum: Database Design
June 4th, 2010, 05:54 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 10
Views: 5,373
|
|
Forum: Using Forms
June 4th, 2010, 04:35 PM Posted to microsoft.public.access.forms
|
|
Replies: 5
Views: 2,686
Date query
For the benefit of potential future posters looking for a similar solution, consider posting the SQL statement of your query...
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author...
|
|
Forum: General Discussion
June 3rd, 2010, 08:48 PM Posted to microsoft.public.access
|
|
Replies: 9
Views: 881
|
|
Forum: Database Design
June 3rd, 2010, 08:23 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 4
Views: 2,962
My database loads but disabled?
Someone in the future may run into the same issue you faced.
If you provide the solution you found, you could be helping that (future)
person...
Regards
Jeff Boyce
Microsoft Access MVP
|
|
Forum: General Discussion
June 3rd, 2010, 08:16 PM Posted to microsoft.public.access
|
|
Replies: 14
Views: 993
Two autonumber fields in one table possible?
Sharon
It sounds like you/researchers are trying to use the sequence number to
"count" the number of records. If so, stop now!
If you use an Access Autonumber, there's no guarantee that the...
|
|
Forum: General Discussion
June 3rd, 2010, 07:43 PM Posted to microsoft.public.access
|
|
Replies: 9
Views: 881
|
|
Forum: Running & Setting Up Queries
June 3rd, 2010, 07:39 PM Posted to microsoft.public.access.queries
|
|
Replies: 7
Views: 571
querying unrelated tables
Keith
So you're saying that the daterange does NOT have "empties" for the dates
that are holidays, counter to my assumption.
I didn't see anything describing where you are storing the "pay...
|
|
Forum: New Users
June 3rd, 2010, 07:32 PM Posted to microsoft.public.access.gettingstarted
|
|
Replies: 17
Views: 4,999
|
|
Forum: Using Forms
June 3rd, 2010, 07:20 PM Posted to microsoft.public.access.forms
|
|
Replies: 8
Views: 1,363
Skip pattern based on text box value
The design of your database isn't an "aside".
"How" depends on "what" ... and the "what" is the design of your database.
It all starts with the data!
Regards
Jeff Boyce
Microsoft Access MVP
|
|
Forum: General Discussion
June 3rd, 2010, 07:18 PM Posted to microsoft.public.access
|
|
Replies: 3
Views: 513
One field, multiples entries
Patrick
I'm with Larry ... yes, you can, but WHY?!
Sticking more than one fact in one field means locating the one fact among
many in the field just got that much more difficult!
Far easier to...
|
|
Forum: General Discussion
June 3rd, 2010, 07:16 PM Posted to microsoft.public.access
|
|
Replies: 3
Views: 769
|
|
Forum: Running & Setting Up Queries
June 3rd, 2010, 05:37 PM Posted to microsoft.public.access.queries
|
|
Replies: 7
Views: 571
querying unrelated tables
Keith
It sounds like you are saying that you want to see each employeeID and each
date (on the "PunchTime" table), plus the time in/out if the date is not a
holiday, and the holiday's name if it...
|
|
Forum: Database Design
June 3rd, 2010, 05:30 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 4
Views: 2,962
My database loads but disabled?
"...does not work" is not particularly informative.
Do you mean:
- the PC freezes up and displays no error message?
- the PC catches fire?
- Access produces an error message ... that...
|
|
Forum: Database Design
June 3rd, 2010, 05:28 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 10
Views: 5,373
|
|
Forum: Using Forms
June 3rd, 2010, 05:15 PM Posted to microsoft.public.access.forms
|
|
Replies: 8
Views: 1,363
Skip pattern based on text box value
Nope, I was trying to imagine modifying the form every time I needed a new
question.
Consider looking into the more normalized survey/questionnaire design
offered by Duane H.:
...
|
|
Forum: Using Forms
June 3rd, 2010, 05:13 PM Posted to microsoft.public.access.forms
|
|
Replies: 8
Views: 1,363
Skip pattern based on text box value
Not sure how this responds to the original poster's request...
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post....
|
|
Forum: General Discussion
June 3rd, 2010, 05:12 PM Posted to microsoft.public.access
|
|
Replies: 14
Views: 993
Two autonumber fields in one table possible?
As long as your approach requires you to "assign the next sequential number
.... (e.g. B1825)", you are still confusing data with display.
If you have a category field ("A" or "B" ...) and you have...
|
|
Forum: General Discussion
June 2nd, 2010, 11:16 PM Posted to microsoft.public.access
|
|
Replies: 1
Views: 516
Page numbers
This newsgroup supports Microsoft Access, the relational database.
I'm not sure how to interpret your question...
Regards
Jeff Boyce
Microsoft Access MVP
--
|
|
Forum: Using Forms
June 2nd, 2010, 11:09 PM Posted to microsoft.public.access.forms
|
|
Replies: 5
Views: 2,686
Date query
So if you use a query to inspect that field, and it sees any characters, that makes it a less-than-one year old, right?
I guess it would depend on whether the 1901 is 1/1/1901 or...
|
|
Forum: Using Forms
June 2nd, 2010, 09:58 PM Posted to microsoft.public.access.forms
|
|
Replies: 5
Views: 844
Combo Box Adding Button to edit list items
Have you looked into using the NotInList event and the LimitToList property?
That would do away with having to add a button and force the user to click
anything...
Regards
Jeff Boyce
Microsoft...
|
|
Forum: Using Forms
June 2nd, 2010, 09:57 PM Posted to microsoft.public.access.forms
|
|
Replies: 8
Views: 1,363
Skip pattern based on text box value
What is the data type of the field underlying that control on the form?
Are you saying that you have one control per question? If so, what happens
when you add/remove a question? Doesn't that...
|
