Search results

Once again ... went through your post step by step. Deleted everything except my main table and other forms. Created all new query, report and form, renamed the criteria in the query to that of form name combo name etc. And still when i type the parameters manuall i get the required info...

Option Compare Database Private Sub Prvreportbutton_Click() On Error GoTo Err_Prvreportbutton_Click Dim stDocName As String stDocName = "rpt2009/2010" DoCmd.OpenReport stDocName, acPreview Exit_Prvreportbutton_Click: Exit Sub Err_Prvreportbutton_Click: MsgBox Err.Description...

Went through all the steps in your post ... everything looks as it should be. Reports are fine when manually entered into the parameter box but still blank report when using the report button.

Thanks for that .. yeah the data is the same with a / rather than - (that rhymes):) When creating the drop down menu, i manually typed the values i wanted to appear rather than lookup the values in a table ... if i did the latter then it created a huge menu with lots of spaces as not all the...

Ok so i have created a query .... and a report based on that query. When i click on the Report file or the Query file i get the little box asking for the correct parameters ... i then manually type 2009/2010 or 2010/2011 etc and the query or report comes up with the required data. However...

Hi all, I am pretty new to access but have managed to scramble together a table and form for the information i use. My table has a field for 'next visit due' where the entries would be 2009/2010 .. 2010/2011 etc. I can create a form with command button but would like some help with generating...