Search results

Not that I like Shuey that much, he rammed Damon off and had countless other controversial incidents throughout his career. Although, his last season I did want him to win. Drove that quick at Brazil, it was unreal. You can never rule him out, Brawn will fix the problems with the car...

Noticed I put tt3 in the sql string, sorry should have been tt2. Anyway, You could just alter the part that reads tt1 = Me.txt1.Value tt2 = Me.txt2.Value so it reads tt1 = Me.txt1.Value & " " & Me.txt2.Value which would combine the date & time fields Alter the sql string to remove...

Found a way of doing it. If anybody reads this an wants to know. Create groups on the main report and then put each subreport in the individual group footer of each group. Works, but don't know if there is any other way, or if its the correct way.

Something like this as code on the click event of a command button. In this example I have used two fields in the table, a date field and a time field. Don’t think its worth combining them if you want to separate them again when people view it. This will pick up the value of control txt1 and put...

I have several reports setup as individual A4 sheets that I need combining into one single report, all using different sources for their data. I have tried sub reports but the vertical positioning is a problem as each sub report starts slightly further down the report page. Any fixes for...

I figured out a way to do this, thanks for responding. Although I do have another issue with the formatting not liking the numbers I enter in results. The rule I have set formats if results > than expr1 which works. so lets say results = 7 expr1 = 6 field should be filled red, which it is...

Will he be the 2010 champion? I say yes.

Nothing is supposed to happen when the expr is "". The db lists tests so for each test type you get a results. The expr field lists the upper limit for the test, when the result is above i want it to fill red. The expr field can have "" as a value because the underlying query uses many IIF...

Could you recreate the problem and post the database.

If the query has 120 records then your report will be reporting on 120 records. What is the Force New Page setting on the details section?

I have a field called results that I want to format to fill red. It currently checks the value of expr1 field and if greater than this value formats. [results]>[expr1] expr1 picks data up in the query, an iif statement, so expr1 can sometimes have a "" value. My problem is that I also need...

Thanks HiTechCoach I removed the lookups and the code inserts the values.

If I understand this correctly (apologies if I haven't), you have 1 query with 7 expressions calculating the 7 dues dates and you want a report as a single list to list them in date order. You could create 7 individual queries, identical except for the due date expression. Then create an 8th...

Completely lost on this. I have some code that inserts values into a table, some appear whilst others do not. The code functions correctly, picks up variables and executes. The data that doesn't appear is for fields that have lookup lists to other tables. If I open the table I can select...

Spot on cheers.

Is it possible to sort columns horizontally? i.e. you have 6 columns with 1,2,3,4,5 & 6 as a header number but they are not in sequential order.

Not a sort as you know it. Is i possoble to have six columns each with a random number between 1 & 6 as the header and then move these columns so the headers are in order?

Its a large report that has several tables (figures that is) of summary data. Its currently in word, some of the figures are in landscape some are in portrait. Not sure moving the controls will give me the correct format. Hear what you suggest but thats just going to put everything in a...

I don't even know if this is possible, can you get one report with say half of its layout in portrait and the other in landscape?? I was think sub forms but that I think takes on whatever setting the main containing report has. Is there any VBA tricks? Another way would be to run 2 reports...

Can you upload a screen shot of what it currently looks like, i am struggling to understand what you mean.