Search results

Thanks for the quick response, sorry I'm about 3 days into access could you just help me with the syntax for what you mean

Hi again, I regret to be back so soon - but this forum treated me well the first time so why not. I'm making a form that is for payments. There will be text boxes for the user to input the amount of the item, but an admin can change the actual fee of these items. So they need to be dynamic...

Yeah just got that, thanks buddy

Nevermind, I fixed it. I changed the way it got the username from instead of taking it from the databse, to grab it from the text box since the system already knows that it's correct. Then I had to change the order of it as it was trying to grab it from a text box that was in the form that had...

Yeah that works better actually, but there's still a problem, it's not finding the username. So when I use your example of: Me.lblWelcome.Caption = "Welcome " & Username It changes the label to just "welcome" so I'm assuming there's an error in actually getting the username maybe I don't know

ah thanks for the feedback, I'll look into that!

I didn't end up getting any errors, but this time the label disappeared... I'm assuming it had nothing in it so it looked like it wasn't there? Just to confirm this is the right code for changing the label caption: "Me.lblWelcome.Caption = Username"

ah I understand, thanks I'll give it a shot now

Sorry, what do you mean by a seperate module? I'm assuming the modules are all the different pages that I have on the VBA IDE?

As I said before, I'm quite new to VBA and MS Access so lots of this stuff is likely gonna be new to me. I put "Dim Username As TempVar" at the top of the code, that still didn't work. If I didn't understand you correctly with TempVar then please correct me.

Thanks for the response, it says variable not definded, and highlights the "Private Sub Form_Load()" just above it on the code

Apologies if this is quite a basic question - it certainly sounds it. I'm doing a project on MS Access and I'm completley new to it. I've managed to get by for the most part, however, I've ran into a problem with changing a labels caption using a variable within that caption. Basically, what's...