Can someone please help me create a service vehicle dispatch program?

I have been trying to use VBA to maintain the values of several variables
until it is actually time to confirm them, and THEN make the record.
For instance, a user will enter data and choose values via msgbox prompts
and drop-down lists on a form (ie. the date, then choosing a name, ...

I have a form for keeping track of container information.   This form has a
subform that keeps track of the area that the container contents are held in.
 So my subform table has the containerID, an AreaID, and then the Area#.  I
need to print out a report that shows the ...

I need to put a function inot a table but cannot figure out / remember
how.Long time since  tried this!
I pasted the code into a module and I now need to access the code from the
table. It is a function that works out age from d.ob.

I have a multifield index and I want to set its Unique property to True or
False based on the value in another field. How is this possible?

I'm stuck and need some help desperatly.
what I'm trying to do is to create a universal function (stored in a module).
Inside the funtion i use the built-in function dsum to calculate something.
The dsum function needs a field, table and criteria. Im trying to pass these

i have a form in access to which i've attached an event module to allow users
to update the underlying table directly from the form (using AddNew).  the
underlying form is just a list of contractors with an AutoNumber index.  For
some reason, when users add a new item --the ...

You all are usually a great help. I got a good one for you. I am using
Access to create a spreadsheet, and I want to save it as a tab-delimited text
file. When I run it, it works fine except I have to accept several dialog
boxes about saving Excel as tab delimited instead of ...

I posted this in the input/export page and got some help, but my problem has
not been resolved.  So, I thought I would try here.
I have the following module that will do a Word merge from a command button
on an Access form.    I would like to replace the "Date()-395" with data

On my form, I have it set up so whenever I select a certain item from a field
list, the next box will either be enabled or disabled. Pretty simple.
But, what I have noticed, is that depending on the last record saved, if I
scroll back through past records, I notice that the box ...

I'm wondering if anyone knows how to access the values in different fields
in a recordset using a variable for the field name?
e.g. strFieldName is a variable that holds the name of a field in the
recordset rst1.

We have developed a database of personnel using MS Access.  However, a
different department is responsible for taking the photos of these people.  
We want to take their .gif files, and write a visual basic program that will
automatically put the photo with the database so we can ...

Does anyone know how to use a variable field name to retrieve values from a
recordset
eg
str1 = rst1!FieldName  

Is there a way to sort my VB Code in the VB Editor Alphabetically?  As far as
I can tell Access just plunks things in willy nilly and sometimes they are
hard to locate.
Thanks.

I have encountered some rather odd behavior of the TabView
control in Access 2000.
I have a need to move the TabView programmatically.
I don't believe I've ever had to do this before.