Re: Make Table Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I know this is confusing and I will try my best:

I have 300 users of the database; however, 10 of the users need to enter the
data into the database more often than others. So instead of them using the
elaborate form, which creates automatic numbers (sequesntial per year) we
created a simple "excel" type form for them to you. (As I said before, they
are very computer eliterate).

So example:

1. User 1 enter 10 records into the form getting 10 new numbers for the
customers.
2. Runs the macro "when it works"
3. Opens Word and merges and prints the forms.

4. User 2 comes in and enters 7 records
and follows the same steps as user 1; however, print just "their" records.

The reason I can't have them enter directly into the table is because there
is an event procedure on the form to automatically assign numbers. The table
requires the user to add the next available number (very complicated).

Hope this helps.

"Jeff Boyce" wrote:

I'm confused. Where are the records going when they "enter all the records
they need to merge"?

Running an Append query takes data from one source and appends/inserts it
into a table... wait?! didn't they just enter the data into a table?

It all starts with the data ... please describe the data structure
underneath all this...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Sondra" <Sondra@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7AD0ECF0-16A3-48EC-B1BC-9DD6EAC9B156@xxxxxxxxxxxxxxxx
Jeff:

This is a fantastic idea; however, I can't get it to work to my needs and
I'm hoping you can advise.

Okay so here is how the process works....

1. Staff open a "datasheet" form and enter all the records they need to
merge into the Word Document form.
2. They choose the CLOSE Button on the form and a macro runs
a. Delete Query for "temp" Table.
b. Append Query for "temp" Table.
c. Closes "datasheet" form
d. Opens Master Switchboard

Here is what I believe should be happening at that point.

The staff can open Word and merge the "temp" table into the form.

What is happening:

It only allows this "macro" process to run once per opening the database.
I
have to close the database each time and it doesn't always delete the
records.

Does that make any sense??

I hope.

Thanks as always.


----------------------------------------------------------
"Jeff Boyce" wrote:

Sondra

A "temp" table is really just a table, but you're only using it
"temporarily".

Create a table with the table definition you want.

Create a query that deletes all the records from that table.

Create a query that loads up that table with the records you'll want to
use
in the Merge operation.

Use a procedure (or a macro) to run both the delete and the append
queries.

Adjust to fit your situation.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Sondra" <Sondra@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4F5A7654-C843-4332-A37A-F92150DFA666@xxxxxxxxxxxxxxxx
Because my users aren't very savvy, I really think I have to have a
table
for
them to merge into the word document.

Can you explain the "temp" table a little more.

"Jeff Boyce" wrote:

Sondra

When you use a Make Table query, you get what Access decides you need.

If you want to control the format, there's a couple of alternate
approaches.

First, you could do away with creating a new table altogether and just
use a
query to assemble (and format) the data. You can export a query
(actually
the data the query returns).

Second, you could create a "temp" table to hold the data, and create
the
table with the formatting you want. Then your query would append to
that
table. Of course, you'd also need to create a "delete" query that
empties
that temp table first.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Sondra" <Sondra@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9893DBEE-B424-407E-8D6B-06506C3FA682@xxxxxxxxxxxxxxxx
Using Access 2002

I have a database that I need to have users extract specific data
out
of
to
merge into a Word Document. I've created a "MakeTABLE" query that
asks
them
for there specific data. I've created the formatting in the query
and
everything looks great. Here is my problem. When the query makes
the
"mailmerge" table one field doesn't format the way that I need it
to.

Example:

Query:

FormNumber = 83275 Formatted as = 08D-3275

Table

Formatted as = 83275

How can I force the table to maintain the same formatting each time
a
user
runs the query?










.

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... synchronize combo boxes to the detail section or the parameter form query ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would ...
    (microsoft.public.access.conversion)