Search results

Hi Guys, Ran into a problem with my SELECT Query and unsure what it is My program at large is a calendar that is searching the database for any bookings for the shown month. The specific code where the problem is occuring is the part where it searches for any existing bookings, then populates...

Hi guys, I think I have the answer to this but I don't know how to execute it in vba! I need to figure out whether a given year is a leap year. My idea for doing this is taking the number (i.e. 2020) then dividing it by 4. If it is a whole number / Integer then it's a leap year, if it's a...

Hi guys I posted earlier today for some help with INSERT Queries and thanks to the help of @Uncle Gizmo I managed to get it all good. However, I'm creating another form for inserting data, but this one doesn't seem to be working correctly. No errors are given but no change to the database? It's...

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...

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...

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...

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...

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...

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...

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...