A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 15.70 seconds.
Search: Posts made by: Jeff Boyce
Forum: Database Design June 5th, 2010, 12:05 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 10
Views: 3,907
Posted By Jeff Boyce
db design to calculate overlap in group membership in time

You posted your question in a newsgroup that supports the use of Microsoft
Access. MS Access is a relational database.

It all starts with the data.

It sounds like you want to use a spreadsheet...
Forum: New Users June 4th, 2010, 07:21 PM Posted to microsoft.public.access.gettingstarted
Replies: 17
Views: 3,660
Posted By Jeff Boyce
Let's pick a replacement for this (Access) newsgroup

Hold on, are you saying that if folks don't agree with your approach, they
wish to be treated like children?

Using phrasing like that seems to imply that you think your approach is the
only...
Forum: New Users June 4th, 2010, 07:18 PM Posted to microsoft.public.access.gettingstarted
Replies: 17
Views: 3,660
Posted By Jeff Boyce
Let's pick a replacement for this (Access) newsgroup

You won't get any argument from me on whether "spirited discourse" or "calm
rationality" represents a better choice ("better" implies someone's correct,
other's aren't, and I've seen too many...
Forum: Using Forms June 4th, 2010, 07:14 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 1,745
Posted By Jeff Boyce
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: 3,907
Posted By Jeff Boyce
db design to calculate overlap in group membership in time

The example you provided may not have quite all the information it sounds
like you need.

Steve asked how you "group" the members/birds. In your example, are all of
those birds part of the same...
Forum: Using Forms June 4th, 2010, 04:35 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 1,963
Posted By Jeff Boyce
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: 642
Posted By Jeff Boyce
Only change font fomat in select words within a memo field

So you're saying that comments are being added to a great big humongous pile
of comments (i.e., a memo field)?

Would it make it any easier if each comment got it's own record, instead of
having to...
Forum: Database Design June 3rd, 2010, 08:23 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 4
Views: 2,076
Posted By Jeff Boyce
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: 702
Posted By Jeff Boyce
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: 642
Posted By Jeff Boyce
Only change font fomat in select words within a memo field

You've described "how" you are trying to solve some business need, but
nothing about what that underlying need is.

If you'll explain a bit about it, folks here may be able to offer alternate...
Forum: Running & Setting Up Queries June 3rd, 2010, 07:39 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 378
Posted By Jeff Boyce
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: 3,660
Posted By Jeff Boyce
Let's pick a replacement for this (Access) newsgroup

David

I was not aware that your posts were banned from UtterAccess, so I don't
have a dog in that fight...

I'll point out that if you have something to say and you wish folks to
listen, telling...
Forum: Using Forms June 3rd, 2010, 07:20 PM Posted to microsoft.public.access.forms
Replies: 8
Views: 1,113
Posted By Jeff Boyce
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: 351
Posted By Jeff Boyce
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: 582
Posted By Jeff Boyce
Display a message box "this entry is a duplicate"

Tina

Would you rather have a way to "find" an existing number if one existed, or
have your computer tell you that you can't use the number you just tried to
use?

It might be a bit more user...
Forum: Running & Setting Up Queries June 3rd, 2010, 05:37 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 378
Posted By Jeff Boyce
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,076
Posted By Jeff Boyce
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: 3,907
Posted By Jeff Boyce
db design to calculate overlap in group membership in time

Liz

If you haven't built a database/application before, and particularly an
Access (relational) database/application, there are (at least) four separate
learning curves you'll want to consider. ...
Forum: Using Forms June 3rd, 2010, 05:15 PM Posted to microsoft.public.access.forms
Replies: 8
Views: 1,113
Posted By Jeff Boyce
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,113
Posted By Jeff Boyce
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: 702
Posted By Jeff Boyce
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: 363
Posted By Jeff Boyce
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: 1,963
Posted By Jeff Boyce
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: 677
Posted By Jeff Boyce
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,113
Posted By Jeff Boyce
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...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 12:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.