Search results

  1. E

    QueryDefs parameters "invalad property"

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

    SendObject Outlook template

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

    Not Like operator. <>Like

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

    Show MsysCompactErrors tables in 2007

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

    combine text - can't find fields

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

    2007 store online or offline?

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

    TransferDatabase path - file not found

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

    Copy and paste security permissions from copies of a db

    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...
Back
Top Bottom