Is there a way at runtime to create a series of checkboxes based upon the
number of records in a table.
Ron

I have controls that show data from underlying queries, and I want the
double-click of several of them to open a new form based on a different
query (which uses the value in the control clicked as a filter).  This is
easy, but I'd like for the controls (textboxes) to look like ...

I have three levels of data: Client, Plan, and Project.  Client to plan is a
one-to-many relationship, Plan and Project are a many-to-many.
Users can search at any level using unbound text fields, and the results
populate a listbox.  Ideally, clients should then be able to click a ...

 I developed a database in Access 97. MsgBox works fine in Access 97, but
will only display part of strings (truncated??) in Access 2003 instead of
full of them.
 I wonder if MsgBox has length limitation in Access 2003?  

Is it possible scaling image to a specified scale using : ijl15.dll (the
tool to read and write jpg files)?
Select Case jpg_scale
         Case 1

Is it possible to invoke the compact tool in Access 97 from a MDE file?
If so, how?
If not, any alternative?

On the main form I have drop down boxes which allow the user to select 3
criteria for the data to view.  I then have a subform which does grouping  by
topic and then a subform within that subform that gives the details.  I am
updating the record source with vba without ...

I have a form which fills in the many side of a one-to-many relationship. In
the beforeupdate event procedure I have a routine which checks to see if
there is a related record in the one side of the join, and if not adds it.
This routine works if the record source for my form is ...

I have a table where the key is YYYY-xxx-zzz where YYYY is the year, xxx is a
building number which is obtained from a text field on the form and zzz is a
sequential number.  What is the best way to determine what the next sequence
should be? Table name is tblMOCform, key field ...

I want to be able to check if a form is open, aka  'IsLoaded',   but I don't
know how to create the basic function.
This is the (dodgy) code I want to use in A97, and I need to create the
function cos it tells me that sub or function not defined etc:

Is it possible to use a key press sequence to start some
code?  I need to use CTRL+ anything or similar and have
it set to start an event.
TIA

I am using the following code to check the links in my FE.
   sConnect = ""
   For i = 0 To db.TableDefs.Count - 1
       If db.TableDefs(i).Connect <> "" Then

I have a list of clients in a form.  Beside each client I have a button.  
When the button is clicked it opens a dialog form that I would like to show
information about that client.  However, when the dialog form opens, it is
always on the FIRST record from the first form.  How ...

I have a main form on which I have a watermarked background picture. I have
a subform on which I want to have the background be transparent so that the
watermarked background of the main form can be seen...  Is there a way to do
this as I haven;t found anything ...

I have a form with a subform with in it, they are linked by SSN and LastName.
when i create a new record in the main form i want the subform record to be
created automatically with out having to type anyting in it. even if it is
only hte SSN and LastName that is filled out. how ...