Search results

Just wanted to say thank you for the sample, looks very good and was just what i was looking for!!

Sorry just a quick question now this seems to work :D is there anyway to turn off the page header of the main form for when i have my subform appearing...or am i being too ambitious now ;)

No even worse.....and feel free to laugh...there was no data in the report anyway (slaps himself) works like a treat now :D thank you so much KenHiggs!!!

Ahhhh...hang on, i may have been a muppet (more than likely) thought i had to set the links for the data to filter through....let me try with it being blank lol

Well i added the subreport to the end of the first report and unfortunately it didn't return any data even though i've set the link properties etc.

Didn't work lol, oh well i'll just stick with my five seperate reports :eek: lol Thanks for the advice KenHigg!! Matt

Hmmm i'll look into it but i think i may have tried that before, and as the first report creates alot of data and the format of this report is quite important i'm not sure if this works. I'll have a crack at it now and let you know. Is there no way just to simple add the second report onto the...

Does anyone know if theres a way to append two access reports (each based on different queries) one on to the end of the other to make one report. For instance would: DoCmd.OpenReport Report1name & Report2name, acPreview, , Filterifany If tweaked be the right way to go? Cheers, Matt

On my form i have a list which takes information from a table. I have set column headers to "on". What i want to do is populate my combo box with the column heads in my list box. Anyone have any ideas? Cheers, Matt

Thanks RuralGuy! I've decided to use a generic query and then use the WHERE method. Works like a dream!! Thanks again

Thanks for the replies!! I'm using Access 2003 but using a 2000 database. Basically any code has to go into the open event of the actual report? If i already have a criteria in the query that the report is based on will this effect this? Or is it best to start with a blank query and then use...

I'm looking to change the record source of a report and then print the report depending on what button the user clicks on. Is there some way to do this?

Its a numerical field

Does an error message pop up?

I have two forms, a main form frmProperty and a secondary form "Training Details" you access the training details via a button on the frmProperty form. This is the code for the button. Private Sub Trainingbtn_Click() On Error GoTo Err_Trainingbtn_Click Dim stDocName As String Dim...

llkhoutx thank you :) i know it already has caused problems lol i've stopped using spaces now though lol Still a little confused though. I have a query on which a report is based, however you can access the report from two different places. The Criteria above will only work from one location...

Ok i'm very new at SQL and i have a bit of a problem. Ok for instance in my query i have: [Forms]![INPUT PAGE MGT]![PropertyCode] in my criteria box. This works fantastically however is there a way to change what is written in the criteria box using VB code in a form?

Ok have fixed this by basing the tblTraining on a query and using [Forms]![Property]![PropertyCode] in the "property code" criteria of tblTraining :)

Ok sorry to be a pain :D I have a main form frmProperty from where you can go via a button to frmTraining and these two are linked by "Property Code". On frmTraining i have an unbound combobox which gets it data from the tblTraining table. I want this to only display data for the "Property...

Thank you very much for the quick reply, working like a dream now :)