I've got some code:
Dim strDiseases, FirstChunk, ConnectStr, strQueryName As String
Dim thisDB As Database
Dim fh1 As Integer

Is it possible to select a record in a subform, programmatically? Finding
which one is selected is the simple part; but how to actually select one?
Jonathan Scott

I'm writing an application that separates delimited address text generated
from a business card reading software. Because the addresses come in both
English and Chinese, I need a way to determine what characters are stored in
the field in order to separate the text accordingly to ...

I have a form that use a command button to append a table.  I get the
standard Access message box saying "You are about to append 1000 row(s)
that has a Yes or No button.  What I want to do is if the user press the yes
button I will have a message box appearing the same if the ...

hi,
im trying to set a reminder based on a date which I type into a field called
"transd" what I would like is 30 days after the date I typed in a message box
or feild box would pop up and tell me that i need to look at the "name"

I have a routine that works fine on some systems, but not on others. It's an
Access 2003 database, where I check for the existence of a certain printer,
and if it's there, go ahead and set it as the default printer, set some
attributes, and open a report in print preview.

I want the user to be prompted for a bill # as, or before, the form opens.  
If the bill # is an existing bill, the form should open to it, but if it is
not, it should open to a new record.
Can someone please help me with this?

Is there an Access control that behaves like a standard File Browser dialog,
like when you want to upload a document to an email etc.?
I have a field in my database which holds absolute paths to documents, and
I'll be using a hyperlink to display the data, so people can just click ...

Access 2003/XP:
I'm building a switchboard using a form that opens either of two other
forms.  The two other forms are used to open labels or reports.  All
forms are sized exactly the same height and width.  When the main form

How can I open Form2 from Form1, select a value for combo box (Combo 2) in
Form2 based on a combo (Combo1) in  Form1, and run the AfterUpdate code for
Combo2?
I am able to open Form2 and select a value for Combo2, but can not run the

I have a table with a boolean field.  How do I ensure the user can only set
the column to True for one record for the entire table?  If the user has
decided to set another record to True, the set record must be set back to
False.  Any ideas?

I am trying to build an anagram utility for improving Scrabble skills.  It
involves inputting seven letters and then creating a table with all possible
combinations for those seven letters (I have been able to do this pretty
easily).  I next want to check that table against a ...

I'm inserting rows in a listbox with:
Me!listbox.additem string
The listbox has the maximum of 255 columns. The string is always 2000
characters.

If I have frmForm1 containing a command button that opens frmForm2, is there
some code that I can add to the buttons On Click event so that frmForm1 does
not reappear when Form2 is closed? i.e frmForm1 is closed at the same time
that frmForm2 is opened.

I have been using Access for many years and am always learning something
new. I also struggle many times simply because I don't know how to properly
code something in VBA. There are many books on Access and most of them
include the fundamentals. I am looking for a more advanced ...