Search results for query: *

I have an Access 2007 database that has links to 38 excel files. The Excel files are recreated every month with the same filenames which overwrites the previous data. The idea was that since the filenames are the same, Access would find the files with the new info and be linked automatically...

I've got two problems to solve. I need to create a .pdf file from a report then email it, all from the click of a button if possible. I'm not finding much information that I can use. If anyone could point me in the right direction I would very much appreciate it. I'm using Access 2003. Thanks

I've got a report printing store locations. At each store there may be one or more machines serviced. My report list them all. What I want to do now is to insert an AVG line only for the stores that have two or more machines. I don't want to print an average() line for the stores with one...

I have a report (in Access 97) that needs to print the name in blue if the Last Name is "Smith" and I can do that. However when I also try to get "Jones" to print in blue the "Smith" record goes back to black. Its either every name is in blue or one in blue. I can't find a way to target selected...

I'm trying to print a maintenance checklist on the bottom of a report. However that checklist can vary based on the machine type. How can I print different checklists at the bottom of my report? I've tried making sub-reports visible/invisible but can't seem to make it work. There is no data...

I'm trying to copy data from an Employee table into a Termination table. I select a SocSecNbr from one form and have it open the Termination form. If it finds related records it display them correctly. The problem comes in when there is no record and it opnes a "NEW" record. At this...

I am trying to secure my database. Everything is going OK except I have a query that creates 2 tables that I combine for a report. I assign permission to the tables and all looks ok. But when I run the report I am told I do not have permission to the table. I think it is because the table is...

This is a little complex so I hope I can describe the problem correctly. I have a form with several unbound fields. I fill these in and push an update a file with the info. Works OK. Info is added to the file. One of the fields is a combo box with names called "Name" When I type in a...

I need to know how to use one of my existing queries as the record source using vba. I've tried the examples in my book but it never works. I am trying to export this data from the query into and ascii file but never get a recordset that I can use. Any information would be most appreciated and a...