how to create a report using VBA?

[mane_uk]

Hi,

I need to create some reports for the database I have created for the sales team. They are going to use it while on the road as well as when connected in the network. As their laptops are really slow I didn't want to include queries as this would make the database considerably bigger.

I was wondering if there is a way that I can create a layout report with unbound text boxes (or other fields) and then populate it by using VBA code? If possible, what is the code used to populate the fields?

Also, if I want to print a list of items, for example, I want all the sales guys' names in the report plus what they sold in a specific day, do I need to create 1 text box to each sales person plus text boxes to receive the items? Any other easier way to do it where the fields would recognise the recordset and receive all the data?

Thanks
mane_uk

 

[DCrake]

If you say that the sales team use it when connected to the network, this implies a split database, however when on the road they won't be. So how are you handling the linking of tables between network and off line?

 

[mane_uk]

DCrake,
I have a FE/BE in the network drive which the user can go and create the offline version (the offline version is a copy of the network version but the FE is without all the administration functions and BE is without all the data related to other sales people making it "slimmer". Then, the code link both files to be used offline). Once users are back in the office/network they can synchronise it back (the code import the tables into the network file and copy/update the changes done).

 

[mane_uk]

Hi,
I was wondering if there is a way that I can create a layout report with unbound text boxes (or other fields) and then populate it by using VBA code? If possible, what is the code used to populate the fields?

Also, if I want to print a list of items, for example, I want all the sales guys' names in the report plus what they sold in a specific day, do I need to create 1 text box to each sales person plus text boxes to receive the items? Any other easier way to do it where the fields would recognise the recordset and receive all the data?

Hi guys,
Any ideas for my queries above?
Thanks