Search results for query: *

dmerge generates the errror. The thre issues are: Excel will not open. Run.application no longer works in Access 2016 and I do not know how to write a macro to replace the Run.application Macro for Excel. Dim CR CR = Chr(13) is not defined (ex. AS string, object or ???? ) I do not know what...

It is a large code for merging which is causing the error. I do know this was in Access 2007, but it looks like a mess. I tried the basic debugging and compiling the code and no errors come up in Access 2016. The dmerge causes the error. The database is for inspections and facility permits...

I am totally lost. Our IT staff will no longer support Microsoft Access. We were working in Access 2010 and now we have been upgraded to Microsoft Access 2016. Surprisingly, our data base still works except when we try to run the following module. Can anyone help us re-write the module...

My autonumber field and PK are both the same field named ProjID The table is called Project, but a user is duplicating the record using a form called Preproject.

Thank you Andy. The record to duplicate is whatever the current record is the user is on in the Project form, so would replacing the following part of your code: SELECT EmployeeNo, ProjType, ProjDesc, Time, DueDate, Prog, Mod, Improve, Workplan, WorkUnits, Comment FROM MyTable WHERE...

I have a form called fPreproject. I have a code to duplicate a record in this form and paste into a new record with a new primary Key and then end with the cursor in the employee id field of the new record. Unfortunately, it does not work. I keep getting a mismatch error on the field copy...

Good evening, I am working in our public agency's Microsoft Access database which has undergone many conversions over time (MS Access 2000, 2003, 2007 and now 2013). Every now and then I run into an old command program that seems to no longer work in my Access 2013 on my new Windows 10 OS. I...

We recently reconfigured our Access 2007 database to run a word merge off one of the database queries. We open the database in Access 2013. Since we have done this, every time a user runs a merge, the database prompts the user to choose the query or a temporary query to run. Is there a way to...

I am VERY new to Access 2013. Our company does not support Access, but we have a Division dependent on the use of Access for logging employee field inspections. In 2003, the following code used to open up Excel, dump query information into an excel document, transfer the data into a word...