I have a Sales Service database to track service and sales calls.
I've also got an Audit Log attached to track changes to records.
The other day, one of the records changed it's self from "Sales" to "Service".
It didn't show up on the Audit Log as if someone changed it, it was Sales ...

I have several unbound data input forms, and in each I have a boolean
flag variable to indicate whether or not the user has saved their
input.  When the form closes, I check this variable; if it is false, I
ask the user if they're sure that they want to continue closing and

I have a combobox on a form (cboComp_Num) and I have the following code that
runs with the Change Event for the cbo_Comp_Num:
Me.txt_Price_Zone = Me.Comp_Num.Column(1)
Me.txt_Comp_Name = Me.Comp_Num.Column(2)

I made a form in my database, but when I go to enter data, the field that has
the current date goes empty and I get an error message that says 'field
cannot be update.'  When I click help, is says 'possible causes:  You tried
to update a field in a record or table that is ...

Not sure if this is even do-able or not.
I have a form (lets call it FORM A) that has details information about each
Case.  Each case can have multiple Collection records.
I want text box on FORM A that just tells me the number of Collection

Main Table = MainTable
Second Table = SecondTable (has relationship / tied to main table)
Main Form = MainForm
Have a button in MainForm, when clicked, lets say it copies the data from

I have aged failed in a table that get initialize during initial data load.
I would like for this field to increase by one each day goes by. This field
is locked on the form level.
The initial code for loading the field as follow:

I'm trying to creat an input form that will add/update/edit tables in
multiple files

I create an Option Group Name (Frame 159)
Control Source (Loc) with three values:
The option Group on the form is displays ED, EU, EZ.
However, when this saves to the table (which is a Text Field) it only stores

Hi.  I'm new to Access VBA, so I'm erring on the side of too much
information rather than too little in the hopes of receiving a clearer
answer from the community...
I'm working on an Access app designed to track status to contract with

I would like to create a combo box that would allow users to select reports.
Any suggestions?

I link the 1st form with 2nd form using Master/Child without open a new form
window, I put all the forms in Tab Control, that works fine.  I also have a
button in the 2nd form that intends to show all records in the 2nd form,
DoCmd.ShowAllRecords.  However it seems not ...

I need some design help with a check box / vb code.
I have a form called Company_Main which gives the basic information of
company. The address, city, state, and Zip comes from tbl_Address.
Address is txt, Zip is a cbo from tbl_Cities and city and state are

Hi. I'm using this mask for a phone number mask:
!\(999") "000\-0000;0
Now, we have international phone numbers as well.
I'm wondering if I need to add an international phone number field as well?  

I have a form where the contents of a list box is taken from a query
containing the counties in the Uk. When i click a county and open a report it
should display a summary of all customers in that county. I have named the
list box "list8" and have used the criteria [Forms]![Main ...