Recent content by singingshiver

Here is my db file is too big

Still not working I have tried all the suggestions and it still isnt working. What do you mean by trying debug.print stlinkcriteria ?? I am new to all of this. Many thanks for your help.

changed it to what you said and it came back with an error message saying that there was a datatype mismatch

Thanks again for the post. Here is the code I have written: Private Sub Command172_Click() On Error GoTo Err_Command172_Click Dim stDocName As String Dim stLinkCriteria stDocName = "TEST" stLinkCriteria = "[SFI Reference]=" & Me.Text58 DoCmd.OpenReport stDocName...

Thanks for the reply. I have read the other topics but none of them seem tailored to what I need, and the ones that are similar fail to work. Sorry to ask a question that is frequently on this board, but I need an answer.

I have a form and wish to create a button that will print a report based on this form reference. How do I do this?

Let Me Expand This is what I am trying to do: I have created various forms based on various queries to count the amount of records in each query. So effectively I have forms with a text box that simply displays a numeric value for the amount of records in the query it is linked to. With...

That won't work The queries I have are linked to forms that create totals. Then it is these multiple forms that need to be represented in a report.

I want to create a report based on values in multiple forms. How do i do this?

WORKS IT WORKS!!! I re-created the query and form and now it works. Thanks very much everyone.

Didn't work Thanks for the reply. I tried what you suggested but it didnt work: "=Count(*)". Any other suggestions?

I have created a query based on my form to show only my records that are in a "monitoring" state. How can I get a total displayed for the number of records it shows? I have a form based on this query and ultimately I want the total displayed in a report I have already created. Any help would be...

I require my database to identify when the same data in 3 fields has been entered 5 times, ie when field a field b and field c have the same information in them as entered in an older record it will count them and display that value for viewing.

Much obliged it worked a treat

I require my database to identify when the same data in 3 fields has been entered 5 times, ie when field a field b and field c have the same information in them as entered in an older record it will count them and display that value for viewing.