Okay, here is the code I'm using.  I had it working but for some reason now
all I get is an error message stating Compile error, user difined type not
defined.  Before I was getting a different error.  What's wrong?
Option Compare Database

I shifted my fields around when constructing my form.
Now how can I make the cursor flow from top to bottom, left to right (there
are 3 columns of fields) after entering data?
Please help

Access Gerus,
How can I get Access to save text into a field to include a trailing
space if I don't want to use quotes?  I have tried the field's format
(space) option to no avail.  What am I missing?

I would just like to say “thank you” to all those people who spend a
proportion of their time to answer the questions posted by myself and others
in this forum.  If it was not for people like you, then duffers like me would
have given up ages ago trying to make a difference using ...

I have a combo box on a form which is linked to a table created to populate
the list once all the data is entered all the data is then saved in another
table.  What I need is for the user not to be able to enter any data into
this field only to select from the list.  Many thanks ...

Hi
i have a customer database for a garage - some of the customers are entered
on twice due to them having different cars ect, what i need to do is a
mailing letter only one per household/business. I do a query and its

I have a form with a command button which when clicked returns the users to
the main menu on the switchboard.  I have tried to add data validation but
when the button is clicked it gives the error message then saves the record
and returns to the Main Menu.  I have posted my code ...

I've got my query set up to calculate a 10 day alert 10 days prior to a due
date.  Finally, with a lot of help.  I want to set up an automatic email to
recipients.  I have code that works, but I am having trouble getting it to
run on the 10 day alert day.  I was wondering if I ...

I am trying to add three new records to a table, based on the record that a
user has just created using a form.  When the new record is created, I want
to add three more records with different record types and clear some amount
and date fields so the records are fresh for later ...

My header disappears from my report after the first page.  Is there a way to
make it always visable, regardless of what page of the report I'm on?  Just
wondering. Thanks.

hey, my name is sergio and im trying to set up a microsoft outlook account
because i bought a smartphone and would like to sync it with outlook. one
thing im not sure about is just setting it up in general. i made an email
address and password but im stuck on the servers part. ...

Here's a simple question.  I have a field in my form that displays a the
amount of time (in days) till something is due.  It displays negative numbers
for things that are passed its due date.  I was wondering how can I display
the negative numbers in red, so they are more easily ...

I seem to remember that there was a way to put today's date in the title
text in the report header but I can't find the actual "code" to do that.  I
seem to remember it had broken brackets, I think "<>" and text so that when
it printed out, we'd get SUMMARY REPORT AS AT TODAY'S DATE ...

I have a crosstab query on which I have based a report. This to be run
weekly to show sales per week with columns (previously products from a
field) such as apples, pears, nuts, etc.
Last thursday when I originated the query there had been sales of all

I am wanting to input data in my outlook calendar and to process and output
it in access.