Comments by Atipos - CodeProject

Atipos 25-Jan-19 5:21am View

Having tried some ways of code but no one to give me that result.
The fact that range ("A3") should increase when i pressed the Save Button.

Atipos 25-Jan-19 4:58am View

I would like to be able to insert more data in more cells, in progression.

Ex .:
TextBox1: Hello
TextBox2: Test
Press the Save button;

Except for Hello in cell A3 and Test in cell B3,

I would like to insert later
TextBox1: Test
TextBox2: LoL
Press the Save button;

Except for Test in cell A4 and LoL in cell B4.

Atipos 22-Jan-19 4:05am View

What do you mean by printing? From a simple printer?

Atipos 7-Jan-19 4:36am View

I understood where I was wrong. I did not remember putting Employee as Integer, so username1 did not let me enter it.

Changed type and now it works perfectly. Report your answer as "Accepted Solution" because you explained perfectly.

Sorry for the mess, thank you very much

Atipos 4-Jan-19 11:51am View

The row source is for the Employee that you could see on the image. It's for the mask A.
The ID of tb_ID is for Login Mask, the username, i just called tb_ID

Atipos 4-Jan-19 11:40am View

Yes, I declered username1=Me.tb_ID.Value already.
tb_ID is the name of the text field on the login mask, So i put a text (String) on it, so username1 should be a String.

(Btw, thank you very much for helping me in this moment, i hope you will be a fantastic weekend!)

Atipos 4-Jan-19 11:29am View

I understand that the global variable is not a String. But i declered it "Public username1 As String"...

This because if i rename the combobox Employee1 (when it was an employee he was in contrast with another employee) and then:

Me.Employee1.Value = username1

It comes out that the value you entered isn't valid for the field.

Atipos 4-Jan-19 6:20am View

Always the run time 2113 the value entered isn't valid for this field.
I don't understand because when i did Me.Rmployee_Label.Caption=username1, it works but change the label.
With the Value Property give this error...

Atipos 4-Jan-19 5:38am View

It gives me always error. What if i just check up if username1=employee?
Could it work?

Atipos 4-Jan-19 4:54am View

I apologize for my ignorance but I am a beginner with vba and access. For this reason I ask: to assign the id of username1 to the combobox, do I have to do it through Employee_AfterUpdate ()?

Atipos 4-Jan-19 4:33am View

If row source of combobox is

SELECT [Employees Extended].ID, [Employees Extended].[Employee Name] FROM [Employees Extended];

should i work on this? I mean, with Me.X.Value=username1.
I don't konw if i can reach an object that is on another table of the database.

Atipos 3-Jan-19 8:32am View

I really appreciate your availability and I thank you. Using the caption property what I'd like to do, it works great. But unfortunately changes the title of the column. Thanks to you I understand that I have to operate on that precise field.

Now I wrote:

Me.Employee_Label.Caption = username1

Having done this, as written a little above, change the title of the column.

If you now put:

Me.EmployeeText.Value = username1

I'm back to the run-time error 2113, the value you enteres is not valid for this field.

https://imgur.com/JuMjLNn
- I upload a little image of what i like to change with the global

Atipos 3-Jan-19 6:28am View

I will update the code on the main question.

Atipos 3-Jan-19 6:14am View

The problem is that the field hasn't a value property. It gives me this error: "Object doesn't support this property or method"

The field is "employee", with it i can select an employee from a list of them, when i select the name of the employee it will open the login form, with this i will put the username and password.
What i like to do is that the username

Atipos 11-Dec-18 11:42am View

I am aware that it is not a good thing to memorize the password in a plain text. Being a beginner with this type of security I used this method (not convenient). Thank you for the various links, I will read them carefully!

Comments by Atipos (Top 15 by date)