blank sheet on preview before printing

[chris11590]

whenever i try to preview my forms on print preview i see an empty sheet. some forms preview correctly while others dont preview at all. any solutions????

 

[maxmangion]

why are your trying to print a form instead of creating a report ? Forms are meant for data input while reports are meant to be printed.

 

[chris11590]

bc i will need to add and edit info . should i be entrying data on form and then create report.

 

[maxmangion]

you should be entering/editing the data on form.

you can create a report now and when you enter new data on your form, the report will be updated automatically, so all you have to do is just print the report.

 

[chris11590]

can i format a report ???

 

[chris11590]

i forgot to mention i need the report to have a particular look

 

[maxmangion]

sure you can. The easiest way would be to create a report using the wizard and then format it as you wish.

 

[chris11590]

biggest problem i having though

when i enter data into form not going into table. i have a lot of combo boxes does that have anything to do with it.

 

[chris11590]

i was under the impression, dont know why, forms and reports where built off table and queries. i had no idea reports could be built from entering data in forms.

 

[maxmangion]

Hi,

you create a table where data is stored. then you create a query based on that table. eventually you create forms/reports based on your query. So you are not building reports on forms, but on the query of the form i.e. its recordsource.

 

[chris11590]

I really need alot of combo boxes, and i tried to put combo boxes on report it didnt work. it should did not display a list of options to select from on the report once the outbound boxes where created.

btw thank u for all you help. you are helping me, as well the citizens of nyc.

 

[maxmangion]

Hi,

Reports are meant to be printed and not to use combo boxes on them. Your reports should be based on a query, where your selection (criteria) will be made up there, and then when you run your report it will display the records you need.

Try taking a look at the Northwind database under the Access Help menu, so that you can get an idea of what each object i.e. tables/queries/forms/reports etc are meant for.

 

[chris11590]

do you recommend creating a report off tables instead of query???

 

[maxmangion]

if you want to display all the records that you have in your table you can, but if you want to filter records i.e. you want to show records which meet a particular criteria then you have to use queries.

 

[chris11590]

thats why i went to forms bc what i am trying to accomplish is generated a report we utilize . we normally cut and paste in word. ill attach db. im very new at this so i expect your find errors. learning as i go and from abook. i just want to have standarized forms which to enter data. the data will remain the same for the most part ,but there will be editing required.

 

[chris11590]

fyi, i did create some queries, but having no used them, found that they are not necessary. combo boxes and subforms are utilized for the most part....

 

[maxmangion]

i think before you go any further in your project you should consider designing your database on a piece of paper and then you build your database based on your plan.

You cannot creating objects (in your case queries) only to find out that you don't even need them. At least try to post what tables do you have and what fields you created so that at least we know if you're on the right track with your design.

 

[chris11590]

i was not able to send db now bc not authorized , limted internal access. i will send from home

 

[chris11590]

i did. my database is to track what we call "incident action plans for nyc fd" . i have created phyical tangles tables and logical tables etc. i did not realize i wouldnot need the queries unit now bc still learning. i have created forms. the only problem im experciencing is print certain forms, and the forms not display the info from the tables. i am able to select them off the combo boxes but when i close the form, the data gets lost. i will probably, unfortuanately, redo everything one i have it all fig out. all the tables are not completed done, just entered limited date to ensure working and in the right track. forms are very easy to create. have become an expert on formatting forms.