Search results

Okay, so if I use a form to collect the criteria prior to viewing the form, it should also pass to the report when it's printed thus alleviating the need to re-enter the criteria at all, correct?

Hello all, I've got a report which contains two subreports. When the report is open the user must provide a criteria, in this case the year, and the report will generate using two subreports that use the same criteria. The issue is this: When I go to print the report it will ask for the...

What is the function of the button? Is the database opened and closed multiple times a day?

I have a report that is pulling data from a table. I decided that I wanted to group the report by a field that I had in the details of the report, so I moved it up to a head section and grouped on it. Now when I run the report the field is blank...move it back to the details section and...

I have a revolutionary approach for you...try not being an ahole.

Trev, Thanks for the suggestion, but that didn't seem to work. Kept tinkering and finally got it. Thanks for pointing me in the right direction.

This is probably so simple it's stupid, but I can't figure it out for the life of me. I have a command button on a form which when clicked I would like it to open a second form and pass the value in the "controlnumber" field on form A to "controlnumber" field on form B. The code I'm using...

Thanks...those examples should do the trick!

Hi all, I have a date field in a report that I would like to populate with the date which is 5 business days from the current date (date report is generated + 5 business days). Anyone have any idea how I would do this? Thanks

works like a champ. Thanks!

Hi all, I'm using the following code to dump a report into an excel spreadsheet: DoCmd.OutputTo acOutputReport, "rptPBC Query", acFormatXLS, "I:\pbcdump.xls", True Since the report gets run multiple times I was wondering if there is a way to insert a time stamp as part fo the file name so...

Thanks for all the feedback...looks like it's time to really learn VBA

I've seen comments around the board about how people feel that using VBA over a macro is the better way to go, but can someone tell me why? My VBA knowledge is limited and I generally can get things to work with the help of a number of you on this forum, but I'd like to know why VBA is the...

Got it working! Thanks for your help!

I appreciate you going through the trouble of setting up a file and testing it for me. I'm going to take you suggestion and convert the beer control to a bound combo box and try and muddle through it. As far as my attempt at Paul's code...I'm by no means a coder so I'm just trying to figure it...

PBaldy - I've tried your method, but I can't get it to work. I've got controls that I'm grouping together using the tag property, but I'm not sure how to translate that into the smaple code you provided. If Me.Beer = "domestic" Then Tag.domestic.Visible = True Else...

I'm taking a look at your DB. What is TTOE? Is that supposed to be Total Time since Engine Overhaul? Also, why are you logging time as minutes? Is there no hobbs meter in the a/c?

I tried that and a number of variations. The problem is when the form opens I need the controls to be set depending on what appears in the beer field. If the beer field is populated with "domestic beer" then I need all of the controls that have been tagged domestic to be visible and all the...

Hi All, I have a form that, when it opens, has a field "beer" that is populated with one of two possible options. Then I have a number of buttons that need to be either visible or hidden based upon what is populated in the beer field. The buttons are all tagged; one group of buttons is tagged...

Re: Pop up won't stop poping up Scratch it....figured it out. Had a script that was forcing the pop up.