Kind regards,
Firstly, I want to clarify that I am not a programmer. This app that I am developing in VBA Excel has been created with the help of Chatgpt by asking a couple of questions, but sometimes it is difficult to thread the needle.
I am trying to create a Data Entry that will ultimately take the data to an Access database. The form has two main components: the frame where there are elements that will capture the user�s data with TextBox and ComboBox, and a ListBox that will allow me to visualize the data in Access that is being entered. In general, that is the application.
I need to do:
I am creating a form in VBA with the following characteristics:
The form has a height of 537 and a width of 1003.5. Inside the form, there is a frame or box called �user data� with a height of 198 and a width of 954. This is the space where I will register the users and that will be stored in a pre-existing Access database called �CaracterizacionAlianza� from the �usuario� table. It has pairs of elements between ComboBox and TextBox that go in order of numbering and are the following:
1.Document Type -> ComboBox
2.Document Number -> TextBox
3.Exp Date ->TextBox
4.Place of Exp ->TextBox
5.Names ->TextBox
6.Surnames ->TextBox
7.Date of Birth ->TextBox
8.Contact Number -> TextBox
9.Age -> Textbox
10.Gender -> ComboBox
11.Residence Mpio -> TextBox
12.Vereda -> TextBox
13.Nationality -> Textbox
14.Education -> TextBox
15.Email -> TextBox
16.Profession -> TextBox
17.Type of Population -> ComboBox
18.Residence Mpio ->ComboBox
19.Association ->TextBox
20.Marital Status -> ComboBox
21.EPS -> ComboBox
22.SISB�N Group ->ComboBox
23.SISB�N Score ->ComboBox
24.Farm Name ->TextBox
25.Municipality -> ComboBox
26.Vereda-> TextBox
27.Total area ->TextBox
28.Total cultivated area ->TextBox
29.Main crop ->ComboBox
30.Secondary crop ->TextBox
31.Annual Kilos Produced ->TextBox
32.Property title -> ComboBox
33.Reserve Zone -> ComboBox
34.Reserve Hectares ->ComboBox
35.Main product buyer->Textbox
36.Product Transformation -> ComboBox
37.Product brand-> TextBox
38.Projects participated in->Textbox
As the �user data� frame is small (it must be so by obligation), I cannot put all the elements so I need to put the elements that go from enumeration 1 to 23 and when this is complete there should be a next button that sends the information to the database where it shows the remaining ones that are from 24 to 38, these elements I cannot create all in design mode so they must be dynamic (execution mode) and go in the order of enumeration. All elements must have a validation (restriction of the type of data to avoid typing errors). When all are finished, there should be another next button that sends them to the Access database called �CaracterizacionAlianza� and shows them in a Listbox (list box) that has a height of 216.05 and a width of 954. This is the space where the records sent to the Access database of the 38 elements will be shown. The next button must send the 38 elements to the database but at the same time it must show new elements in the frame that would be the last these:
Number of people you live with ->ComboBox Depending on the number of people you select, a subform must be created that has:
39.Names -> TextBox
40.Surname -> TextBox
41.age -> TextBox
42.Type of document -> ComboBox
43.Document number -> TextBox
44.Relationship -> ComboBox
45.Level of education -> ComboBox
46.Profession -> TextBox
47.Disability -> ComboBox (yes or no) select yes open which -> textbox
Elements 1 to 39 must be registered in another pre-existing Access database called �Familiar� with the �familiares� table.
I need help especially with the validations and the subform of the second database, I appreciate any possible help.
I attach the VBA Excel file of what I have done so far.
Bookmarks