Recent content by Harris@Z

I included the Is Null in my recordsource, and that resolved the issue. I am grateful to all your input, and particular for the solution (which is so obvious in retrospect!) Thanks all for your time in guiding and helping me. Harris

Thank you, a great lesson! I tend to forget to keep the code 'clean'!

Thanks for all your input, much appreciated! Apologies for not responding to all the questions. Yes, there are other categories, e.g., Quality Manager, Food developer, etc., although most have no entry. I will evaluate considering null in my query for I appreciate that it may be as simple as that!

Thanks for your inputs! These are two records in the table - identical except the one has "Accounts" in the Category column. Contact_ID Company_ID FirstName LastName Telephone email Category 11843 3524 Ilona Doggons 78014 ilona@naturalc.com Accounts 11866 3524 Ilona Doggons 78014...

Thanks for your responses. The dB is fairly large, and connected to a sql server backend

Hi, I hope someone can shed a light on this - seems so simple yet the answer alludes me. This works in a form query: SELECT Contact_People.* FROM Contact_People WHERE (((Contact_People.Category)="Accounts")); However, I want to have the record source exclude "Accounts" from the field Category...

Thank you, a super solution. Makes it easier to incorporate with my the intention I had in mind! Much appreciated

Thank you, worked like a charm! I found similar ideas on other sites but simply could not get them to work. Your explanation was spot on, and I was able to translate this within seconds. Much appreciated. H

Hi, I hope someone can assist. I have a table with the following fields: Contact_ID, Company_ID and EmailAddress. The situation is that the same email address can be associated with 1 or more companies. Therefore the Contact_ID and Company_ID will differ from the same email address. For...

Hi sonic8, Fantastic advice, so much I have learnt. I always learn a great deal from Access-Programmers! This in particular is very useful and I will try this: "If you only want to connect to one single IP address or domain name, then add a very specific exception for this scenario to your...

Thanks for both your inputs. I have no experience with this, so I was wondering whether someone has found a way to deal with this, possibly "unlock the door", then "lock" after sending. I have been struggling with working out what rule to add to the firewall - seems like it wants to know what...

Hi, I am struggling to resolve this, and may not be resolvable because of firewall security? I trigger this FTP code to upload a PDF file which has just been generated to my website. If I deactivate my virus protection software, works fine. If not, is blocked. Any suggestions whether there is...

Thanks everyone for your input. After trying a range of variations, I eventually discovered that the antivirus software/firewall was blocking the code from executing! Hard lesson learnt, and a possible solution to others having this problem in the future.

Thanks for your guidance! I am not a professional developer so learning fast! Home computer: Microsoft® Access® 2016 MSO (Version 2302 Build 16.0.16130.20754) 32-bit Office computer: Microsoft® Access® for Microsoft 365 MSO (Version 2309 Build 16.0.16827.20130) 64-bit

Apologies for the way I posted the code! And thanks for pointing this out. The database is primarily developed on my home computer, Access 2016 and 32-bit Access and Windows 10. At work runs on Microsoft Office 365 Access, 64-bit machine - Windows 11 Pro H