I split my database manually and put the back end on the network drive and I
put the front end on each users C drive.
Once the front end is copied to the C drive I made a shortcut to the desktop.
Is this ok?

I have created a database with 15 columns, input info, saved, had more info
to input  opened found my July info in the middle of my April info, copied,
pasted back where it belonged, saved, deleted the extra rows, saved again,
closed, reopened, July back in the middle of April ...

I have a form for tracking potential failures. The teachers must enter the
numeric grade at 30 weeks, 33 weeks, and 36 weeks (Each week is its own field)
If the most recent grade is  below a 70 then I need a check mark in the
Failure check box.

I have a form where I need to display the workgroup name that the user
logged in on.
How?

I have two tables I've based a form on. The first one if for cat breeds and
general information. The second one is for when I calculate the number of
cats in that breed (for a game) and the date it was calculated. I want the
date to be the same for all the cats, but the numbers ...

Hi
I am new to Access and am having trouble with getting a date to
automatically enter into a certain field.
I have a form onto which I enter information regarding a customer. One of

I’m creating a database to keep track of various options and components but I
am having trouble with some areas of the database development.
The manufacturer I work with creates a product which I shall call a WIDGET.
Each Widget is serialized with a unique number (a primary key). ...

I want to run a macro that (in plain English says) if tableA exists then
open formA, if it does not then open formB.
I thought this would be a conditional macro using Iif, but I do not know how
to say "if the table exists".

I've probably an easy problem but I can't really find a solution on my own.
Question:
I have made a table like this:
column1  column2  column3 column4

Microsoft Access 2003
I have an "Edit record" button on a subform (as for detail line items in an
invoice for a particular customer) to enable allowedits when it is clicked.
How do I disable allowedits when moving to a new set of records (as for a new

I'd like to use this template
http://office.microsoft.com/en-us/templates/TC010178391033.aspx?CategoryID=CT011
366681033
but it has been a really LONG TIME since i used Access and forgot some basic
principles of table construction and how to link them ( relationships).

I have a form which uses update query.
The problem is intermminent, what happens is  get the below mentioned error
message when I try to run Update query, any ideas?
The changes you requested to the table were not successful because they

4/6/06
I had just typed two evenings' worth of email addresses with the intent of
doing a mass email for recruiting purposes to prospective clients.  I "sent"
the email and it immediately came back "error...check your SMTP server".

I keep getting an error when I switch from Design View in a form with a
subform to Form View. It says "this expression is typed incorrectly or is too
complicated to be evaluated".  I know it isn't too complicated, since I only
started using Access a day or two ago!  I built the ...

Help please, I am trying to count the number of items in a [field] on a
report that are not 0.  Nothing wants to work I have been studying all the
different methods on the forum but nothing will do it.  I have also tried to
not display the zeros but all I get is errors with