Solved Filling out the form from the xls file (1 Viewer)

[pjo3us]

hello Everyone
I have a problem how to set the selected value from the xls file to a certain field of the form. The problem is that the values in the table connected to the form are declared as numbers, and the data that is pulled from the xls file is a string. The error would be solved if you just changed the declared values of the table into a short text, but that is not an option for me at the moment, because the existing table is already quite large and it would be bad to damage it.
Before entering the fields of the form, I have the condition of checking if such data already exists in the table, if not, to enter it. That option works, but as soon as you need to set that value in the form field, an error appears.
I also have an example of my problem in the attachment, so if I was a little unreasonable, you can better understand the problem through an example

 

[Gasman]

Convert using VAL() ?

 

[arnelgp]

you try this and see the code behind cmbInportXls.
you also need to Relink your excel file.

Note all your Combobox, Bound Column property is Set to 1 (which is the First field of your tables, autonumber field).
therefore you need to assign a number to the comboboxes, not the string (car name or color name).

 

[bob fitz]

hello Everyone
I have a problem how to set the selected value from the xls file to a certain field of the form. The problem is that the values in the table connected to the form are declared as numbers, and the data that is pulled from the xls file is a string. The error would be solved if you just changed the declared values of the table into a short text, but that is not an option for me at the moment, because the existing table is already quite large and it would be bad to damage it.
Before entering the fields of the form, I have the condition of checking if such data already exists in the table, if not, to enter it. That option works, but as soon as you need to set that value in the form field, an error appears.
I also have an example of my problem in the attachment, so if I was a little unreasonable, you can better understand the problem through an example

View attachment 106989

I have no understanding of what your db is for or what you are trying to do, but:

Your code errors on the line of code:
Me.cmbModel = Model
because "Me.cmbModel" requires a numeric value but "Model" is a string
Try this:
Change the declaration of Model to Integer
Change Model = Me.cmbInportXls.Column(1) to Model = Me.cmbInportXls.Column(0)

 

[pjo3us]

Convert using VAL() ?

What I need, I can't use VAL(). But thanks again.
@arnelgp fixed the issue of my poorly written code

 

[Gasman]

@arnelgp fixed the issue with poorly written code

Really?, that is not like @arnelgp

 

[bob fitz]

Really?, that is not like @arnelgp

I think the OP actually means:
@arnelgp fixed the issue (with) of my poorly written code