Programmatically create a form using VBA
-
Hi, I'm using MS Access 2000, and I need to a form that consists of dynamic objects (i.e., the objects (text boxes) in the form are dependent upon data, and may need to change) Example- The form is illustrating the client's current currency positions. I may need more text boxes in the form if its recordsource increases that types of currency the client possesses. Thus, it the client decides to increase the types of currency's he/she trades, I need the form to dynamically create a new field illustrating that currency. Using VBA, is there a way to programmatically create a form, so it can store dynamic objects/content? Please let me know if I have not explained this in great enough detail I'd appreciate any help at all, Thanks Nick
-
Hi, I'm using MS Access 2000, and I need to a form that consists of dynamic objects (i.e., the objects (text boxes) in the form are dependent upon data, and may need to change) Example- The form is illustrating the client's current currency positions. I may need more text boxes in the form if its recordsource increases that types of currency the client possesses. Thus, it the client decides to increase the types of currency's he/she trades, I need the form to dynamically create a new field illustrating that currency. Using VBA, is there a way to programmatically create a form, so it can store dynamic objects/content? Please let me know if I have not explained this in great enough detail I'd appreciate any help at all, Thanks Nick
Here is a sample in VBA for Excel. Take a look at it. http://j-walk.com/ss/excel/tips/tip76.htm[^] Free your mind...
-
Hi, I'm using MS Access 2000, and I need to a form that consists of dynamic objects (i.e., the objects (text boxes) in the form are dependent upon data, and may need to change) Example- The form is illustrating the client's current currency positions. I may need more text boxes in the form if its recordsource increases that types of currency the client possesses. Thus, it the client decides to increase the types of currency's he/she trades, I need the form to dynamically create a new field illustrating that currency. Using VBA, is there a way to programmatically create a form, so it can store dynamic objects/content? Please let me know if I have not explained this in great enough detail I'd appreciate any help at all, Thanks Nick
How about Dim txt as textbox MyForm.Controls.Add(txt) The warlord