how do i alter the already created macro.
and can anybody help me, i need to a text box and i need to import related field from the table.
Printable View
how do i alter the already created macro.
and can anybody help me, i need to a text box and i need to import related field from the table.
Is this in Access? If so, a moderator should move the thread to the Office Development forum.
Editing the macro manually is as simple as Macros/click on the one you want to edit/click Design.
its in VB
There's no such thing as a "macro" in VB, so either it's not in VB or it's not a macro, but I can't help you unless I know which one is true. VB? Or macro?
actually i want to get a text box in a form and a reports, same field and get the data from a field from table.
ITS in VBA..
a little help
We'll have to wait until some moderator spots this and moves it to the Office Development forum, which is where it belongs. This forum is for VB6 and earlier.
Moved to Office Development forum
1) Are you using Access or Excel?Quote:
actually i want to get a text box in a form and a reports, same field and get the data from a field from table.
ITS in VBA..
a little help
2) Do you want to populate the textbox from an existing database?
3) You said something about the existing macro... what do you exactly have?
Are you trying to get the field name (I assume for Access) as an input to import that field from a DB into Excel?
my database is in SQL server, yes i am trying to get field name as an input to import that field from DB, in a form and a report.
So guys help me out here!!!! i need to add label and a box in a already created form. and i want data on that box to be displayed from the related field from a related column of a table. ITs in VBA, and database is in SQl server.
also in reports i want to add same field to be displayed.
let me put this way. i added a field in a table, and my database is in sql server, and in a form which is VBA, i wan t to create a text box which will display the related value from that new field in to that form.
Anybody
how is this resolved?
We need to know if you are importing this into Excel or Access...
haha. yes. makes sense after reading the previous posts.
i was just scanning for the vb code box.