Search results

Fantastic thanks for you help!

Hi Guys, I've been looking for a bit on information about INSERT statements and I really haven't found much. So I find myself here again! All I want to do is a basic INSERT Statement where the user will input data into text boxes, then when the save button is clicked, the code will insert...

Great thanks for the pointer I'll take a look

Hi guys, I posted yesterday about incorrect syntax again for an update statement, however I've got a new error with a different line of code. I just copy and pasted it from this "UPDATE tblUserLogins SET Password = '" & Me.txtNewPass1 & "' WHERE LoginID = " & LoginID and transferred it to...

Great thanks I'll give it a look

Fantastic that works, for future reference, why is it just that txtForename part that needs to be put in quotes as well? Thanks for the reply

Didn't expect to be back so quickly, but here we are... I'm running an SQL UPDATE Statement to update a users record for information stored on them This is the code I'm using SQLForename = "UPDATE tblUserDetails SET FirstName = " & txtForename & " WHERE LoginID = " & LoginID LoginID is a...

thanks for your help both Bob and Minty

Ah I see, thanks I'll look into this!

Ah that would be the reason thanks, as I said, quite new. But I'm curious as to how I would go about bob's answer as it sounds a lot more... efficient :D

That's a thing I can do? Haha, I failed to mention I'm quite new to access and doing my first project (I've found myself posting here a few times already). Could you help me with the syntax for that and how I'd go about doing it? Thanks for the quick response

Hey guys, I'm designing a user details form. It's going to have all of the data stored about the user. I'm trying to load a form, and upon loading it will populate the text boxes with the already stored data. LoginID is the criteria I'm using here as it is unique to all users. Once the user...

Sure just wanted to check - and will do. Thanks for your help

great that worked thanks, and my bad for not including the correct stuff, another follow up question: what would be the syntax to run all 3 of those statements at the same time? Just to save having 3 pop ups asking to change one row?

Hi again, I promise this is my last post for today! I've been grinding away at my project hence the volume of posts As the title above says, I'm using a SQL UPDATE Statement to update prices for an item in a table. However, I've tried tinkering and to no avail, when I click the activation...

thank you and thank you @MajP

I see, I got it working now

Ah I got it, thanks for the help. I'll try it now

Does this look good? DLookup("ProductID", "tblPaymentPricing", "1")

so where would I put the dLookUp? in the If statement or equate it to a variable like at the top