I want my user to be able so see the processing of records as my db runs a
query.  They are working with large recordsets, up to 1,000,000 records.  
Now, the query bar moves very slowly and not at all for minutes at a time.  
What I want is for the user to see, "processing 2,154 ...

I'm trying to instert the following in the criteria section of a query in
query builder; the itself is the record source for a list box
*******************************************************************************************************
If Forms!frmPtDemographicNew ...

Checkbox name is count and command button name is Update.  When I click the
command button I want the checkbox to = true.  I have tried these two things
and both tell me the the form is read only.  Can someone please give me the
correct code?

I have a large tab control and I added a smaller one to it. I only want the
smaller tab control to be displayed when I am on the first tab of the larger
one. How do I attach it to the larger tab control's first tab?
Thanks

Hi All, I need assistance with the following code am using to send an email
from my form.
rivate Sub Command21_Click()
Dim SendTo As String, MySubject  As String, MyMessage As String

I was looking at the task manager and just noticed that Access isn't
really closing when I exit my application. One copy of Access shows up
in the processes list for each time I open and close the application.
(It doesn't appear in the applications list.)

I am trying to intercept the space bar key entry in a textbox to insert
special characters.
Private Sub ClientEmail_KeyPress(KeyAscii As Integer)
   Dim strEmail As String

hello!!
i am making inventory system in access can any one guide me how to handle
grid in forms the problem is that the values that i get from DB overwrite in
first row of grid it is not going to second row the data can't move in second

Good afternoon,
Would someone tell me how to supressed message from Access but give a
message of my own words. I know there is a setting in Tools --> Options -->
tab Edit/Find, there is a section which headed Confirm. I know I would

I´m working with Access2003, I have a form of "clients" where I can write  
"time" and "date" when I want to call back to each one. Right now, the msgbox
only appears if I have the form of that customer open on the screen, so I
have to run everyone to know if there is any call. ...

I have my primary key as a combo box where you can search for the correct
key.  When the user finds the correct key how would I have the rest of the
data show up below it?

I would like a button on a form to open a 3rd party website and
automatically enter parameters into the .asp website to directly open
up the search results.
I think I need to use the Followhyperlink command, and I can get it to

On a subform I'm receiving a #name? error in Access 2007.
I have a form/subform that is displayed on a tab in another form.
Yes a form with a tab control that has a form/subform combination.
When I display the form/subform outside of the tab it works, no

All,
I am trying to filter the records from a table displayed in a combo
box using a combo box on the same form. I built a query and set the
criteria as Me![FormName]![Combo_box]. This allowed me to filter the

I have just upgraded from Access 2003 to Access 2007 and converted my
database.  All is well, except one form appears to be broken.
The form (frmDiscography) is based on data from three tables.
1) tblMusicography (PK = fldMusicID) - also contains fldTrackID)