Recent content by FeS2

Thank you SkipVought, that works perfectly. FeS2

Access 2007 I am having trouble with a query that I think should be an easy fix but I can't seem to find it. I have 2 tables, the 1st table is a list of telephone number prefixes and the cities they cover, the 2nd table is a list of phone numbers and cities. My goal is to find where a phone...

I am trying to import e-mail from Outlook 2007 into an Access 2007 table. I can import the entire e-mail except for the attachments. I have the following code but get an "Invalid Argument" on the rstAttachment.Fields("FileData") = moAttachment line. For background info, I do not want to save...

This is exactly what I was needing. Thank you guys for the quick reply

In Access 2007, I am trying to figure out a way to take a number like 2271100 and then generate and insert into a table the remaining sequence of numbers up to 2271199, ie.. 2271101, 2271102 ... I am wanting to do this using a query but have searched around and only been able to find how to do...

I am looking for a replacement to the built in MS Query that comes with Excel 2007. In the company, we used to use Proclarity Live to run queries in excel and return the results, it was easy to use, worked very well with parameter queries. However, it doesn't work with office 2007, and the...

Great, thanks for the replies. I was able to use the Security built into Access to limit the record updates but allow the users to create new forms and queries, also with it set to no password, it can be given to new users and they get the same restrictions without having to memorize another...

I am setting up a new front end for a database but need to make that front end unable to make any changes to the data/records in the back end database. I looked at Security but do not want to have to make the people using this front end log in. I want them to be able to make new queries or...

What I need to do: We receive e-mails into Outlook 2003 that have an Excel attachment. I am trying to figure out a way to have Access find the e-mails from the specific sender and either open and import the attachment to a table or just link the attachment as a table. So far I can only...

I am running into problems with a macro that I have to do some formatting of a spreadsheet. It runs fine on my machine (I have Office 2003) but runs into problems on other machines (They have Office 2000). I figured out that when I record a macro, my Excel adds in extra code that the 2000...

Is there a way I can get Access to close automatically after a period of inactivity on a users computer. I have a database where for some reason, no matter how often i tell them the users will get up and go home and still be in the database. Which makes it hard for me to do the backups in the...

Ok, i never got a response but i think i found out what is happening. I can drag any file type i want into the ole field of the record in access except when the e-mail was sent as a plain text e-mail.

I am having a problem dragging an e-mail attachment directly from Outlook 2003 to an Access 2003 record. The record is set to be OLE and embedded and the update is set to Automatic. I can save the attachment to my computer and then drag it into the record but i want to skip that step. Is...

I have Access 2003 and Office Outlook 2003. I need to find a way to link an e-mail in an outlook folder to an Access record. I know that I can copy the e-mail to the record but the database would get huge since the e-mails contain wav files. I was thinking that since Outlook is already...

I was just able to find a downloadable file from Microsoft that has all the programming refences including all the Outlook Constants. Thanks for your help, i'll let you know how it goes.