Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating form on Fly ( Dynamically )

Status
Not open for further replies.

ishfady

Programmer
Sep 14, 2002
31
GB
Hi

I have Access2003 Database running on windowXp pro. It is working fine.

I have a crossTab query, which I used as a source data for this DataSheet form. But Rows and Heading is different every time I run this query, it messed this DataSheet form.

Is there any way I can create datasheet form dynamically (On Fly).

Please could you advice me.


Many thank



 
The following command calls an Access Wizard that will create the form for you based on the table or query you specify (with all of the controls included).

Application.Run "acwzmain.auto_entry", "YourQuery", 5, 2

Where 5=Pivot; 3=DataSheet; 2=Continuous Form; 1=Single Form
 
If / when search is working, there are several threads detailing the process, including (simple) sample code.




MichaelRed


 
How do you save the form after the wizzard created it?
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top