Recent content by NachoMan

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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