I did these 4 steps to create a topic file
1    Open a new file in a word processor or text editor that can
handle rich text format.
2    Write your individual topics, separating each topic with a

A.K.A. Is Double Dating a bad thing :-)?  My post from several hours
ago may have gotten lost so please forgive me if something similar to
this shows up twice.  From a modular programming class I took many
years ago I was taught that it is important to maintain a good

I have a field on a form for project number.  I basically want it to be
the next available number (ie 06010 then 06011 etc).  In the form I
create a text box and under control source I put:
=[Projects]![ProjectID]=[NextNumber]

I need to take specific data from a access db and merge it with a word
doc.  I know how to do the general mail merge using access and word,
but for this I need the user to enter peramiters for the query that the
merge is run from.

I'd appreciate help converting student average test scores into grades. My
problem is that I need to allocate one of about 20 grades (3a,3b,3c,4a,4b,4c
etc through to 8c plus a couple of others).
This comes up as too complex using nested IIf, then, else.

context: (vb6 / ado / .mdb / jet4.0 / not using access)
hypothetical problem
say I need to track the properties of boxes.
There are three kinds, cardboard, wood, and sheet metal.

I have a check box on one of my forms, let call the field "ceased?",
and when it is checked I would like the current date put into my date
field and the "ceased?" field protected.
Would anyone know the code to do this?

I'm updating my asset management database I created. I would like to
put two fields in my main form under the warranty heading. The first
field will say Warranty Experiation Date and the other will be a locked
field which I want to display "Day's Left", from current date as the

I'm updating my asset management database I created. I would like to
put two fields in my main form under the warranty heading. The first
field will say Warranty Experiation Date and the other will be a locked
field which I want to display "Day's Left", from current date as the

I need to create multiple PDF files from one access report that breaks
on client for approx. 20 clients.  Any suggestions?   Thanks!

This is my first try at running Access Report by Visual Basic
I have the following code in my button press event:
   ' 2 - Show print preview
   objAccess.DoCmd.OpenReport "Invoices", 2, ,

I have encountered a very strange problem that is hard to describe, but
hope someone has run across it.
I have a form that shows a number of columns from a single table in the
upper portion of the form in a datasheet layout.  The user can then

Generally, it is the case that space characters in the names of things
can cause difficulties, and removing the spaces can make things work
more smoothly, but I recently found a reverse case.
I had a full path to an MDB file woth no space characters, and I

I know this is a difficult one to answer, but I am interested in opinions on
what hardware upgrades would be recommended with the following.
Access 2000 running in a split config, but all in Terminal Server. Currently
15 users. This means that all files reside on the server and ...

i'm designing a video and games rental database.
i've got the customer table, with all the correct and relavant details.
i've got a films, and games table.
But i'm confused which way to link them.