Search results

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...

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...

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?

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 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...

I need to modify my customer table to cater for multiple names at one address. I was hoping that someone could point me in the right direction on how best to do this. Should I move all the addresses into their own separate table or leave them as is (name-Address-postcode- email etc in one...

Hi All, I would like to share an access database with a few users spread all over the country. I have already split the database and ported the tables over to MySQL on my development computer and all is fine. I was hoping to upload the MySQL database to my web host and use an Access fe to...

I have been chasing my arse for over a week on this one, It almost works but not quite. One of the subforms will not refresh when you enter new record and the stake ID combo will not keep its default value all of the time. I am hoping that someone might have time to have a look at this form and...

I am using a query to find records that fall on the following month using the month and year functions. Month(Now())+1 Year(Now())This works fine until we get to December and it all falls down. I know that is due to the year now function but I cant seem to find a way to update it other than do...

I am trying to work out how to get a query to return all records from a date starting the month after next. i.e. query runs late December and returns all values from 1st February onwards. I have tried >=DateAdd("m",2,Date()) but that adds two calendar months and does not return the records...

I have have a form with 4 subforms in it, one of the subforms is based on a filtered query . For a reason I can not work out I cannot get it to requery when I add a new record. To add a new record I select from a combo box and use a command button to save the record I have tried using this in...

Hopefully an easy one, I have a 2 controls on a form which are by default not visible and a command button to toggle them on or off. This seems to work OK as the controls become visible when they are supposed to. For some reason the label on one of the controls will not become visible. It is...

Hi All I am trying to create a user friendly form to enter a list of competitors entering an event. I would like the user to pick from a list of events and that event to be used for subsequent records until the user changes it. I have used a combo box to pick from a list of events but that needs...

Hi All I have been lurking for a while now and this forum has helped me enormously in getting to grips with access. Many thanks to all of you contributors. Normally I can find the answers to any queries I have by searching this forum, in this case I am probably not asking the right question so...