Recent content by TechieJr

I think I'm getting too old to develop a new database. Thank you dhookom, once I read your answer properly, and put the code in correctly, it worked. Thank you for your patience. BTW, I remember you replying to some of my threads 20 years ago when I was working on another database. Appreciated...

Thanks dhookom, that's what I expected and have been trying, however it is not bringing up any results. In the "On Click" Event for the button, I have: ApplyFilter Filter Name: No Sponsorship Where Condition =: [Level]=Null Control Name : This is the very same code I use for the other...

Sorry for the incomplete and unclear post. Last minute thing at the end of an overly busy day. I am using an embedded macro in the "ON Click" Event of a button in the header to update and apply the Filter property. Thanks

Hello all, It's been a long while since I've developed a new database and have forgotten a lot of tips I learned years ago, so forgive me if this seems obvious. I have a table which has a "Level" field which stores the sponsorship level of a sponsoring business. I have "Silver", "Gold" and...

Thanks rubbernilly, that solved the problem! I'm still not clear what the problem was but rewriting the code in the If..Then..Else format worked. I guess you get hooked on one method or another and don't always stop to think about other approaches. TechieJr.

Hi Rubbernilly, You're correct, the code is on a form. (Actually, the controls and option groups, etc. are all on the same subform.) However, when I tried removing the brackets I receive the error I reported in my first post. It's probably something right in front of my face but what? Thanks.

Hi again, I mistakenly posted the wrong code and error message. The correct error message is: "Compile error: Syntax error" and the code is: Private Sub Frame12_AfterUpdate() IIf([Frame12]="3",[CPRptCat].Visible = True,[CPRptCat].Visible = False) End Sub Thanks again for your help. TechieJr.

Hello All, I'm trying to use the value of one option group to toggle the visibility of a second option group. The first option group has five options. If option 3 is selected, I want it to make a second option group visible. (Eventually, I will add code to make a third option group visible...

Hi buddafish/scottie, I've never used mapi programming before but I'm game to jump into it. And yes, the security aspects are providing some extra hurdles to jump over. Thanks for the suggestions on overcoming them. If I understand your suggestion, I would be attaching an rtf document to the...

Hi dRahme, Thanks for the reply. I need to stay away from html because of the text messaging capability it needs. Any way of doing this so it becomes the body of an email in text-only format? As far as the size goes, the data is 4 columns wide and anywhere from 5 to about 12 rows (this...

Hello All, I am trying to figure out a way to e-mail the results of a daily status query in text format as the body of the message. I can do it by creating a report based on the query and emailing the report as an attachment. However, no matter what format the report is emailed in (text, html...

The query is straight forward; simple data extraction with a bit of sorting (no filtering) for display in a form. Yes, all users have access to a shared folder on a server. That is where my replica resides and I would place the backend there when I split my db. Thanks for your interest...

Hi MoLaker, The entire db is being replicated. (I'm trying to convince my manager to go with a split db, but he's not yet convinced it would be better. At the same time, I have to figure out how to "unreplicate" a replicated db, then split it so I'm ready when he is.) TechieJr.

Hi All, Pardon me if I have posted this in the wrong forum, but from my chair it was 50-50, this one or Queries. In my db, two of my forms are based on the same query, but calling up slightly different fields and displaying them in different layouts. The db is replicated and the users use the...

Thanks for the thought Telephoto, but I've already ruled this out. Other people continue to use the replica and I have done some work on the users machine. I've been trying to monitor this since my original post and things seem to be working the way they should. I'll know for sure by the end of...