Search results

Hi all, I have the code below. Access asks me to type in a value for reasonwhy when it should just place the value for reasonwhy in the database reasonwhy is called earlier with: dim reasonwhy as string reasonwhy = text30.text Thanks SQLText = "INSERT INTO absent ([start_date], [end_date]...

Hi all, I have the code below. Access asks me to type in a value for reasonwhy when it should just place the value for reasonwhy in the database reasonwhy is called earlier with: dim reasonwhy as string reasonwhy = text30.text Thanks SQLText = "INSERT INTO absent ([start_date]...

I have this code: If a <> "0" Then I would like to check to see if A is a minus number and also If I have a number in B I would like taken off of a till a gets to 0. I'll explain: A = 10 B = 15 Take B away from A till A gets to 0 and then C will = whats left. In this case C will = 5...

great thanks.

All, I have the following If statement: If Forms!frm_homepage!new2008hols = Null Then It doesn't seem to work as it doesn't understand Null. If I hover the mouse over it, it comes back as Null but for some reason doesn't work. Thanks Martin

excellent - thank you so much

Hi all, I have the following code. a is a string defined in the procedure. I would like to place the value to a into the SQL text but it doeesn't seem to work SQLText1 = "UPDATE tbl_users" & " SET tbl_users.new2008hols = a " & " WHERE tbl_users.user_id = '" & Me.Text18 & "'" Do I need to...

cheers guys, great help, now works, just got to do the rest of it now, cheers again

ok cheers, I have checked it and the word Jo is in both places. I will look into it further or try to do it on another field cheers

I tried both of them and still no luck, where could the errror be? its not saying there is an error. cheers

tried that, it returns the value of text18 fine. it just doesn't place the 0 on that record in the new2008hols column.

Can anybody see what is wrong with the below code: SQLText1 = "UPDATE tbl_users ([new2008hols]) FROM tblusers SELECT (0) WHERE (tbl_users.user_id=" & Me.Text18 & ")" Thanks Martin

how do you mean? will it mess up how the forms look at that query?

there is a one-to-many relationship between tbl_users.users_id and holiday.name is this what you mean't?

I cant enter data in the query. I have attached a copy of the query for you to have a look at. Thanks

I have looked at the above and dont think it is any of those reasons. Any other ideas? I'll try and think of a way round it. cheers

Can you edit text boxes in a form that gets its data from a select query? If not how can you? cheers

All, I have searched on the forum lots and lots but still can't find a solution to this. If you know of where there is a solution then please do let me know. I have a holiday database here where users log on and then open a form and enter their holiday using a calendar window. It then copies...

will do now, cheers

Hi all, I have a simple form here with 3 text box and 2 buttons. When I click the first button it brings up a calendar box and I can click on a range of dates and it fills in the start date into textbox 1 and the end date into textbox 2. Textbox 3 then calculates how many days there are...