User Profile
faxylady
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Append query
I am trying to append several entries from one table to another. I keep getting the error message, "An Insert Into Query cannot contain a multi-valued field." In the criteria row I put "between 07/01/21 and 07/08/21." When I chose Append Query, I chose the correct table from the Append to Dialog Box. What am I doing wrong?3.9KViews0likes12CommentsSet the Focus
06/08/21 Many years ago, I acquired some code to allow me to have the cursor start on my first line of my forms. Even though I have changed the lines to correspond with each form, for some reason, I can no longer get it to work. The code is, “Private Sub Form_Current() If DateofPurchase.NewRecord = True Then DateofPurchase.DateofPurchase.SetFocus End If End Sub” Previously, this has worked fine. But I can no longer get it to work. I also clicked Debug, Compile. Still it doesn’t work. What I want is for the cursor to appear on the first line of the form instead of where it was left on the previous entry entered by end user.2.7KViews0likes14Comments
Recent Blog Articles
No content to show