I have a form/subform in a parent-child relationship. Is there a method I
can use to give me the total number of records currently displayed in the
sub-form (the child form)? Currently I am doing a "select" and then getting
the recordcount from the recordset object. Another ...

I'm currently building a bibliographic database system for our company. This
system requires several user-friendly "criteria" forms.
What I specifically want to do is construct a main form with a subform. The
upper part of the main form will have criteria fields and a search ...

I have a form "UserSoftware" which has two fields: An SoftwareID Field and a
SoftwareName field.  The ControlSource for the SotfwareName field is a
DLookup to find the value in another table based on the SoftwareID value.  
This is the syntax for the DLookup, and it works great in ...

I have a form which will display one of several different question groups.  
On this form, if the radio button "NO" is selected you must make an entry in
the [supplier] field.  I conditional format the [supplier] field to enable if
"NO" is selected and when the "Audit Complete" ...

I want to get the active control to send to routine when a button is pressed
on the form, but all I'm getting is the button as the active control. Is
there a way to get the control that was active before the button is pressed?

Hi, I have set up my dbase to use the office file open/file save common
dialog to allow me to select a file for importing. When I put the dbase on
another machine the references show 'Microsoft windows common controls - 2
6.0' as missing and I can't find it listed. Can anyone ...

Hi I have a form called "OpenAccounts" that opens on a after update
procedure, from my Incident Data form.  The "OpenAccounts" form is linked to
a query which finds matching open accounts, that part works fine, apart from
it fines the account that I have just opened.  The qry ...

Hopefully someone can help me here...I have an unbound form and 14 unbound
text boxes which I am using to search a table for data.  I have been told the
best way to go about this is to create a string and then apply the string to
the recordset.  I have no idea on how to do this.  ...

I have a form that has 2 text boxes (ESN, Serial Number). I have a lookup
table that when i enter the ESN into the text box pull in the customer info.
I have the same thing happening when the serial number is entered.
Problem: when the ESN is entered, i want to populate the serial ...

Why do I keep getting a type mismatch error with the following
statements?  I have "Microsoft DAO 3.6 Object Library" established as a
reference under the Tools menu but it still doesn't work.
       Dim rst As DAO.Recordset

I'm trying to get a form to open to a record corresponding to the operating
system User Name.
I'm trying to use the following code:
Private Sub Form_Open(Cancel As Integer)

seem like i am running the Database Access and running the Form, and create a
button that to add extra fields such as User1.LastName and User1.FirstName,
and during the Form you press a button "Insert Extra User" you will see
another User2.LastName and User2.First and maybe you can ...

I created a table w/start & end dates.
Then I created an auto form from that table w/ the fields.
I need the End field to calculate 3 months into the future from the Start
date.

I have a form that has 2 command buttons. I need to put a value into a table
based on which one is pressed. IE: close or open if the button close or open
is pressed. this should go in the same column of the table. any ideas?
thanks.

In table 1 I  set servicedate in the table to have default of date()
Instead of this, I came up with the idea that whenever I click the command
button to open form1, a dialog box/message box opens up tfor me to input a
date into a "variable" which populates the servicedate as a ...