Search results

Hey guys, I finally got the solution: SQLstring = "Insert into [Hours]([Entry date], [User], [Hours], [Task], [Description]) " & _ "Values (#" & Me.Controls("day" & I).Caption & "#,'" & TempVars!tmpUserID & "'," & _ "'" &...

I took your advise Estuardo and tried a simple insert query. SQLstring = "insert into Hours (Entry date, User, Hours, Task, Description) " & _ "Values (#24/4/2013#,31,6,147,'wiugwiuf')" DoCmd.RunSQL (SQLstring) Even that does not work. I get the error message...

small update! I found the error, instead of [User] i wrote [Uses] :D That solves the error message. But after a few syntax errors I'm left with a "End of statement" error on this code: SQLstring = "Insert into Hours (Entry date, User, Hours, Task, Description) " & _...

Well I'm actially working on a form yes. I have labels for the date and textboxes for the hours and the comment. The Me.Controls("xxx"&I) is uses to access all textboxes with help of a Loop where I is the iteration. TempVars!tmpUserID is a temporary variable set when the user logs in the...

Thx for the fast reply Estuardo but your suggestion does not work.

Hi all, I could use your help on this one. I get an error (Run-time error '438' Object doesn't support this property or methode), when I try to execute the following insert query: SQLstring = "Insert into Hours (Entry date, Uses, Hours, Task, Description, )" & _...

Hi there, I have some troubles in one of my forms, in fact what i'm about to explain could be impossible to realize. Let me illustrate with the image on this link to show you the form : ht tp://hpics.li/017d706 (ht and tp seperatet to post the link in my 1st post^^) My database has a few tables...