Recent content by linskill

Possibly, same database, different subject. Mod's would you please move it to the existing thread if you think its appropriate.

Hi Chaps, I am using a the below code to print off reports - is there anyway to combine these reports into one pdf file? Private Sub Command22_Click() On Error GoTo ErrProc DoCmd.OpenReport "FinancialReport", acViewPreview, , "AppointmentT.ApptID=" & ApptID DoCmd.OutputTo acOutputReport...

Opps, sorry Pat :)

You sir are an absolute genius, thank you very much that was exactly what i needed.

Hi All, I am trying to print a set of reports using one button. Everything works fine as long as all the reports are not blank. Unfortunately not all of the forms are used in all cases and it all comes crashing down when no ApptID is found. I have tried the "On No Data" but that just stops the...

Sorry, probably did not make my question clear. I am working on a printed report which consists of 8 sections each containing around 50 fields. My boss would like the all of the answered fields included, which if left as a single column will need more than one A4 page for each section. To keep...

Hi Chaps, I am trying to condense a report by using multiple columns. The shrink option is not helpful when using multiple columns. Is there any other way of hiding unused fields?

Thanks, It is looking like two forms is the way forward.

Its been over 10 years since I last used Access. My employer has enticed me into getting back in the saddle and I must admit I am enjoying myself even if my memory keeps reminding me that I am getting old... What is the best way of ensuring a user selects a customer before they attempt to open...

I've sorted it, seems my problem was trying to update directly to the table, adding a few hidden text fields to the form worked a treat. Thanks for your patience and all your input.

I agree it is not normal, its actually a fudge repair of my short sightedness when I originally created this database, I wish to use the trials table via MySQL on my website. As I am a bit more familiar with Access then PHP I felt the easiest way to do this was to repeat a small amount of...

I think we are in danger of going off topic here, The full version of the db has many more tables with referential integrity in place where needed. This is what I am trying to do but I can't seem to get the syntax correct. Private Sub StakeCombo_AfterUpdate() If StakeID = 2 Then trialst.TD =...

I have attached a stripped down version of the database, as i said earlier I am trying to use an after update event on the stakecombo to populate the relevant field in the trialsT table, Thanks for looking

Thanks for the quick reply, I have a form bound to the trials table, within that form is a subform bound to the judges table. In that subform is a combobox that is getting its values from a lookup table(Stakes). I need to take the stakeid from the combo box and store it into the Judges table (so...

I am trying to use a VB IF THEN statement to update a field in another table based on the column value of a combo box. i.e. If stakeid =1 THEN tblTrials[table] ud[field = combobox.column3 WHERE trialsIID=" & trialsID Can anyone help me out with the correct syntax, I cant seem to get it...