jcethiopia
Last Activity: May 27 '08, 08:14 AM
Joined: Dec 11 '07
Location:
-
Thanks so much for your help, Jim. That was great.... -
I'm not sure I'm understanding you...Here is my code and what I want to do with it.
[Code]
Dim NewName As String
Dim Concatnewfrm As String
NewName = Me.NewEquiplist .Value
Concatnewfrm = "frm_" & NewName
DoCmd.CopyObjec t , NewName, acTable, "Standard"
DoCmd.CopyObjec t , Concatnewfrm, acForm, "frm_Standa rd2"
[Code]
...Leave a comment:
-
What if my newform name is dynamic, i.e. I use a variable to refer to the form? I always have trouble with the quotes and syntaxing. For example, how do I correctly do this command: Forms!YourNewFo rmName.Recordso urce with a variable representing the form?
Thanks!...Leave a comment:
-
Thanks all. It worked....Leave a comment:
-
Change RecordSource
Hi,
I was just curious if there was anyway to change permanently the recordsource for a form? Specifically, I used the CopyObject method to create a new form based off an existing form. Now I want the new form to have a new recordsource different from the recordsource of the copied form. -
The actual name of my table is not EquipmentTbl. The value of this variable is the name of my table....Leave a comment:
-
Append query as string SQL statement
Hi I'm a new user with Access and I need help with some VBA syntax. I am trying to run an append query using a string SQL statement. Basically, I need to append to "tbl_All" various fields from two different tables.
I need this to be dynamic because depending on what the user selects, it needs to take fields from a specific table. I am therefore using a variable to refer to this table: EquipmentTbl is the variable that...
No activity results to display
Leave a comment: