We are in the process of documenting our database.  The tables will be in
SQL and the data entry will be done in Access with a client / server
relationship.  We are creating another database that will store definitions
and also attributes about the fields, textbox and combobox.  ...

    The following code returns valid values with full Access 2000 BUT "" when
run with the Access 2000 /Runtime set.
' Different Response with RUNTIME
'MsgBox "Full Access Versus RUNTIME." & vbCrLf & vbCrLf & _

I am trying to develop the follow and am struggling with the dates - can
someone help please.
Date is to be input by user in dd.mm.yy format - ok using Input mask on
input field on form but how do I code the VB behing my form to set up the

My second cbo is dependent on the first.  I want the user to be able to
create a new subclass if notinlist.  The error I'm getting is
Too few parameters.  Expected 1.
on the Execute MySql line.

Using MS Access 2K on Windows XP.
I have a form with a bound text control and an unbound comb-box. The
combo-box is transparent and placed "behind" the text control.
What I'd like to happen is that when the text control gets focus, if there

I have a form that lists several files that we print out when needed. These
are forms done in Word and saved to a forms folder. Now the problem is this
some of the forms (printed pages) ask if I want to save and some don't. The
code I use for this is below

I have a form (frmWorkers) based on a query combining 2 tables.  The form
works great.  However, I would like to be able to use a second button on my
switchboard that opens the same form, but only where a checkbox (available)
is checked.  The problem is that the form opens with a ...

I have a form where I have a number of totals I would like to calculate (see
below for details). The calculations are done in VBA (because they pull
information from various places) and placing the return value into a textbox
on the form. I am trying to get the calculations to ...

I’m using VB to build up a SQL string. Is there some way I can include
double quotes in the string, for example through an escape sequence?
Thanks again
David

I have a list box in a form.  the list box is unbound. it displays a list of
medications for a patient.  2 tables are involved. the first table is
demographics, which the SSN comes from.  teh second table has SSN and the
medication.  the second table has several records for each ...

I'm new to Access and VB... I feel as though I'm picking up on things in
bits and pieces and that having a good basic understanding of VB would help
me tremendously.  Can anyone recommend a good (and preferably free) online
resource?

I have two combo boxes, one with county names, one with departments. There
are different departments for each county. Once a user selects a county name,
I'd like the department combo box to populate with the correct department
possibilities for the chosen county.

I have done this many times in the past and don't understand why I am getting
this error message: "Microsoft Accass can't move the focus to the
control....".
I am using a single form with three option groups: frame2, frame 12 and

I have a form on which I have a subform that has a control who's "visible"
property I want to set on load of the main form.
I have tried the following syntax but I keep getting an error stating it
cannot find the form I am referring to...

I have a drag and drop interface so that the user can select one or more
names from an unbound list box (List1) and move them to another unbound list
box (List2). (They can also drag and drop from List2 to List1.)
Once the user drags some or all names from List1 to List2, I would ...