Search results

Thank you!!! That seems to have fixed it. I've been writing Basic code since the 80's and haven't done it this way. This is the first time I have run into a problem.

I am getting closer I think! The snips attached below show code that isn't working occasionally on customer computer. Why?

After the bugs are worked out, I will give them local FEs. Since they are both using the same copy on the server, can the references differ?

I'm not sure if this is the correct forum, but thought to start here with my bizarre problem. Access program for small manufacturer written by me 2000 or earlier. I finally talked them into upgrading to modern version. I converted to .accdb files for FE and BE and got through a few little...

The image is of the subform wherein additional items are added to the order. Once an item is chosen from the dropdown, it is added to the next empty line. The After Update macro below is embedded, but doesn't work. It is not showing error; it just doesn't make the little button disappear (...

Wow! How quickly all of you answered! Love this site! Still getting the same error. What I am trying to do is after an item is added to the order (within the subform), I want to check to see if any "cdc's" are present, then make a change (visible or color,etc.) to a button on the main form...

Customer's order entry page has buttons for printing numerous reports, and each button has a smaller button beside it to do a printpreview of the report. They use these little buttons to see if there is no data for that particular report. Is there a way I can test for no data ahead of time and...

theDBguy, I do have many in code, but none in the form giving the trouble. A couple of questions: will the new version always give an error when it encounters a DoMenuItem? Am I correct in assuming that it isn't backward compatible? ie, will the mdb run if I now save the accdb as an mdb...

arnelgp, just checked and the Default Open Mode is shared. Permissions on the folder containing the BE and Fe are all checked for everyone--same for the FE and BE file permissions. This all had to be thus, because they had been entering data and printing reports all morning before they tried...

Where do I find DoMenuItem?

Client database written eons ago--finally convinced them to install 2016 version so I could convert front and backend to accdb. Total of 5 users. Suddenly they can't start a new batch of invoices--"Exclusive Access of the MS Access Database denied." At the time of error she was only one using...

Thank all for your posts. I have solved the problem. First, I ended up wiping the computer and reinstalling Windows home. Reinstalled Office 365. The db still wouldn't work (yes, with a struggle finally found link to install 32 bit version). Did a deeper dive researching the problem...

I have now done a clean install of windows 10, reinstalled Office 365 and tried to install the odbc connector. I downloaded the installation msi again in case my copy was corrupt. I have asked for help from MS and they will be happy to help for $499 single incident because the driver in...

I'm not sure this is the correct forum for this, but I desperately need help. I opened (on my laptop) a well established Access 365 db in the am. Later in the day I tried to open it again and received "odbc failed to connect" and the laptop had not been used in the interim. Tried another db...

Wow! Thank you vba_php! Love this forum and do so thank you for your post. Works like a charm. No, I wasn't already using Folder Picker, and yes, I am using Office 365. Private Sub Command40_Click() On Error GoTo Err_Command40_Click Dim Myfile As FileDialog Set Myfile =...

I have a button allowing the user to browse and save a file location for an email attachment as part of the setup screen for a cdo send email routine. It is code I downloaded many years ago and has worked until recently (last documented use was 9/28/2019). Now, instead of grabbing the full...

isladogs, your link to mendipdatasystems looks interesting--will get to it when I can. Meanwhile, my main computer got a virus that removed my user accounts, so I couldn't log in. Have spent two days trying to get it restored. I have Acronis full backups, so with a little help from them I have...

isladogs, I am just now back into this. I am attaching an another copy of the modules, this one containing the only form that uses the FTP functions so you can see what I am doing. I have not incorporated your changes. If you need anything else, let me know. If you would point me toward...

isladogs, I have attached current modules. The ShowError sub is called in Function FTPGet. I can find no other reference. As you may surmise, the FTP_Functions module was something I found online several years ago--it worked perfectly without my having to pick it apart and totally understand...

Isladogs, I actually have it running, thanks to you! It is working on both 32 and 64-bit machines. I have one problem remaining, however. When I compile in 64-bit setting, the following errs: Sub ShowError() Dim lErr As Long, sErr As String, lenBuf As Long 'get the required buffer size...