:confused: Creating a datasheet from a SQL string using VBA

[najathsl]

Hi Guys ..

i am creating a dynamic table with dynamic new columns to table.

what i want to do is.

I wanted to create a datasheet view (form) using that table or a dynamic column values every time i modify the table.



please help me ..

Najath

[NoellaG]

Hi,

you can easily create an empty form with 1 subform control. just assign the table name to the Source object property (like Table.tblMyTable), and it will show the table with wathever columns yiu created in it.

greetings
NG

[najathsl]

what i am trying to do is ,

i am creating Tables Runtime, that part is successful , now i need to assign those RUNTIME tables to forms and create the table in RUNTIME.

see, thats the part i am struck

please advice me.

Najath

[NoellaG]

To create a form by code: you can try something like:

Public Sub CreateMyForm()

Dim frm As Form
Dim ctlLbl As Control
Dim ctlTxt As Control

Set frm = CreateForm()
frm.RecordSource = "tblMyTable"
Set ctlTxt = CreateControl(frm.Name, acTextBox, , "", "", 1200, 100)
' Create label for text box.
Set ctlLbl = CreateControl(frm.Name, acLabel, , ctlTxt.Name, "NewLabel", 100, 100)
DoCmd.Save acForm, frm.Name
DoCmd.Close acForm, frm.Name


End Sub

[najathsl]

thanks alot...

god this is what i being looking for ... thank you very much..

najath