Search results

Problem solved! I had Modal set to yes for the form where the user selects the parameter value, I have taken this off and instead set the popup value to yes. Now the report opens on top. Thanks for all your help Niyx

Hi Rich I don't want to do that because I always want my switchboard to be visible and i want to close the form where the user selects the parameter values once they have clicked on ok to run the report. Niyx

Adam thanks for all the comments, I may be, I am unfamiliar with "got focus". how do you use it to put the focus on a report? The switchboard is a form I have created, i have set the modal and popup values to false. The report opens fine (doesn't ask for parameter values again) if I don't...

Hello all Once again I've been trawling the web for a solution to this without success. I have a form (dialog box) that opens a report using the code Private Sub cmdOK_Click() DoCmd.OpenReport strReportName, acViewPreview DoCmd.Close acForm, "frmYearSelector" End Sub the problem I have is...

Thanks Everyone for you help Problem is solved now, I removed the spaces from the table name and it now works. thanks bunches Niyx

Thanks for your suggestion Gemma, but i still get the same error message

Hello all I have tried searching for a solution to my problem but still can't figure it out. I have a form with a combo box on called Type which is linked to the field Type in a table called tbCommunications, the Type field in the tbCommunications table is a lookup field which gets its list...

Sorry Please ignor previous post I realised it wasn't working as i was not linking the date field from the query to the date field in the main table

Thanks Neileg thats what i thought i needed to do but i can't seem to get it to work, maybe you could summarise how to do this?

Hello all I'm sure the answer is on here somewhere but trying to find it and then getting it to work is a bit of a problem, so i resorted to posting. I have 5 tables Partnership Details, Invoices, Funding, Communication, Communication Types. the field Partnership Name in the Partnership...