I have created a form having one indexed primary field. when I add any data
to form and save it, by click on record mover [what I have created] , all
data are not indexed.

I have two forms that have  a one to one relation. I want my user to fill out
the first form and then if they need the second form they press a command
button and it opens the second form. I can't figure out the code for Access
to treat the second form as if it were a subform. I ...

I have a table in which are stored control names found on a form.
I want to loop through the records in the table and "enable" the control
names found in the db table...
How can this be done?

I've noticed if I try to reply to a message or rate a response, and I'm not
signed in, it takes me to the sign in page but does not redirect me back to
the appropriate post from there.
This is frustrating and usually means I do not bother to reply or rate the

I have a sequence of code in a click event handler as follows:
   stDocName = "ed-person"
   If CurrentProject.AllForms(stDocName).IsLoaded = False Then
       DoCmd.OpenForm stDocName, acNormal, , , acFormEdit, acWindowNormal

How on earth can you do this? I do not see a background colour property for
command buttons at all...
In VB you have to set the style to "graphical" to have this option available
to you - but I see no such thing in Access 2000!

I have a form with a record source of qClients which is a query of the client
table.  I want to be able to have a Combo Box on the form so that when the
user selects the Cleint using the combo box then the other fields associated
with that clientid will update on the form and the ...

Hello all.
Currently I have a query that gives information based on region and the
region is the prompt in the query (select query). The button I have on my
form, uses an event procedure that opens that query, and obviously the user

every time i type in this bit of code it gets automaticly changed can anyone
tell
me how to stop it being changed.
the newgpId() should say NewGPID()

I've form which I'm using for new input and for edit too, this form consist
of srlNo field where i m  writng transction nos like 1 2 3 and soon. This
form is based on recordset
strSQL = "SELECT * FROM [DataSub]WHERE DocumentNo =" & DocumentNo & ";"      

I found some error in Dlookup function like this below.
A=DLookup("AggType", "Tbl_Agg",
"[AggID]=[Forms]![Frm_Main_Design]![Child]![AggType]")
It work fine when i run in access 2002 but i got this error when i run with

Hi. Can anyone help with this one??
Im building a form which will allow users to create
records containing StartDate, StartTime, EndDate and
EndTime details as well as other information. I want users

Hi. I posted this early on 7th March but have had no
replies. Can anyone help with this one? If it's a daft
question, let me know.
Im building a form which will allow users to create

I have an access 2000 database that I just inherrited. Everything has been
working fine until today. I have a subform that has a drop down list that
after performs the follwoing:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

I have tried this under BeforeUpdate() and the following and I can't get it
to cancel the event.  I am trying to make the form give an error message if
no name is selected from the list.  Right now, if the EmlpoyeeID field is
left blank the form closes and updates the record.  ...