Recent content by Richard M

Thank you all for helping me break the wall. I figured it out with all your input and did corrected errors in code. It took awhile but all is running ok now. Richard

Hi The_DOC_Man 1. All computers new and old ones are 64 Bit with Windows 10-Pro.Also the BE is located on their in-house server while the FE is in the Cloud. 2. The references in the module are Microsoft Office 16.0 Access database engine Object Library and Microsoft Access 16.0 Object...

Hi The_DOC_Man The client has about 8 computers that was upgraded to Off365. The database program is working great. They purchased three new computers with new install Off365. When the database program was installed they received the error in one of the modules. This is when we found the...

Client upgraded from office Access 2013 to office 365 and the Cloud. The program was created on Access 2007. The program works fine on current computers. Client purchased new computers with Access 365 on it. The program now shows an error coming from a module. The References in Access 2007...

Need help in finding out how to unhide a module. When the code reaches the statement "Call PersonalCalandarRead_AddN2" it gives me this error message that says: Compile error in Hidden module: Form_frmPersonalCalendarOutput_22_2Opening. This error commonly occurs when code is incompatible...

Thank you all for helping me fine the type of Access 2013 (32 bit or 64 bit) I installed. It is 32 bit. Richard

1. After my Computer crashed, Windows 7 (64 bit) was installed. 2. I then purchased Office 2013. 3. Now I am trying to find out if the Office 2013/Access is 32 bit or 64 bit. 4. So far I have not found that out. There is where I need help. Richard

jwhite, thank you for the article. I read it but do not know how to find out it my Office 2013 is 32 or 64 bit. Where do I find it? Also I am running Windows 7 64 bits. Richard M

Do you know why?

Hi everyone, the BE is on the server and the FEs are in each of the user's folders on the server. All was working fine until my computer crashed and (I believe that I installed the wrong Office 2007) when I installed it on clients, Access 2013 and my Access 2013, the code was removed. Yes JHB I...

Problem with A2013 running an A2007 database: After installing an A2007 db (created in 32bit system) on the clients computer 64bit running A2013. The A2013 removes all the VBA and Macros when opening the A2007 database. Before I installed A2007 to the client's computer my computer crashed...

Thanks JHB for your help, It worked! Now I will add this to my own help list on loops.

JHB, I checked the code and found out I had too many loops. Redoing the code made the loops work except for one thing. When the outer loop is performed the strRecordID = rs1("[ChangeOrderDataid]") does not pick up the next record. There are two records 215 and 216 in this sample. but the outer...

JHB, No I have not tried using breakpoints. Most of time I use it. But not in this case. That is the first thing I will do today. I will also check the first loop. Are you talking about the most inner loop? As far as indenting the code, I indent all my code, but when I copied and pasted in...

JHB the line strRecordID = rs("[ChangeOrderDataid]") should be strRecordID = rs1("[ChangeOrderDataid]"). Thanks for pointing that out. The strRecordID = rs1("[ChangeOrderDataid]") picks up the first record in "tblChangeOrderTable_Edit_Count" and finds that record in "tblChangeOrderData" and...