Search results

Same error. The above code in red is highlighted with it. :banghead:

Yes. I now get a run-time error '3061' Too few parameters. Expecting 1. Thank you. I gave this a shot, and I get the same error as a few posts up: Compile error: Expected: list separator or )

ok, but guess what? I'm missing something again. CurrentDb.Execute ("INSERT INTO tblBosTracking ([Observed By], [Input Date]) SELECT [Observed By] , [Input Date] FROM tblForm2Input WHERE (tblBosTracking.BOSID = " & Me.ID"))

...but I knew I'd forget something. What do I add if I just want the current record I'm inputting added, and not the whole table? :o

doh... I tried putting brackets between all of them, but not just between the INSERT INTO part. Once again, thank you and the code works perfectly!

Opps. Alright then. I have a new error: CurrentDb.Execute ("INSERT INTO tblBosTracking [Observed By], [Input Date] SELECT [Observed By] , [Input Date] FROM tblForm2Input") I do appreciate your time and patience with me.

Private Sub saveandnew_Click() DoCmd.Save Me.Refresh CurrentDb.Execute ("INSERT INTO tblBosTracking [Observed By], [Input Date]") SELECT [Observed By], [Input Date] FROM tblForm2Input Me.Refresh MsgBox "Record Saved Successfully!" DoCmd.RunCommand acCmdRecordsGoToNew Me!F2Date.SetFocus End Sub...

Thanks again pbaldy. Although I seem to be having trouble implementing that code into mine. I keep getting

I'm trying to get my code to copy certain fields from one table into another after a button click. I got it to where I stopped getting error messages, but my tables aren't updating. I want data from tblForm2Input copied to a new record to tblBosTracking. Private Sub saveandnew_Click()...

And it's a beautiful thing. I had a feeling I forgot something...figures it would be so simple lol.

It's still a work in progress...

That took care of that. Now when I try to choose an option in the combo, I get a pop-up error: and the whole line of code is highlighted: Me.EID = Me.[Employee Name].Column(1)

pbaldy, this is exactly what I'm looking for, but if you could please give me some direction for a compile error for the code: My combo is "Name" and my text box is "EID". When I debug the code, I get an "invalid qualifier" with .Name highlighted. Private Sub Name_AfterUpdate() Me.EID =...

Excellent. Thank you so much for this and your help!

Thanks so much! I apologize for the confusion.

The purpose for this query is to get a list of all our employees that have not been included in the occurance input table within a date range. Hmm...I'll have to figure something out unless you have an idea?

I do appreciate your help. One of the goals is to do this query within a date range, too. How do I go about doing that?

Very good, sir. I suppose I wouldn't be getting any values if I pull the date from occurance input...duh on me.

I might not be doing this exactly right, because I'm still getting no results. Here is my SQL: SELECT [tbl occurance input].ID, [tbl occurance input].Date, [tbl occurance input].EID, [tbl eidandname].[First Name], [tbl eidandname].[Last Name], Format([Date],"m/yy") AS Expr1 FROM [tbl...

Hello again. I have a query (Drawing Query) based off of two tables: "tbl eidandname" and "tbl occurance input". What I'm looking to do, is build a report to include all names off of eidandname but exclude them if they show up in occurance input. The common field between the tables is "EID"...