I'm trying to change the backcolour of all my forms and am using this code
in a module
Public Sub ChangeAllControlProps()
Dim dbCur As Database

I have a lookup table with 3000 records, so it's not really suitable for a
combo box.
What I want to do is have an input box up the top of the form where the user
enters a search, and a go button to perform the search.  Given the data, it

I have this code on a button that when pressed copies the data from the field
'run_waypoint' (based on a combo box) from each record on the source form to
a set of sequential fields [GetRound_#] on the target form. All works ok,
except that the code always goes one extra step and ...

I am in school and I have an assignment that wants me to show the keys and relationships in the sales contact database system that I did from the previous week assignment. I had to make a table with the information listed below:
Customer Name
Address
City

I'm using this to select a record in a listbox.
Is this code OK?
Thnaks
DS

Have a db created probably in Access 97, or earlier, that has worked in
access 2000 for 5 years just fine. After installing Office 2007 (left the
2000 versions of   Access, Word, and Excel on the PC)  I have a problem with
it.  Double Click on the file name, Access 2000 opens the ...

I was Woundering if  some one could point me in the right direction in
creating a button that will open my report,
This Difference with this button, is that the form has 2 lots a filter
option associated to it.

Need Some Help With A Simple Password Form
What a I Have Is Single Field Table, With One Record In It The Field
is Called [Password] table is also called "Password"
which ive created a form that represents this table, so the admin can

Need Some Help With A Simple Password Form
What a I Have Is Single Field Table, With One Record In It The Field
is Called [Password] table is also called "Password"
which ive created a form that represents this table, so the admin can

I am using a DSum function in a query to to perform a calculation on values
in another query. Thanks to Steve for helping me resolve an earlier problem I
had with this, but now I have a new problem. I want the result to be
displayed as a percentage, however, I have no format ...

I need a VBA code to convert my currency numbers into words :
For example I have a value in a Field :    1535.25
I want To be converted into One Thousand five hundred thirty five and twenty
five Fills

I'm trying to setup a form where if I type an account number on one
field the account's title will appear automatically on another field.
I already have a table created which has the accounts with title. If
someone can give me an idea on how to go about setting this up I would

I have created a database and a form in Access 2007. I can view data in the
form, but I can't append. I have been manually entering info in the database.
Would like to use the form to enter info. Not exactly new to databases, I
used dBase in DOS for 10 years. Any assistance would be ...

I'm trying to set up a multiselect box on one of my forms but I'm not
familiar with VB code to be able to store and save the values in the table.
I've tried searching these forums, but I haven't really found anything that
fits my needs (that I know of). Does anyone have any links to ...

I have a form to enter a First Name Last Name from a keypad on screen.
It works fine to input both First and last name into one field; however
is there a way that when I save the record I can split the first name
and the last name into seperate fields?  I know I can enter them