Search results

Wow, the simplicity was deceiving. Thanks for the assist!!

I see, I've done some reading for the rest of today and vaguely begun to understand recordsets and such a bit. I understand what you've written and how it works but I have two questions. 1) What is the benefit of setting the recordset to Nothing, I've seen it mentioned before but never really...

Fantastic, I'll give it a shot in a second. If I stuck it in a for loop like I showed in the inital post would that allow it to work for multiple records of the same date?

Cool that all sounds ok except for thge recordset part as I've never actually ventured into them before! From looking up it would have to be something like: Dim rst As Recordset SQL = "SELECT BookingID FROM tblFlightsBooked WHERE DateOfFlight = #" & TempDate & "#" Set rst =...

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

Also glad to say that everything is now working and I appreciate all of the help on this one thanks guys! :D

Thanks for the tip, and yes I've guessed that this is highly likely to not be good practice if not illegal. This is just a simple A Level project however for my Com Science A Level so need not worry about leaking data :). Our teacher's said that anything to do with data storage and such can be...

Ok I think I may have found the issue in that within in my table it has a related ID for another table, I wanted to add the code beforehand for to check that it was working so I'll add that new code and see if that should fix it

I managed to fix it and ran the code into a query and got this message: Microsoft Access can't append all the records in the append query. Microsoft Access set 0 field(s) to Null due to a type conversion failure, and it didn't add 1 record(s) to the table due to key violations, 0 record(s) due...

Apologies that's my bad as I had to type it out since can't highlight it. But the parens are there

I changed it to MsgBox strSQL0 as you said and I got a pop up window returning this: "INSERT INTO tblUserDetails(FirstName, LastName, HouseNumber, StreetName, City, PostCode, MobileNum, Email, CardNum, ExpiryDate, SecurityCode, Remarks) Values("Test", "Name", 14, "Generic Road", "Generic City"...

No joy I'm afraid

It just opens up the vba editor I feel like I'm doing something wrong

Ah sure my bad will do

It doesn't make return anything no window or anything?

Thanks I just wanted to check.

Do you mean the event function for activating the fAddRec() function or that one itself?

Will do thanks

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