Search results

I believe this is just a coding issue and that I'm overlooking something very basic. Scenario: I have an After Update function on a text box on a form that triggers an email. The VB code pulls information contained on the form and either puts it in the subject line, the TO field, and in the...

Thank you so much- worked like a charm. I appreciate your help and very quick response.

All, I have to imagine this can be done but I can't figure it out. Hopefully, someone in here can help me. I have a crosstob query with that returns 4 values: North, South, East, West. The query counts the number for each location, e.g., 4 in the South, 3 in the east...etc. This query...

The Adate wasn't formatted properly. Seems to be working now. Thanks for all your help

I did notice that. I also tried your suggestion with no luck. I can't figure out why it's truncating the end date.

Hope someone can help as my eyes are going cross... Scenario: Have multiple combo boxes (filters) that are triggered when a user runs a report. All work correctly. the ability to add a date range was requested. I searched this forum and found a link to allen browne's site. I added the...

Thanks Rural Guy that did the trick. I should change my name to quotes_are_nightmares...

Hope someone out there can help. I'm trying to open second form based on the criteria in the first. If I designate a single criteria, the second form opens without an issue. However, when I add a second criteria, i.e., using and, I can't get it to work. I'm hoping it's just a fundamental...

I checked the forum and couldn't find a specific reference to this problem. I have a form (with a few subforms) and some combo boxes at the top for filtering. Everything works fine with one exception. If a user selects criteria in the combo boxes and hits the filter button the form goes...

I'm pretty sure this can be done, but, for the life of me, I can't figure it out. I have a main form with 2 subforms. Process: 1. Filter the form to the account needed (works) 2. Enter in PO information on subform1 (works) 3. Apply the PO amounts to totals on subform 2 (works) Here's...

Worked perfectly....thanks

Hi All, After searching on here a bit and trying a few things on my own, I'm stuck. Scenario: I have a form for requisitions, which automatically pulls in the requisitioner's name based on their network ID. Luckily, the network ID is the same as the person's email address. (No problems...

This was absolutely spot on. I was able to modify that code to work exactly how I wanted it to. Thanks for all your help.

Initially, I was going to do the if box1 and box 2 solution but there could eventually be 5 or 6 boxes (like filters, in a way) and then the amount of combinations would get a bit much. I'm still having a few issues but they are mainly the "exacting" part of the report you mentioned. But at...

Thanks, I was trying to think of a different approach and your's was the direction I wanted to go but couldn't figure out how. I've made a few changes but overall this works. Thanks

I've been monkeying around with this for a while and can't figure out where the syntax error is. Maybe a set of fresh eyes can help. Scenario: Form with multiple combo boxes. A button on the form that when clicked, will open a report based on the values in the combobox. ComboBox1 lists...

Yes, that's what I've settled with; a msg box with some If Then statments. Thanks for walking through this with me as it gave me some good ideas as we went along.

The combo boxes work fine. I was trying to be a bit clever. Essentially, the user selects criteria from the combo boxes and there is a button on the form that opens the report. Since there are 3 reports, there are 3 buttons. I was looking to eliminate the one-to-one relationship to cut...

That's where I am now: one form, one query, 3 reports. I'll look at some of the grouping threads in here and see if there's something that might spark something. Thanks

Hello All, Not sure this is possible, however, I'll ask it anyway. I've created a form with several combo boxes which will act as filters on a report, i.e., AccountCmbo, StateCmbo, ManagerCmbo. I also have a report whose first grouping is Account and another for State and a third for...