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...
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...
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)...
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.
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.