Search results

Your code did what I wanted. Now, I need to know how to have it do it for a main report and a sub-report, with the code in a form's combobox where an integer that represents a trip number and the main report displays the trip leg records (date, mileage, city, etc.) and the sub-report displays...

I used theDBGuy's code and it does what I wanted done for single reports. Thanks for you help.

I solved my problem by using a very unprofessional method that i thought I'd try. I copied the sub-report's page header, where the wizard placed it, to the sub's report header, just below the sub's title. Then, used the 'Add Existing Fields' tool, to place the matching header data fields to...

Yep, that was what you said. I understand. I'll give it a try, today. Thanks for your response.

didn't fully understand 'arnelgo's reply. However, I'll try tomorrow. I just came from an eye exam and my eyes are still dialated. Can't focus.

The two 'show' items were already enabled. Thanks for drawing my attention to their existence helping me learn some more about this great program.

I have a report that displays correctly. as a single report. When I use the subreport wizard or drag the 'good' report onto the body of the main report, all fields display correctly, except the column header for the subreport is missing. Here is where the wizard placed the subreport...

When I used the query to display the records for a main report before I added the sub-report the records were displayed correctly. Before I continue, though, my main concern is still whether or not I am formatting the subreport in the proper places on the report in the design mode.

Having a lot of trouble designing a report with a subreport. First Issue: Initially, i want to know if I am formatting it correctly. Here is what I have: Report Header - - Holds the main report title; Page Header - - - The control header column names for the main report; =========== Detail - -...

Access 2007: I have a form with a combobox that is configured as value list. I want to pick a trip number (ie., D_TN) from the list, like trips 1 thru 10, and open a report. I, also, have a query that contains the leg numbers for each trip, like: 3.01, 3.02, . . . . 3.05., which are all under...

The db is for truckers to use to keep track of the travel records. I wanted them to have, at hand, a control to enable them to call-up some instructions, when they aren't sure what to do. I have several of these 'help buttons' on the form for them to use. That's why I want to be able to hide...

I have a memo that I want a user to be able to 'show/hide', when a user opens it again to enter a new record's data or to view the memo for all older forms containing data. I can show & hide the memo using a control on the form to toggle the 'visibe' property with vba. Not knowing any...

FYI Pat, I created a report where the 'Date' column was in the middle of the report and was able, in design view, to highlight it an move it to the left hand side of the report using the left arrow key on my keyboard. Is that what you said that I could achieve? Maybe I am not understanding all...

I guess that I wasn't clear. I understand what you said about 'headings'. What I need is, let's say for the column headings that are created be a the top of one report and, below it, another set of column headings for the bottom report. Then, the actual report's data fields will appear under...

Google didn't have anything on this. So, I'm here asking the forum this question: Can an Access 2007 db report have two headers on the same page? My customer has asked me to create a single page report with two separate headers: one with 6 columns of trucking trip travel data & one with the...

Holy Cow, I didn't expect that. I peeked at Plog's approach, earlier. I guess I should have paid more attention to it. Another case of my being in a hurry. Allow that, I'm 83.5 years old and still trying to be useful or win the lottery, which ever comes first. Again, thanks for all that...

After printing & reading you last response, I saw that I DO need to use two tables. I was too hasty saying what I did in my previous response. Now, I will get to work. Many thanks.

Ok MajP, I'll work on writing the code and creating the query to do what you suggested. I'll forget about using two tables that I mentioned in my previous response. Thanks for tolerating my snarkyness. I can blame it on banging my head against the wall for about two weeks trying different...

Hello MajP, I think I'd be better using two tables; one where I enter the numbers the lotter draws and one that contains the numbers that I play, which are always the same set of numbers. However, I still need the matching number count routine code approach to use.

I understand. You are right. I wasn't clear. All numbers that I play are manually entered in individual fields on my form (frmPlay). The control sources for these fields are: 'PlayNum1 through PlayNum5' & all numbers the lottery draws are: 'WinNum1 thru WinNum5'. The entered numbers are...