Search results

That's more or less right. When I click the record I have code that changes that record to a new one. After it is finished changing I want it to update but I dont want to requery the entire form because it will move me back to the first record. I can requery the column with Me.Status.Requery but...

Is it possible to requery a single record? I have a datasheet on which I have records that can be clicked and when clicked i want them to change. The change part is easy but I dont want to requery the entire form because it will reset my view not to mention being unnecessary. I can do it with...

Ok, this looks like a good start. Thanks! Any ideas on how to get it to change the font size until it fits to one page, and thats not just for decreasing it would be nice if it increased the font size the same way.

What i want to do is change the font size of a text box that is in a sub report UNTIL the report is 1 page. Here is the code i have for finding the page number Dim intTotalPages As Integer Dim strMsg As String intTotalPages = Me.[Pages] strMsg = "This report contains " & intTotalPages & "...

Figured it out: Dim intTotalPages As Integer Dim strMsg As String intTotalPages = Me.[Pages] strMsg = "This report contains " & intTotalPages & " pages." If intTotalPages > 1 Then MsgBox strMsg End If

Is there not some way to get the value from the text box on the report that gives the page number? OR If there is a way to tell it to move to the next page on the open event then if it gives an error "resume next" and it's ok to open or if there isnt then close the report.

Yes, this is true but some of the records are longer/larger than others and since it is set to allow the records to grow/wrap this method would end up being fairly inacurate. I probably should have stated that earlier but there it is now... Thx for the try though :) Any other ideas would be...

Is there any way to count the number of pages in a report in VBA? All i want to do is keep the user from printing the report if it is more than 1 page.

Ok, any suggestions on where to start with that? This is only happening on this one machine. I checked the Microsoft Office Language Settings and they are set for English and Spanish.

I have a datasheet that contains work order numbers that i have set up so that when the user clicks one a word file is created using the "template", the information is entered and the files is saved. The last part is the problem. When i click on the number to create the file i get this error...