Search results

  1. N

    Totals Query Query

    Friends, I'm having trouble grasping why I can't get my totals query to work correctly. I have a table called tblEvents. There is a field in this table called [Outcome]. The [Outcome] field will have one of three values: 1. "ESTIMATE FULLY SUCCESSFUL" 2. "ESTIMATE PARTIALLY...
  2. N

    Problem filtering subform

    Got it. No, I suppose I didn't have things exactly the same way afterall. For starters, I didn't even have the "FilterOn" line in there. With your example, I got it rolling. Thanks a lot. Take it slow. -Lou
  3. N

    Problem checking subreport values

    Friends, I need any and all help with this report/subreport problem. I have a report that pulls info from the departments (Operations, Analysis, and Specops). Users from each section input data into their own data entry forms. Records from each section all have a SITREPNUM field...
  4. N

    Problem filtering subform

    hmm le888, Okay, now I'm confused. I had the exact set up as you (converted Alpha buttons macro to vba), but I continued to get the error msg that says my form is not based on a table or query. I must have overlooked something, or the cause of my problem is altogether different from what I was...
  5. N

    Line Breaks in forms and reports

    Got it. Turns out that it was a problem with my References. They were all there (none marked MISSING), but I just had to reset them. This thread helped me out. :D
  6. N

    Line Breaks in forms and reports

    :mad: Why in the world doesn't this work for me? I've got it exactly the same, but Access keeps telling me that "The function you used can't be used in this expression. It does not allow me to put any Chr() keywords in the control source.
  7. N

    Problem filtering subform

    Tried that already. Yeah, I thought that maybe if I just convert the macro and use the VBA, but negative. Same exact result, error message. I am pretty sure that it has something to do with the ApplyFilter action. I'm thinking that it automatically tries to filter the active form. Since, in my...
  8. N

    Problem filtering subform

    Yes. As I mentioned, the form works fine if its opened up by itself. It fails to work only when I open it through the subform in my switchboard. I figure it has something to do with the way the ApplyFilter action works. It seems that it may be trying to apply the filter to the parent form...
  9. N

    Problem filtering subform

    Friends, I'm having an odd problem with my Contacts Addressbook form. I have a addressbook-style form that lists several buttons along the bottom (i.e A-z, "ALL") that are used to filter names matching the selected letter criteria. The same set up is used in the Northwind Sample DB. The...
  10. N

    Hide selected records in a subform

    Friends, Haven't seen a similar post yet, so here goes. I have a typical QBF search form which returns criteria matches in a continuous subform (fsubSearchResults) at the bottom of my main form. Oftentimes I want to isolate (or remove) certain records returned in the results subform. I...
  11. N

    Pop-Up Reports

    Thanks, Wayne. What would this be like if the field [Name] was a number field? I thought that I would not need delimiters for a number field, but I can't get this thing to work. using my own fields I have: sPrint "rptTranscriptDetails",,"[TRNumber]=" & [txtTest] I also tried this: sPrint...
  12. N

    Pop-Up Reports

    Roger that. Thanks again, Wayne. The [Name] deal was just from a sample db, not my own. Take it slow. -Lou
  13. N

    Pop-Up Reports

    Question IMO, This looks great. I'm having a bit of trouble with my where clauses though. I want to have a similar ReportViewer form that is opened from a main form's 'Print Record' button. Do you know how I could pass a value from the main form as a criterion for filtering the report...
  14. N

    Input mask problem with continuous form

    Friends, I have a contacts form which contains a subform (continuous forms) for telephone numbers. The subform is necessary since each contact will have several (3 or more) numbers each. The telephone numbers are not formatted the same way, however, since some of the numbers are international...
  15. N

    Database appearance

    I think Mile-O-Phile got it right in his last post. We all can respect the pride you have in your own considerable creativity Mr. Sinatra. Unless you have just created something truly revolutionary (a la HAL 2000), however, you probably need not be so paranoid. I imagine that the original...
  16. N

    Error using function in control source expression

    Not sure what the problem is. Everything is spelled correctly. I don't have the problem until I try to add the Right() function in there. There is no special way that I have to wrap functions in expressions are there? Could this be a reference problem? I don't see anything missing.
  17. N

    Error using function in control source expression

    Can anyone tell me why I keep getting errors when I try to use a standard string function in my control source expression for my report field? This is the expression: ="POC: " & [TitleRank] & " " & [FirstName] & " " & [LastName] & " at x-" & Right([WorkPhone],4) I keep getting the following...
  18. N

    String function questions

    Thanks, well done. Sorry, I haven't responded sooner. This is great. I really appreciate both of your efforts. This was a problem that I was just resolving myself to dealing with. It wasn't a show-stopper problem, but things work a lot nicer with this solution. I will attempt to resolve the...
  19. N

    String function questions

    Beginning of line in memo field What I think I need is a way to move to the beginning of the line in the memo field, then move forward ten spaces without overwriting the previous text in that line. Everything I have tried up to this point merely creates a set number of spaces from where I...
  20. N

    String function questions

    Question Did you actually get this to work? What exactly did it do for you, because mine did nothing. The only thing I added was a trap fo the Keycode 9 (tab) by setting it to 0, and the rest was the same. Thanks again for the response.
Back
Top Bottom