I have a Schedule of Rates stored in a table.
tblRates:
Code (pk)
Description (Text)

Thanks in advance ...
I have a query joining 3 tables say a,b & c
every record in a maps to one or more in b and one or more in c
I have written a query to fetch me all the records in three tables and

I could use some help.  I need an integer or a long integer field that keeps
it's leading zeroes.  Is there a way to do this?  
Thanks so much.

I'm trying to add a custom list of 2 items in a combo dropdown in a form.
The code I'm using is 'partially' working.  The problem is this:  Even
though I'm scrolling through the list (a filtered list of records), it grabs
the record #1 info to build my dropdown list.  They want some ...

I have a form with lots of tabs and fields which currently allows everyone
to update all fields.  Security is not being used.  Now I need to allow
certain users to update all fields and the others be read only.  I have a
table of users by network logon and I use the userid in my ...

Hi
I was wondering if anyone could help me.
I want to make a user interface for the user to use the database, but I
don't want them to see or access any tables, queries, etc...

I am trying to automate something but am hung up by a dialog box asking me
to confirm printing something.  I need for my macro (or module) to be able to
press the enter key.  Then I need it to to a tab key and then enter again.  
Is there a way to make that happen?

I'm trying to write some vb code in access that takes a 20+ checkboxes form
and returns any checked columns from a table into an excel spreadsheet.  I
got this far with at least the correct SQL statement.
'MY CODE SO FAR:

I tried that but the problem I have is ...
The results show up on the screen for textbox 1, textbox 2, and textbox 3
(That's fine)
but

I have three text boxes.  When a user manually inputs data in one text box, I
want the other two boxes updated automatically.
In other words, everytime Textbox 1 is updated, Textbox 2 and Textbox 3
automatically are updated.

In one of my form, I’ve created 20 check boxes c1,c2…c20 (these checkboxes
are not grouped), and a OK button and Cancel button. Now I’m interested in
which checkboxes the user ticked. So I’ve written a click event procedure for
the OK button. But it’s a mess if I check the value of ...

I have a form with a Treeview control and Sub form on.
When a user selects a node from the Treeview, the Sub form is requeried to
show the data for the newly selected node.
Is there an event that runs when the data changes in the sub form?  I need

Why does this code only work on the last item selected in the listbox? I have
a feeling it has to do with opening and closing the recordset????
I am using this on a form that allows the user to update a field (that they
chose from a combobox) for multiple records (they select in ...

I am trying to figure out how to get this to work.
Let's say I have 100 buildings to inspect. I have a form created that I can
view the details of each building. Then every month we inspect the buildings
and the report is scanned into a PDF and sometimes they may have a Word or

I have tried for the last hour to solve this one but it is really annoying.
I have a form with 26 controls A0 to A25. I am trying to programtically add a
DLookup to each of the TextBox controlsources.
It is the third part of the DLookup that is the problem. "[BtnNo]= 0" would