Search results

it is still showing me the same error. It also opens up a pop-up that says yOption Compare Database Also says the same error as before too, the compile error: expected: End of Statement

It bauks on the: Function autoexec1() The very first line. I dont really understand this stuff too much. I am just going off of an already workign macro and trying to edit it to display a time/date tag on teh name after it creates the file. From there I am getting this error.

Whats wrong with the script below. I keep getting a compile error: expected: End of Statement '------------------------------------------------------------ ' Test_Locks_macro ' '------------------------------------------------------------ ' autoexec1 '...

Ok. I have a list of numbers in 2 fields. What do I do for the criteria to show the numbers that are not the same for each field. Ex: 693 703<---- 756 756 733 737<---- 733 781<---- 664 664 Both numbers are from 2 separate tables. How do I get teh query to only show the numbers that...

Here is an updated code thats a little cleaner. I tried putting in the code you gave me and there are onlyy parts of it in there. Here it is: '------------------------------------------------------------ ' Test_Locks_macro ' '------------------------------------------------------------ '...

Here is the code below that I use to export the file. How can I get the date/time stamp into this? Please help!! Very appreciated. Bowes Function autoexec() On Error GoTo autoexec_Err DoCmd.SetWarnings False SendKeys "y", False DoCmd.OutputTo acReport, "LOCKS - Detail"...

They already have that. I need something so when The file is updated, I can view it in its folder and know which one is the most up-to-date one because it has the date in the name. Bowes

I want to filter out all of the "Not assigned" so that it only displays the numbers in the field.

Is there a way I can get a date/ time stamp for reports. I run a macro that creates a report and converts it to RTF in a server file. I want the name of the report to also contain the date and time modified. Help please. Bowes

I looked through Lotus Notes and didn't even find the Macro menu for it. As far as an attachment, The people that these e-mails are going to are real busy. The report I send them is a reminder to look at it even though they could just pull it up if they remember. Thats why I would rather...

Ok. I have a schedule right now that automatically runs my macro I need and sends the report to a certain file. Is there anyway that I could extend this to copy the report and paste it onto an e-mail in Lotus Notes and then send the e-mail? Just trying to eliminate a tedious hourly task. Bowes

Awesome thanks. Bowes

Hey. Instead of going back every month and changing the date to the first. Is there a function I can put in the Criteria that will automatically filter for stuff only since the begining of the month. Right now I am using this:>=#5/1/2005#. I just want to to automatically change when a new...