Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-02-2006, 02:27 AM   #1
apples76
Registered User
 
Join Date: Apr 2006
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
apples76 is on a distinguished road
Question Creating a report from multiple tables/forms

Could you please help me out.

I am trying to develop a DB that is multi user. i ahve not split the data from the forms into separate db's as the users are in different locations and our network can be very slow.

part of the requirerment is to produce a drawing approval form, my current sticking point is that the method i am currently using to create the forms only allows one person at a time to use the process.

currently i have a command button that runs a query and then creates a table from the results. the table is then used as the data source for a mail merged form in word.

what i ultimatly need is a process which allows multiple users to generate these forms at the same time and have the ability to save the form (with no code behind it) as a word document (either RTF etc)

i am thinking that if i create a query on the fly in VB and then use the results to use in a report this would allow me to do the above.....

So my questions are:

1) is my assumption correct
2) If so, how do i do it as i have never done it before
3) If the above is not the best solution/ does not work... what will/is

apples76 is offline   Reply With Quote
Old 06-02-2006, 07:47 PM   #2
Ziggy1
Newly Registered User
 
Join Date: Feb 2002
Location: Ontario, Canada
Posts: 462
Thanks: 2
Thanked 1 Time in 1 Post
Ziggy1 is on a distinguished road
Can you describe what the users need to do with the Form what is the purpose?

Also by clarify your definition of "Form" do you have a document that is produced that is filled in or are you talking about an actual Access Form (object).

RTF will not likely be your best solution because if you take a report for example and export to RTF it loses alot of formatting (lines, OLE etc).

Now I am talking Access 2000, so if later versions don't do that then I can't say.

so just give some more details on your process, and I or someone else can guide you in the right direction
Ziggy1 is offline   Reply With Quote
Old 06-07-2006, 12:45 AM   #3
apples76
Registered User
 
Join Date: Apr 2006
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
apples76 is on a distinguished road
Quote:
Originally Posted by Ziggy1
Can you describe what the users need to do with the Form what is the purpose?

The form is to be emailed to an external company for the purpose of approving/rejecting drawings that have sent in for apprasal.

Also by clarify your definition of "Form" do you have a document that is produced that is filled in or are you talking about an actual Access Form (object).

The form mentioned is a word document

RTF will not likely be your best solution because if you take a report for example and export to RTF it loses alot of formatting (lines, OLE etc).

Now I am talking Access 2000, so if later versions don't do that then I can't say.

so just give some more details on your process, and I or someone else can guide you in the right direction
The process involved is relatively simple.

1) site is given (nominated) to an external contractor to design & build
2) the date the nomination sent, received and arranged site visit is tracked and measured.
3) initial drawings (planning drawings) are sent in for approval
4) again drawing receipt from nomination is tracked as is approval
5) if drawings accepted then form sent with comments approved. if rejected reasonsare stated and reveions requested.
6) upon approval of first set of drawings. A second set called construction drawings are produced, these are tracked against approval of the planning drawings and original nomination date, and follow the same approval process.

apples76 is offline   Reply With Quote
Old 06-19-2006, 07:29 AM   #4
apples76
Registered User
 
Join Date: Apr 2006
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
apples76 is on a distinguished road
Bump....

still need help with this one please.
apples76 is offline   Reply With Quote
Old 06-19-2006, 10:47 AM   #5
Ziggy1
Newly Registered User
 
Join Date: Feb 2002
Location: Ontario, Canada
Posts: 462
Thanks: 2
Thanked 1 Time in 1 Post
Ziggy1 is on a distinguished road
So currently you are using mail Merge with WORD, you also would like to use a query with a report.

The cleanest method is to export the Report, is as a Snapshot format as it retains all the formatting, just base the report on the query ( no need to create a new table).


Last edited by Ziggy1; 06-19-2006 at 12:06 PM.
Ziggy1 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Print multiple copies of a report with varying criteria from one command button? KyleB Reports 3 08-17-2005 12:20 PM
[SOLVED] Multiple details in report Bkins Reports 2 08-03-2005 10:53 AM
Please help a Noob Ericnord General 5 06-08-2005 07:25 AM
Creating a Report Maldrid Reports 2 07-28-2003 10:33 AM
Multiple record sources for single report Autoeng Reports 1 10-24-2002 11:24 AM




All times are GMT -8. The time now is 05:01 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World