Search results

The goal here is to open a query where a field = a control on a form [Forms]![Billable Query Form]![ProjectNumberOnBillable]"). The criteria is in the query. I want to run the query and check it for records. The debugger stops the code at Set qd.Parameters. Private Sub CmdInvoice_Click() On...

I have a Template email message saved as an HTML file that I would like a SendObject macro to use when it opens a new email message. In the SendObject macro, I have typed the following in the Template File argument: "C:\Documents and Settings\cimbrie\AA Database\Invoice test Template_files". I...

How do I use the Like Operator to query for records that do not have some particular data in them. I know how to query for records that do have the word "Boston" in a particular field; Like"*Boston*". I want the records that do not have "boston" anywhere in field1. I have tried...

In older versions of Access, after I compacted a Db, I would check an option to 'Show System Tables' to see if any MsysCompactErrors tables were created during the compact. I can't find how to do that in 2007. Thanks ahead of time.

I am getting used to Access 2007. I have a text box in a Report that I want to combine (concatenate) fields in. I get an error message saying that Access can't find the fields. I'm going a little crazy because I have done this many time before. If I put just one fieldName in a text box Access...

I found a web site that reports 2007 bugs that says this: Do not use offline folders to store your databases. Actually, the full thing says: Update Sep 14, 2007: There is now a known issue where a database stored in offline folders is lost when compacted. There is also another bug where you...

I want to automate Exporting some tables to another Access Db. The Macro halts saying 'can't find the file'. I have checked names and spelling and path. I have tried typing .mdb at the end of the destination Db. I have read everything I can find in this forum on the subject. It seems to me I am...

I have to make a new copy of a db starting with a blank db and importing all the objects into the blank. (Corruptions issues). When a blank db is made, and the objects imported into it, the security permissions do not copy over. The only way I know how to get the security permissions back is to...