Search results for query: *

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.

I have a form that has a time field that shows a median time. when you don't type in am or pm it assumes am automatically, i didn't program it like that, it just is. The form works fine but the users are rebelling, they don't like having to remember to type in pm for the afternoon work. I...

I got it working. I added varTest = Nz(varTest, "0") right after using DLookup and changed the if to check to see varTest = 0 instead of null.

I decided to use If and this is how I am using it except it always skips the Else instead of doing the Then. Here is the code I am using, any advice would be greatly appreciated. What this is doing/should be doing, is using dLookup to compare whats in the recordset to another table named AM...

DLookup works great. But I am running into trouble now in an if statement. I started a question about if I should use an If or IIF. thread705-1066072 I'll ask the rest of the question there since it involves more of the If than DLookup. Thanks for everyones help.

I am having one heck of a time to get the result of a sql query to load it's results into a string variable. I have tried the follow but get a Compile Error that says Expected Function or Variable, then shows my code with .runsql highlighted in blue. The strSQL will only ever result in a 7...