Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: 347pg
  • Content: Threads
  • Order by date
  1. 347pg

    MS Word Macro error

    I have an Access db that outputs a table (from a query) to MS Word in RFT format. I've made 3 macros to apply to the table. The first one saves it as a macro enable compatibility doc (docm). The next macro changes the font in the whole table to Times NR 10. These two work great. The third...
  2. 347pg

    Deselecting in Listboxes

    I have a form which has multiple listboxes. Most of these (except one) are multi-select. The one I'm concerned about is a non-multi-select. It is an either-or box, i.e. you can choose this item or the other, but not both. I've set "MultiSelect" in properties to "None" which allows the...
  3. 347pg

    Run-time error '3075':

    I have a form in my database where people select multiple query inputs from multiple list boxes. When they push the "Update" button, these inputs should populate the query and the query should run (yeah right!). Well I'm getting a run-time error 3075 that says: "Syntax error (missing operator)...
  4. 347pg

    mde to mdb

    A guy who developed a database program for us saved it in mde format and then moved to Europe. Any creative ways to get it back to an mdb so we can see the code and correct errors? I heard this was impossible but I thought I'd ask anyway.
  5. 347pg

    Save db in new format

    I have a db (front end) linked to a back end. Both are Access version 2003. I converted the be to 2007 no problem. I opened the fe in exclusive mode but I get this error msg: "Could not use 'fe.mdb'; file already in use" What am I doing wrong. If I just open it in non-exclusive mode and...
  6. 347pg

    Can queries get field names from forms?

    My form has controls that run queries when clicked. I would like to cut down the number of queries by passing the name of a field to the query, i.e. I'd like to run the same query for multiple controls but varying the field it uses as criteria based on the form control. I tried to pass the...
  7. 347pg

    Can't open my queries in Design View

    I developed a db with tables and queries which I then exported to another db. The tables have no issues. I was able to open up both tables and queries in Design View in the first db, but in the second one I get an error. The queries run ok in the second db, but I can’t view them to alter. I...

Part and Inventory Search

Back
Top