I am creating a table using access and already have a data
table.  I want to create a new one with new data and a
different name for the table.  
How can that be done?

I am trying to design a database which will store events which occur on the
same days every month for 6 months of the year and this obviously will not
be the same date.
I have some where in the region of 70 diferent organisations for which an

Hello group:
I have a form in which I set that is read only, but I have
been asked to add an edit button so that people can add
and change the data as needed. Here is the problem, the

I would like to calculate the difference in mileage between records filtered
for a specific vehicle. I also could not find a means of determining the
current record # as  I can in other databases by using a recno() function.

I've got the following query and it works fine.
SELECT tblMasterClients.ClientName, [tblMasterClients].[AlphaPrefix] &
"-" & [tblMasterClients].[SiteId] & "-" & [ClientType] & "-" &
Mid([DID],InStr(1,[DID],"-")+1) AS [Client Number],

I really, really hope someone can help me.  I have been
working on this problem for days and days, etc.  
First off please know the following:
I have created a database.  I am not a programmer; I am a

I am migrating from Access 97 to Access 2003. I converted an access 97 file  
to Access 03 db. the size of the Access 97 file was 7,778KB where as the
converted access 03 file size was 2,736KB. When I compared with a db
comparision tool for the differences b/n the two db's, it ...

I have a Form automatically loaded when my Access 2003 db opens and the
Database Window is "hidden".  I know pressing F11 will show the database but
I'm trying to create a user-friendly button where the user can just click
the button and see the window.  I can't seem how to do this ...

I am attempting to print 42 Reports. For some reason not
all Reports print, only some. The reports are all using
the same table for data.  A Form version of the Reports
retrieves data.  So obviously something is amiss with the

I have successfully created a set of Command Button controls on a form
through some code, but am now faced with an unexpected problem.
How do I create the "Click Event" for those buttons?
If I create a CommandButton using the control tool box, then its easy. I

I need to separate data now in field "parcel" into
fields "section",  "block" and "lot", which is prently
separated by dashes. Help as to the proper syntax would
be appreciated.

I want to hook up a roll printer to access 2002 to create receipts for
certain transactions in the database.  Does anyone know if this is possible.
If so, is it hard to get the printer to work.   I know those printers don't
print graphics and I will have to stay with printing text ...

How can I be sure that data in a new row is saved to a table before I issue
a .Requery?  That is, if the data is entered, but the user doesn't move to
the empty new row before launching a procedure that does a Requery?  The
SAVE method seems to apply to things like forms and table ...

Help Needed
How can i negative values to appear in red color and positive value in blue
color.

Need Help!
Can someone help me.
I am trying to make an accounts package, if the value is in negative it
should show in red color and if its in positive then in blue. How can i do