Search results for query: *

Hi, I have a database (Access 97) in which the user inputs data into a form and hits the print button and it prints a report for the record they are on (using a macro). Everything was working fine with the user opening each form individually and printing. I then decided to group all the forms...

Hi, I'm not sure if this is even possible. I have two forms that the user will always need to fill out and print/email together. Currently set up as Form A and Form B, printing to Report A and Report B. I would like them to both be in the same spot (in the form), which I believe I can do with...

Hi, I'm not sure if I can do this. I have a Main Form (Main Table)with SubformA (TableA) SubformB (TableB) SubformC (TableC) They are all connected with a Record Number. The form is saved as a report. Each subform is set up with a specific number of rows (TableA is 5, TableB is 8, and TableC...

I have a form with 3 subforms. Each subform is bound to a query (each query is bound to one table). The tables are located in a backend with the queries, forms and reports in the front end. Each form has been saved as a report and when the staff member completes the form they hit a print...

FYI - just so nobody wastes their time answering this - I fixed the problem by splitting up the tables so that the data for each subform comes from a separate table

Hi, I tried asking this before but, I wasn't descriptive enough. I have several tables: Main Table (primary key is RecNo.) includes common info to all tables (ie. company name, coordinator) Sched1 Table (primary key is Sched1ID) includes a field for RecNo. Sched2 Table, Sched3 Table.... I...

Hi, OK - I have to admit I'm not an Access expert so, I hope these details don't confuse. For the over sized query, there are 267 fields. The reason there are so many is that I have to have on every report (generated from the forms/subforms) a set number of lines (ie. 8) or the govt. agency...

Hi, I had originally built all my forms/subforms directly from the tables but, I was having problems printing and was told that it would be better to write queries and create my forms/subforms from there. I created all the necessary queries and edited each of my forms/subforms to have the...