Recent content by zebrafoot

Hi both, Many thanks for your very quick responses. That code works, thank you! Best wishes, Pete

Hello everyone, Our company database has a facility to add a folder containing pictures or files of any inventory items we keep. There's a button in the appropriate form that has an "on click" command to check to see if there's any folder in the appropriate place for the numbered inventory...

Thank you once again for your help.

Thanks for that, arnelgp. Will the bit Nz(txtSupportContractID,0) not return a zero when there is no SupportContractID? This won't happen, as there won't be a line in the subform when there is no Support Contract. What I'm after is counting the number of visits, but returning a zero when there...

Actually, I think I've answered my own question: =Nz(DCount("*","tblSupportContractVisits","[SupportContractVisitTypeID]=1 AND [SupportContractID] = txtSupportContractID"),0) seems to work. Does that look right to you experts? Pete

Good morning, I'm tying myself up in knots trying to count the number of records that match two criteria to be displayed in a subform. I appreciate that there are similar questions on this forum, but I can't find something that matches what I'm trying to do, hence I've asked here. Thank you for...

Just dropping back in to say that the issue seems to be resolved. The person who assists with our IT stuff has set up an entirely new Hamachi network for us. Apparently the original connection was via Mesh and he has changed it to something else (Gateway?). This appears to work through Eduroam...

Thank you for taking the time to look at this, Doc Man. Food for thought. As a first step I will ask the boss to check the server setup and see if that gives us any further idea of what's happening.

Thank you, Gasman. I can open the folder with file explorer I assume you mean I should do this from work (via Eduroam)? I can ping the computer from home without issue and open the folder to view files on his laptop.

Hi George, and thank you. I will try when I'm next on site - currently I'm working from home, so I'm unable to replicate the issues.

Hello, Yes, ok, apologies. I don't know enough about Eduroam to supply much detail, but it is an international WiFi internet service within Universities/higher education. Access will start (the front end is on my laptop), but the first page of the database does not load, so it's not possible...

I have been running the company database for the last few years. We have a split database with the tables located on a laptop connected to a router in my boss's house, while each user has a front end on their own computer. Connection into to the tables is via a free Hamachi VPN client. As we...

Thank you for the explanation of the reason for the syntax error and for the above. I appreciate there is a LOT of data in the listbox - my boss likes to be able to see everything at the same time! You will appreciate that the listbox font size has to be very small.

Thank you very much for this. It works for me, and it's also nice and simple to follow.

I'm not familiar with this approach. Could you expand, please?