Search results

Yes I was opening only the Access database when the user logs in onto their computer through Scheduled Tasks. I was getting the problem because Outlook wasn't open yet. However I added Outlook to open on scheduled Tasks before it opens the Access database. Works fine as long as Outlook opens up...

Yes, I have it all started up with a Schedule Task. Thanks Anyway to pull the user name from Outlook or user login?? I want to greet the person when they open the database up

Ah hah, must have Outlook open for it to send the email!

No, it's a real email address

Anyone see anything wrong?

I have code that would scan a recordset and email a user the records that met a certain condition. It worked fine until I added a lot more records to see how long it would take to scan. However after I did that, whether it had any effect on it or not, I now get an error message that states ...

Yes it appears to be. About to try it out. Thanks for the help

However the user last changed the columns is how it will appear no matter if you're sql says differently

Changing the order on the subform recordsource (on load) doesn't seem to change the order of the columns..

Sorry I did mean moving a column. I'll try that out... seems a little time extensive though

Hmm, will changing the order of the RecordSource change the order of what is displayed?

Hello, I have a query shown in datasheet view as a subform. The table consists of a sample number field and chemical element fields. On my form I have a combobox that filters the query by a certain chemical and a range. Is it possible to move the column that the user is filtering for to the...

Yes good ideas. I might just have him use Access to make it easier for everyone. I'll look into the FileCopy statement also. Thanks guys.

Anyone have this problem where a linked -table can't be opened in Access if the user has it open??

I have a co-worker than has an excel sheet that needs to be inputted in my database so I created a linked table to his excel sheet. My problem is, he keeps the excel file open 24/7 out of necessity, and when he has it open, Access won't allow me to open up a form with a query based off the...

Thanks, I'll take a look at it.

Maybe there's a better solution than having the program open and run at a certain scheduled event??

Yes that would work, but my problem is that I would want the database to close if the scheduled event opened the database and there were no violations. I don't want the database to close if the user opened the database and there were no violations.

Yes seems like a good idea. However if I created some VB to run on Load, this would occur everytime the Database was open, either by the user or by the scheduler. I would want to close the database if there are no "violations", but not if the user opened the database. Any thoughts?

Is there anyway to trigger a cell date or date field that when the date has passed that it will send an email letting the user know that a certain field's due date is late, whether or not the database is open? I was looking through the events and couldn't think of a way to do it, if it is...