Recent content by feinj

HI pr2-eugin, No this will not work for me since neither of these deal with this specific situation. Thanks,

Hi everyone, I have a situation where, in a query, I need to autofill the column called "Xferd Vendor No" from the column called "Vendor No", where if the data in the Vendor No column changes, then the autofill changes to match. Please see the two attached files. The one called Autofill Raw...

I figured out the problem. I renamed the function to FileCopy, rather than CopyFile and it worked just fine. Thanks for the help.

I tried applying your code in a public function and when I launch the function from a macro I get the error message "The expression you entered has a function name that Microsoft Office can't find" function code I created so far is shown below: Public Function CopyFile() As Boolean...

Hello all, I need to create a function that I can launch using a macro that will copy an excel file from one folder to another in the file system. Can anyone help please???

Thanks pbaldy. Your solutions works perfectly.

Please help, I have developed a private sub which automatically creates an email when a button is pushed. The code is working well, but I need to insert Carriage Returns in the Body Text of the email just before the word "Please" where it appears in two places. Is this possible? The...

JohnLee, I tried the second of the two options you provided and I get a Run-time error '424', Object Required. On First Line of Code, under definition I get the following message: Identifier under cursor is not recognized. See my code below: Private Sub CopyFile_Click() If...

I just want to have a Macro that will copy an excel file from one external folder to another and alter the file name to include the current date. I have exhaused all other searches and cannot find a workable solution. I have seen and tried several examples of code, but nothing seems to work...

OK, Thanks for the help.

Hello all, I have a requirement where I must develope a running sum of quantities in a table using a query where the running sum resets when the Assy_Item changes. Example Output is attached. Please help. I cannot figure this one out.

Hi Lagbolt, Thanks for the reply. Can you tell me how your simple zoombox can be applied to any text or memo field on an access form while being run in the runtime version of access 2007? I can see how your zoombox will zoom the specific field "tb" in your ftest form. But I need the...

Hello all, After deploying a new database to several users in Access 2007 Rutime, I discovered that the Zoombox Functionality does not work in runtime. In the access program I have created a form with a Zoombox Button linked to an event procedure as follows: Private Sub ZoomField_Click()...

I am in desperate need of some help here. I have a situation where I must convert data in an existing access database for use in a new database. The existing data has multiple line entries for the same header number, but has not identified each of those line entries with a line number. I...

Thanks again pbaldy. The function worked great.