Recent content by sphere_monk

Awesome. Thanks Informer. I was able to get a workaround going with the printer statement you gave me. Here's the new code: Private Sub cmdPrintToDifferent_Click() On Error Resume Next Dim varReportName As String varReportName = txtReportName.Value DoCmd.OpenReport varReportName...

Hi all, I'm running a pop-up form that allows the user to select a printer when a report has to be run. There is a specific report that is designed to be printed in landscape mode in the report itself. When the user prints the report using the "Print to Current Printer" button, the code...

Thanks for your response... This is all the code behind the forms that are causing the error.... Form 1: Option Compare Database Private Sub cmdClose_Click() On Error GoTo Err_cmdClose_Click DoCmd.Close Exit_cmdClose_Click: Exit Sub Err_cmdClose_Click: MsgBox Err.Description...

Hi, I'm developing in Access 2007. My backend databases reside on SQL Server 2005. When I copy and try to run my frontend design database as the production frontend database on a computer with Access 2010 installed, I get the error "An error Occurred while loading '<name of form>'. Do you...

Thanks spikepl, that worked perfectly! I changed the ControlSource of the grand total field on the parent to =IIf(Not...

Hi Bob, Thanks for your reply! I pasted your code into the field and it is still behaving in exactly the same manner. I keep forgetting about the NZ function, it's a lot easier than the way I searched for nulls in the previous post. I'm thinking the error is because the form that does not...

Hi everyone, I've got a grand total field on a parent form that adds the value of two summary fields that are located on subforms of the parent, each one on a different subform. These subforms are looking up transactions from different tables. One subform DOES allow edits, additions and...

Hi Bob, thanks for the response. Yes, the user's computers have all been set up with trusted locations of all the front-end and back-end databases. Each user accesses multiple front-end and back-end databases. This form problem spans all the databases. The databases are quite large and have...

Hi everyone, We've been experiencing some strange behavior with some of our forms for the last few months and I am at a loss to explain or resolve it. Certain forms work fine on the development machine, but as soon as the front-end of the database is copied onto other computers, the forms will...

Assuming you have a form with the client info and a subform (multiple record) listing passengers, you could place a command button on the detail line of the subform (it would show multiple times, once for each passenger). When the user clicks the command button, fire off a query that uses the...

:D The problem has been fixed! We switched out every piece of hardware we had between a regularly-offending client and the server, all to no avail. Everything we did still pointed to it being a communication error. Packet-sniffing software came up with no packets being lost (although many...

That sounds good to me. I'll tell the network guy to buy a new switch and replace the NIC card in the server. I'll also have him change the server ethernet cable in between just to be sure. It'll take a bit to get it scheduled and done........ Thanks!

Hi everyone, Our office has recently been receiving a sporadic series of "Network access was interrupted..." errors in our Access 2007 databases. I've been troubleshooting this problem for approximately 6 months and am at the end of my rope. I was wondering if anyone had any advice. Here are...

Thanks for the code Mutdogus! I checked the code out. Please correct me if I'm wrong, but I don't think the code can tell me if a specific database is loaded. Since the user would be calling the Contact DB from another Access DB (the Billing DB) then wouldn't the code return a value of 'True'...

I'm guessing txt_A2 is on Form_A!SUB_A not on Form_A. If you're binding the second column to cmb_A, which is the ID field, then I'm also assuming you want to put the Name (shown as column 1 in the list) in txt_A2. try putting Forms!Form_A!SUB_A.Form!txt_A2.value =...