How do I create a command button or toggle button to show/hide
subforms?
Or is there some kind of a macro that you could share that will do
that?

I am really new to VBA,
currently I have one form were I create meetings, than another one were the
individual is inputted(frmAttendance = qryAttendan = tblAttend)  I am opening
a form(frmTravel = qryTravel = tblTravel) from  a button with in

I'm still in the very early learning stage with Access. I'm trying to
use the DLookup feature using the following code:
=DLookUp("[Rate]","Rates","Rates![RoomID] = [RoomID]"). I have
verified the code by using Ctrl-G, but it will not work in my form.

I have a form based on a table where I want to store data. The data to store
comes from combo boxes based on various lookup tables. The wrinkle is that
there is one lookup table that contains 2 fields of data (questionnum and
question) I want stored in the table once the ...

I have a form with a number of combo boxes in the header to act as a filter
for each column.
Each combo box has been assigned the appropriate tag and has the following
code on after update:

I have a form which contains tabbed subForms, each subForm pulling data from
their respective tables. However, none of these forms talk to each other and
I don't really know the purpose of the Link Master Fields and Link Child
Fields sections. But i'm pretty sure this has ...

           I tried to linked dbase file in Access 97 and delete the records
in that table. However it is read-only. How can I delete the records in
table? Thanks.

I am concerned about a malicious user Over-Writting the current
BackEnd datafile with an old BackEnd datafile!  I'm looking for
suggestions for detecting this condition with code.
ThankYou

If a control is disabled, therefore greyed out, the associated label becomes
greyed out too.
I have a nice shade of blue for all my labels and that is overriden in any
label where the control is disabled. It's fine and proper that the control

I have two fields on a form: NCR_No and Insp_Date. I want to make it so
if a user enters an NCR_No, an error message appears if the user did
not enter an Insp_Date telling them an Insp_Date is required.
How can I accomplish this?

I have the subform Order Details based off a query to add new order details.  
It is a subform of the orders form. Yes very predictable.  Anyway, when I add
info then go to the next order record, the data in the subform from the first
order remains.  Any help??  Thank you

I have created four separate input forms for sales reps to enter information
for an admin person.  I want to keep the forms (and the tables associated
with them separate). Each of these individual forms is based on a query such
as LetterRequestJoeQuery which is then based on the ...

I have a database with two tables tblbusiness and tblindividual. I have a
form, frmregistration, with a control source qryregistration, a query
combining the two tables joined on txtbusinessname. On the form I have a
combobox control, cmbbusinessname, based on the table ...

am really new to VBA,
currently I have one form were I create meetings, than another one were the
individual is inputted(frmAttendance = qryAttendan = tblAttend)  I am opening
a form(frmTravel = qryTravel = tblTravel) from  a button with in

Hi Groupies
My Main form (frmProjectMaster) contains 2 levels of subforms. The first
subform is frmCompartmentsWizard. frmCompartmentsWizard contains
fsubBlocksWizard and fsubReefersWizard. On fsubBlocksWizard, there is a