Recent content by tledwards

I use an '.bat' file to run my updates each night using a command line like this. It starts Access opens the database in a exclusive mode (/excl) and runs mac_MyMacro (/x) to update tables. No second database is needed. START c:\"Program Files"\"Microsoft Office"\Office11\Msaccess.exe...

I do a simalar link to Oracle database tables and the links my links do not show up in Access ether. I think you will have to create the links in your queries.

You might alos try setting the Unique Values or Unique Records properities of your query.

First use File/Get Data/Link to link the old database table to the new database. Then use an update query to change the values of current records if you need to. Use an append query to add records to the new table.

When you start adding "not", "or" you need to group data with "()". Try (Not "export" or not "International*" ) or is null

There is no way for us to tell if your formula is correct. If it's not giving you the answer you want it probably is not. The formula states: Multiply Sum([Total])*Sum([Average_call_length]) Then divide that by 18 Then divide that by 60

Thanks PH. I had never used it.

The word "All" is the data in the Program field. There are about 10 records with "All" as the entry for the Program field. I was not trying to use it to set up a range or get all the records.

The word "All" is the data in the Program. There are about 10 records with "All" as the entry for the Program field. I was not trying to use it to set up a range or get all the records.

I have several combo boxes on a form for people to design there on query criteria. In one field, named Program, in the data base they select "All" it the record applies to all programs. No problem with this part. But when they select "All" on the report criteria form the Microsort Visual Basic...

You need to export the key field so Access knows which field in the spreadsheet record links to the database record so it can update the old record. But the Import will still not update records. Suggest you use the File> Get External Data> Link to link the spreadsheeet to your database or...

ChaZ, Thanks for your code. It was very helpful. I was able to attached the two attachments as you said. Actually three other people will be sending out these reports and they want to add their own notes and have to add the To e-mail address before it is sent. I tried several things but could...

Is there a method to attach two reports to 1 email. I want to send a report which tasks a person to perform a number of functions. Then attached a second report to the same with my email and other information for him to tell me his plan for performing the actions. I was doing this on one...

It would look like this =Sum(IIf(Title="Mr" or Title="Mrs" or Title ="Ms",[your field name],0))

Try something like this as the control box def: =Sum(IIf(StyleA="Y",[qty},0))