Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TechieJr

    Filtering for null or empty field

    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...
  2. TechieJr

    Filtering for null or empty field

    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...
  3. TechieJr

    Filtering for null or empty field

    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
  4. TechieJr

    Filtering for null or empty field

    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...
  5. TechieJr

    Toggling Option Group Visibility

    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.
  6. TechieJr

    Toggling Option Group Visibility

    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.
  7. TechieJr

    Toggling Option Group Visibility

    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.
  8. TechieJr

    Toggling Option Group Visibility

    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...
  9. TechieJr

    emailing the output of a query

    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...
  10. TechieJr

    emailing the output of a query

    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...
  11. TechieJr

    emailing the output of a query

    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...
  12. TechieJr

    Error message in query-based form

    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...
  13. TechieJr

    Error message in query-based form

    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.
  14. TechieJr

    Error message in query-based form

    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...
  15. TechieJr

    Replication issue

    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...
  16. TechieJr

    Replication issue

    Hello All, I have a db which is replicated. Design Master is on my desktop and the replica is on a server. One particular user keeps claiming that she is making her entries but after I syncronize key fields are empty (in the design master). Furthermore, when we go back into the replica, those...
  17. TechieJr

    Crosstab query problems

    The row headings are generated by the queries in association with the table that is used in this crosstab query. As I mentioned in my original post, I have two queries which are the source of info for my crosstab. Each of the "feeder" queries supplies an aggrigated total (one being the count of...
  18. TechieJr

    Crosstab query problems

    Hi Dorling, What I did was to open the query properties page (open query in Design mode > right click on table area at top > Properties), then typed in the names of the columns that would be coming up in the query results. Each name had to be in quotation marks and seperated by a comma. For...
  19. TechieJr

    Changing txt box colors

    Thanks Ben, this works just great. I can think of a few otehr places in my db where this can be put to use. TechieJr.
  20. TechieJr

    Crosstab query problems

    Thanks Duane! That seems to have cleared up the problem. Why does it seem that it is the little things that bring things to a hault? TechieJr.

Part and Inventory Search

Back
Top