Search results

Yep- i have that syntax error on 2 psc, on other 2 i don't. Can that be caused by version of sql server or something? They don't change syntax too often i guess o.O

UPDATE MEMBER SET Prio=100 WHERE Nick='Daniel' Thats what I get. Still the same problem. When I create a query manually in access and paste that query there, then try to run it it works. But from vba platform still not:/ But still- why would it run on one pc and not on the other?

Hi. I have written small access form with few update statements. On the pc i have written it on it is working no problem, on other pc it is not. Here is where i am getting runtime error 3144: db.Execute "UPDATE MEMBER SET Prio=" & Prio & " WHERE Nick='" & nick & "'" Prio is integer, therefore...

Hi. I am doing a database for a hotel (assignment at uni). I have my tables and their relationships, some forms to book a room etc. Now i need to create report, which would show rooms and guests in these rooms for next week starting from the day when report was opened. So the tables and...