Recent content by George-Bowyer

Thank you. I have used a tempvar.

Actually you're right - except when you're not. Different defaults on the different forms :unsure:

Yep. That worked. Thanks. Reminded me that I'd already done something similar with something else.

I have another problem. I have set the conditional formatting set to print the fldemail field white on white if chkWithholdEmail on the form is set to true. Condition is "Forms![NavigationForm]![NavigationSubform].Form![chkWithholdEmail]=True" This works ok. However, I now want to open a...

Thanks both. I have gone with the conditional format turning the text white (as that was suggested first) and that has done the job. Many thanks. George

Hello, I have a report that generates a "Club Directory", with a page for every club showing the contact details of each officer. They now want to be able to produce a version with no email addresses given. Obviously I can do this by producing a second version of the report with the email...

Hi, Do you know if this is "open source"? Can I use the code in a db I'm building for my work? Thanks, George

The code says "If Not DCount("*", "tblmarkedpeople", "fldPeopleID = " & PeopleID & " AND fldUserID = " & intUser1) = 0 Then" So the "what" is supposed to be [PeopleID] When you open the form it finds [PeopleID] fine. When you apply the filter, it can't find it for some reason, hence the blank.

I tried that first. and it didn't work - which is why I went down the Detail_Paint option. However, I tried it again, just now, so that I could be absolutely sure that it didn't work - and it did 😵 For completeness, I'd still like to know how to resolve the other method, though...

I have a db where Users can Mark contacts for later reference by clicking a chkMark checkbox on the frmContacts (and in various other ways). When the checkbox is ticked it creates a new unique dual key record in tblMarkedPeople with fldPeopleID and fldUserID. When the checkbox is unchecked...

Wow. Thanks for the detailed reply. I can't answer your questions. As i think I mentioned above, I don't really understand what the code does or why I put it into my module. I'm pretty sure it was one of those cases where I had a problem on here (or a forum like this) and someone gave me an...

I have changed LONGLONG to myLONGLONG. This seems to have cleared the compile issue. Thanks to all and MajP.

Hmm. Sorry, I'm not sure that I understand your notation. Do the ellipses mean that I put everything else in exactly as it was before? Where does the bit with the hashtags go (hashtags are new to me in access VBA, except in the context of dates)? The annoying thing is I'm not even sure why I...

Hi, I have the following function in my "General" Module (It's not code that I wrote myself - and I can't even remember where I got it from). On my laptop, using Office365, it compiles fine when I click debug on the module. However, on my client's system the line <<Dim LongLong As...

Hi, thanks for your answers. It's really difficult to include an example database, because this one has more than 50 tables with numerous relationships and by the time I have removed all the confidential information, it won't make any sense at all. This is the form, I'm talking about. It's a...