Generate Blank Records

[SSgtBarry]

I need to be able to generate blank records for a report and / or form.



Example... I work with hundreds of trucks. My co-worker (we'll call him Bob) has a number of customers. When a customer calls, who needs trucks, Bob will create an order. Bob will scratch a number of lines on a piece of paper. If the customer needs 7 trucks, Bob will scratch 7 lines on the paper. Bob will then call Trucking Companies to fill the customers order. If a Trucking company can only fill 2 trucks, the first 2 lines will have info about THAT particular Trucking Company. Bob will then go to the next Trucking Company and fill each line on the paper with info, until the 7 lines are full.

I need to create a query (or code) that will automatically generate empty records, based on a number (example 7). From those empty records a report with 7 lines (records) will print, so that Bob can jot info for later data entry.

How can I generate report lines, based on a "given number"?

Thanks in advance!

[June7]

I once experimented using code to do this and found the results unsatisfactory but might just have been something funky about my report.

Review http://www.vb123.com.au/200310_dl_pad.htm

An alternative is to build a 'blank' report that is simply filled with UNBOUND textboxes or line controls. You will likely have more 'rows' than needed but will make your life much less stressful.

So why does Bob need a printed blank document? Why is he not just entering data directly into a form on computer?

[ssanfu]

Care to post your dB?

We do something similar - we open a form and it appends 1 - 3000 blank records (1 - 3000 people). 1 field has the emp id and another has the number 1111 entered.
the data is filled in - maybe not for everyone. When the form closes, any record with an entry in the field that has 1111 is deleted.

Don't know what your table structures are, so can't give/suggest a good solution....

[ArviLaanemets]

1. You create a saved query for order based on your database;
2. You change the created query to UNION query, appending n empty rows for every order (only field filled will be PK for order, and maybe some another fields used in report header only), where n is the number of trucks needed, and set ORDER BY in a way, that empty rows are displayed as last;
3. You base your report on this saved query, like "SELECT TOP n FORM YourSavedQuery WHERE OrdeID = x", and edit the report's querystring in VBA before calling the report to adjust n and x. For your example, in the printed report will be 2 rows with info, and 5 empty rows in report's body.

[June7]

7 was an example, another order might require only 4 and another 10, etc.

It's my impression the only data is the order info, there are no trucks selected, when this document is printed. The purpose being a convenience to hand note info taken during phone call.

[ArviLaanemets]

7 was an example, another order might require only 4 and another 10, etc.

Did see this after finished editing my post.

[SSgtBarry]

Thank you for your response! I will give that a try!

[SSgtBarry]

Thanx for the info