I need to automate the creation of a table
For that I am using a make table query.
Right now I have created a query that gives me 4 of the 5 fields I
need

When ever I do a compact and repair on a database a new file is created. The
file is named db1. and each time I compact and repair a new file is created
called db2 and so on. I end up witg db1, db2, db3, db4 and son on in my
folder. Any ideas?

I have an app which does some logging when the User ends the session. I use
a switchboard and have an "Exit and Close Application" button. But if they
quit by clicking the red X (Windows application quit) or by clicking on the
Exit Access the code doesn't get executed.

Hi,
I'm not sure what I'm trying to do counts as a full transpose.  Basically,
I've got some data which simplifies to the following:
ID#  Topic  Serial

Hi. I would like to know how to add fields of other tables in the same
database to a new table. i tried using the add existing fields option but it
seems to add them as a lookup list which is not what i want. i want them so
show up under each other in the table. please help. help ...

Access 2007 program but Access 2000 File format, Can't delete a corrupt
record in a table, weird symbols, search error.  
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ ...

Hi i am working in Access 2000 and am quite new to it all so please do not be
too technical in your responces.  I am setting up a database of trainees on
workplacements/apprentiships etc.  So far i have created most of my tables
seperating them as much as possible.  I need to be ...

I've created a customized toolbar for an access db, but I had to export all
the objects in a new file cause the db got currupted... and now I cannot find
how to import also the customized toolbar in the new file.   Any idea?
many thanks,

My database is split into a BackEnd (located on the network) and a FrontEnd.
The FrontEnd contains a startup code routine for normal users: they can add
new records to the database and view (not edit) existing ones. However...
some users have enough knowledge of MS Access to know ...

I'm using a slight variation of Dev's function, but apostrophes in names are
giving me fits. Here's the essence of his function, which I always credit to
him even in my variation:
Option Compare Database

I have a database that in order to see the contents of the database I need to
hold down the sift key to open it. Otherwise it will not let me view anything
except the switchboard form. I need to change this but I did not design this
database. Is there a way to remove this so that ...

I have an Access 2007 .accdb (testing at the moment) wherein the FE is on a
Terminal Services server (Windows 2003) running in the Access 2007 Run-time
environment and the BE is on another Windows 2003 server.
This app is accessed by many Users and is working well - up to the ...

In a query I would like to be able to show a date as Monday, Tuesday,
Wednesday etc.  Now I know I can use the long date, but this does not allow
me to query a large date range and to group by day of week and sum the data
so that I can see:

The form is a front end for editing an existing record and I need to
require the entry of data in a control on the form.  I have tried 'is
not null' in the Validation Rule on the Properties for the control but
I can tab right on past the control and don't get an error.

I have 3 fields in a table, fld 1, fld 2 and fld 3. I also have another field
called 'avg1_2_3' for  which i need the avg values in fields 1, 2 and 3. I am
able to do this in forms veiw. However I would like the avg values to be
automatically calculated and stored in the table. ...