I have a parameterised select query which works fine, and a form that the
user fills in.  On the form is a combobox bound to a field in a table.  Now
what I would like to do is have the user select an option from the combobox
and then run the stored query so that corresponding ...

I have a table that has grass % cover and tree % cover. Each of these fields
are expressed as a number rather than a percent. Is it possible to add an new
field to my table that adds the grass % cover and tree % cover together to
give me a total % cover value.

Sorry not sure if this posted.
Does anyone know if there is a list of codes and there meanings.
Ed

All,
I am just done with developing my database, thanks largely to this community
for all the help. Now I need to make this database an application mainly
because I don't want the user to see the database as that would cause

This is a Query/VBA question.
I have a query which is returning a listing of people past due by month.  
Thus, an individual's name may appear more than once if they are past due for
more than one month.  I am using vba to perform this query and then wish to

I have a saved file spec which needs to be updated periodically. Is there a
way to automate the updating of the file spec? (ie refer it to a saved table
or excel worksheet)
Background: This saved file spec is referred to during an automated daily

Please help me i am new to this and i would like to automate using outlook.
(i have never automated with outlook. i know that its kind of different than
the other MS apps). there is one catch. if I were to automate and use just
the regular functions i would not be posting here. i ...

I have the following code that checks to see if the master table has
TBSGROUP as null value when compared to the TBSGROUP in the main table. If
there is null value in MASTER TABLE then I am trying not to allow the report
menu to open up. At the same time I am displaying message ...

Hi All.  Hope someone can help me.  I have a table that contains the
following fields: claim#;line#.
I need to count the occurances of line# within each claim and update the
line# with the sequential numbering of each line: ie:

Loading a picture into a table field can be done by hand:
- Open the Table with the OLE field inDatasheet view
- Right Click on the field and select "Insert object ..."
- Create from file

I am having issues getting access to store when using the
ConvertCurrencyToEnglish function.  I set the ConvertCurrencyToEnglish
function as the control source for the control on my form, but how do I tell
access to store that  in a certain column within my database?

I have a number of lists that I want to select from and transfer to one list
box. This will then be pasted in  document any ideas how to do this?

I hope someone can help me out...
I'm trying to import an excel file that is updated daily, same format,
naming convention, except that date and time are added to the naming
convention...

Hi there, I've got a bit of a strange request since im not sure its possible.
Basically we have a database that lists all our current jobs and quite often
when there are a few going on we are always switching to and from record and
each time removing filter and filter for a ...

I'm using Access 2003. In my database I make tables from sum queries so that
I have a sum query table for every working day of a month. Once a month I
make a backup of my database (backend file), and after making the backup I
would like to delete the sum tables from the original ...