Search results for query: *

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...

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...

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...

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 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 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...

I am having a very hard time figuring out how to do the following. I have a small table, users enter data into it. Most of the time the Phone field matches a completion table but sometimes the Phone is completely new. When the user clicks update, i need the code to update the Phone records...

I have spent the last week working on coding a way to send an e-mail from Access with MS Outlook. I finally got it all figured out and have it running perfect for Outlook 2003. Turns out, the 3 people that will be using the database are running Office 2000 and my code doesn't work on their...

Is there a way to get rid of the popup that says your going to update so many records?

I have a small table that all the fields will be updated the first time a user enters data. Then only 3 fields will be updated from then on. I need to take the data entered on the first record, last 2 fields and have it autofill the rest of the records, no matter how many more records are...

I have Office 2003 and using Outlook 2003 w/message format as rich text. When I'm running the DoCmd.SendObject acSendNoObject, , , , , , "Test", "testing", True It brings up the e-mail, the subject line but the message text of "testing" is not there. I have tried changing the message format...

I put together an Access form that links to a simple table called faxination1. I was able to get the strSQL to run but the user has to hit the cmdSearch button for each record on the table. I am trying to get a recordset connected to the table so that I can set a loop to work until it reaches...

What I need to do is have a single form that users can enter info into 3 fields and then click a button that will fill in the rest of the form, 2 more fields. I can't get this figured out, and I'm not good at VBA. Any help will be greatly appreciated.

I have Access 2003 & Outlook 2003. I need to take the results of a query and have it send in an e-mail but not as an attachment, but in the message body. I can get it to do it as an attachment by using SendObject in a Macro. Any help is greatly appreciated.