Rlb53
02-04-2012, 01:07 AM
I'm new to Access, and have a limited exposure to Excel VBA, but have accomplished desired Tasks with Excel. Particularly with the use of Userforms with Combobox and Textbox for Data Collection,Storage and Returning Values for ease of view through Textbox on the userform. Of course.. printing the values in a reportable form as well.
I like the ease of use of the "Userform" in the Excel VBA configuration, but the back end does not provide the ability for offsite interaction I need for a current project.
Since stepping over to Access I have found how to create the Modal Dialog Forms in Access, but I'm having difficulty understanding how to interact with the Data Base to query selected information in the Combobox(s). It appears that the keywords and protocol differ from Excel enough to make it difficult getting over the hump. I'm hoping you will be willing to help get me past this.
To try and further explain my request for assistance:
I have a Modal Dialog Box with 4 each combobox and 1 ea Textbox
The first Combobox provides the list of Tables in the Database.
The next three Combobox provide a list of fields that information should be acquired from the selected Table.
I wish to retrieve the Data stored in the Table identified in the first Combobox. I then wish to access the data within the fields identified in the following 3 Combobox. A calculation would be performed with the information. This value would be placed in a specified range so that the result will be displayed in the textbox on the userform.
Thank you for any assistance you may offer.
I like the ease of use of the "Userform" in the Excel VBA configuration, but the back end does not provide the ability for offsite interaction I need for a current project.
Since stepping over to Access I have found how to create the Modal Dialog Forms in Access, but I'm having difficulty understanding how to interact with the Data Base to query selected information in the Combobox(s). It appears that the keywords and protocol differ from Excel enough to make it difficult getting over the hump. I'm hoping you will be willing to help get me past this.
To try and further explain my request for assistance:
I have a Modal Dialog Box with 4 each combobox and 1 ea Textbox
The first Combobox provides the list of Tables in the Database.
The next three Combobox provide a list of fields that information should be acquired from the selected Table.
I wish to retrieve the Data stored in the Table identified in the first Combobox. I then wish to access the data within the fields identified in the following 3 Combobox. A calculation would be performed with the information. This value would be placed in a specified range so that the result will be displayed in the textbox on the userform.
Thank you for any assistance you may offer.