Search results

Galax...When you say: Currentdb is the database. Its scope does not include the Application, where the Forms and their controls are located. DO i need to add something else so it knows where the form and their controls are?

hpw come there are & in the statement.....what do they do. Do the date formats you put on the ends need to be in double or single quote marks? I will try this this morning!!

Hi Cronkite es I'm sure it is the code and seems to work in the query format. Galax.....how / where do I put that? The form Reserve runs of the Reservations table where the data is held. The Assets field is a number field (Displayed as text when viewing) the other 2 fields are both date fields..

i copied the sql string into the sql query and saved it as a test then ran it from a button on the form once the date fields had been filled in and it showed 1 record which the dates overlapped which is what i was expecting to see so seems like the sql statement is ok?

I added the error coding and it returns Run-time Error '13': Type Missmatch The Debug.Print strSQL returns the below in the Immediate window: SELECT Reservations.Asset, Reservations.[Checked Out Date], Reservations.[Due Date] FROM Reservations WHERE (((Reservations.Asset)=Forms!Reserve!Asset)...

it worked in query form....not sure how to test in it vba form..... I have slighted amended the code now to use the .recordcount (again i think thats the correct usage. i ran through it by dropping the red dot on the private sub line and the yellow band moves onto the Error Handler, then on the...

hi Cronk. The code in the vba does have the spaces in the copy and paste altered it for some reason. strSQL = "SELECT Reservations.Asset, Reservations.Checked Out Date, Reservations.Due Date " _ & "FROM Reservations " _ & "WHERE...

i think i made a little progress on this. I now have a query which will use the Check Out Date & Due Date and see if their is any overlaps in the Reservation table for that asset. I have pulled the SQL string from the query and want to set it as a recordset. If i run a record count on that...

Ah yes I see that would be an issue. Any chance you can put a solution down in novice terms for me to implement lol

yes A Date. The user adds the date they want to check the equipment out and then a second for when they expect it back in. What i want it to do is not allow a date (and 4 days before) to be added to the text box (Checked Out Date) on the form which would already be in the reservation table as...

thanks for the post.....im not great with VBA etc how would i use that to make the text box only allow a date to be selected thats outside the ones in the table?

Hi, I am building a database to check out and check in equipment as a log (like a lending library). One aspect is to reserve equipment days, weeks, months in advance. I have the system set up to do this. My issues is when the user wants to reserve some equipment they fill out a from with Job...