User Profile
faxylady
Copper Contributor
Joined Jul 06, 2021
User Widgets
Recent Discussions
Re: Append query
Instead of attachment fields, store the files outside Access and use a text field to store the file paths in Access. How do I do this? How do I use a text field to store the file path? I already have folders set up with jpgs' of the receipts. I don't know how to set up paths to them. What data type do I use for the file paths? Also, how do I upload files to you? Please dont get disgusted or impatient with me. I am trying to learn. Thanks.4KViews0likes5CommentsRe: Set the Focus
Thanks for your response. Maybe we can get together next week to help solve a few other problems. I have copied and pasted this code into what I believe is a module. When I click compile, the statement appears in red with the error message, "Expected: End of Statement" The If is highlighted in blue.2.6KViews0likes2CommentsAppend 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?4.6KViews0likes12CommentsRe: Set the Focus
isladogs Thank you for responding so quickly. Single form. What I am trying to do is get the cursor to appear on the first control of the record when the end user is finished entering data on the previous record. What the cursor is doing at present is remaining on the last control entered by the end user when a new record is begun, although on the new record. I was given this code many years ago and it always worked. But now it is not. I am trying to figure out what is wrong. I do not write code yet. Will be learning soon. Private Sub Form_Current() If Me.NewRecord = True Then Me.DateofPurchase.SetFocus End If End Sub2.7KViews0likes0CommentsSet 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.3.3KViews0likes14Comments
Recent Blog Articles
No content to show