Search results

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.

How can I control my form so that the data entered into a field cannot begin with a number 0?

problem The problem with that is that unless everyone logged in to the database is using that particular form they will not see the message. There are many forms in my database so it needs to be a broadcast type message.

Does anyone know how i can send a message to all people logged on to the database. The database is currently hosted on a network drive and all users access it from there with a standard password for everyone to gain access to it. Cheers all.

I have a form and I want to be able to click a command button that will paste the information to another form. How can i do this? I have yet to create the form which requires the text to be pasted into.

I have a form based on a query that shows records stored in it. I want to make a link on the form so that when the link is clicked it takes you to the specific record in the original form. I have managed to do this on other forms by creating a command button that opens the required form, but...