I have two pass-through queries in my database.  Each one draws from another
database on our network to populate two fields with drop-down lists.  The two
fields are on our Main form (which we use to log in jobs).
I had set the pass-through queries up with ODBC DSN connections, ...

I am trying to assign the values I want to appear in a ListBox, but am
having no luck. With a ComboBox, I could create a semicolon-separated list,
set my RowSourceType to "ValueList" and assign my list to it. With the
ListBox, that seems to not be the case. Is it possible for me to ...

Good Day,
 I use a cbobox to search for specific dates within my tblorders, and it is
possible for my multiple orders to have the same date value.
 Is is possible to limit my cbobox only to single date values and not their

I am getting  run-time error 3008
'The table (TableName) is already open exclusively by
another user, or it is already open through the user
interface and cannot be manipulated programmatically.'

I need to read in a binary file 100 bytes at a time, do some processing ,
then write the results to a binary file i create. I don't want to read in
the whole file at once because it could be huge.
I would like to do this without using "Scripting.FileSystemObject".

I've done this time and time again, but it's not working in the following
case.  Anyone see anything that I could be doing wrong?
Dim stDocName as String
stDocName = "Statement"

I have an access application running in both Access97 and Access2003. I’ve
got a procedure who’s purpose is to lock all of the bound controls in a
form while allowing the unbound controls (typically controls used for
selection and navigation) to continue to operate.

I have a multiuser database, and we are getting the
following error on only some of the workstations:
Run time error '459':
Object or class does not support the set of events.

I'm attempting to update the date field to the current date if a record is
updated using a form. I'm not sure how to do it. Can you help?
Thanks.

I have a parent form (char_frm) with a subform (char_sub_frm) linked by
playerID(one player, many characters).
The parent form shows the character’s name (Cname) and other info.
The subform shows all of the alternate characters that a player has

In using Lyle Fairfield's SendMailWithOE, I discovered
that WAB names are not supported. I.e., one must use
a fully qualified e-mail address rather than a name taken
from the Windows address book. With that, is there an

Another field on my form asks for the user to "sign" their name.  All of our
computers are named as our first initial and last name when you look at the
computer name in "my computer".  I was wondering if there was a way to have
the user click a "sign-off" button and the field ...

Is there a way to get the IP address and subnet of who is currently using
the backend dbf?

Ok this is probably a very dumb question but it is making me a little nuts.
I have a subform that if you double click in a field it opens up a
information form based on the data in the field.  But I want to cancel the
open form if the field is blank.  Can't seam to get anything to ...

It appears from debugging that the Split function returns
a "zero-based" array EVEN if  Option Base 1 is specified.
Is that correct? If so, it sure screws things up if a Split
function is added to code that is already peppered with