Search results

Image Population Thanks for the response Wayne, I am not sure what you mean. I mean, I understand what an Event is, but how would you use it? I could check to see if the file copied to the server, and loop this until it exists at the destination I guess. What exactly do you mean? Rube

We have a database that populates an ImageBox. The problem is, if the user jumps back and forth between images, the program will eventually just close even with Error Handling (though I must not be using correct EH). Is there a code that could force a delay before allowing another selection...

Does anyone know the coding for the MSCommon Dialog Box? I would prefer this over the accmdprint. I just cannot find any coding in any reference or on the web. I want to print a Report.

Print Dialog Thanks for looking. The cdlPrint, is the name of my Microsoft Print Dialog Control. It actually should be dlgPrint (for dialog) I believe is the convention they use. I still would prefer to use this over the acCmdPrint, but I can still find no code covering the use. I found the...

Print Dialob I found the code. Private Sub cmdPrintTest_Click() On Error GoTo ErrorTrap DoCmd.SelectObject acReport, "reportprinttest", True DoCmd.RunCommand acCmdPrint ErrorTrap: If Err.Number = 2501 Then Exit Sub Else MsgBox Err.Description End If...

Thanks for the input. I understand both of the emails you sent, if I built the Print Dialog Box, I could put a condition to whether the Report is called to print or not. The problem is, I inserted a Microsoft ActiveX control a Common dialog Box named dlgPrinter. To show this, I use the...

Print Dialog The problem with the cancel is, how do I call it and keep my Report from printing out? cmdPrint_Click dglPrint.ShowPrinter DoCmd.OpenReport stDocName, acNormal exit sub assuming I have Error Handling in here, this will bring up the Print Dialog Box, and wait for the user to...

How do you use the Print Dialog Box with a Report? I do not want to put the code in the report itself. I added a Common Dialog Box, and it works, except if the user hits cancel, it then prints anyway. I have about 8 good Access Books but they do not discuss the Print Dialog Box except in...

Worked like a Champ, thanks.

Rename Calvin, May I ask you a question along these lines? I have an office that needs to print out Printed Job Reports. I wrote a database that will import the data, and put it in a usable format where totals, dates, jobs, etc. will print out. The problem is the Printer Software exports the...

How do you use the Print Dialog Box with a Report? I do not want to put the code in the report itself. I added a Common Dialog Box, and it works, except if the user hits cancel, it then prints anyway. I have about 8 good Access Books but they do not discuss the Print Dialog Box except in...

Thanks Jack. You are awesome, worked like a champ. I think I had stared at it so long I wasn't thinking straight. Chris.

I have a multiple category query. Each field is assigned criteria from a Function. The five criteria from the Query Form, are not all required, so if they are marked "Not Selected", I want to accept all records for that field. In the query I have ProductCategory1() In the module, Function...

Do you have any restrictions either in code, on a control or form. i.e. AllowEdits or AllowAdditions=False And do you remember any changes you made right before this started happening? It is easy to make one change for an action, that then prohibits a previously working action. Final...

BeforeUpdate Thanks for the Reply. I am not sure if this is what you meant, or there was an easier way of doing it. I certainly appreciate your time. Public Function RequiredFlag() If IsNull(Me.ItemDescription) Then MsgBox "Item Description Required", _ vbCritical, _...

I have two controls that I need Required. I have tried using the BeforeUpdate event to check for Null values. Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.ItemDescription) Then MsgBox "You Must Enter an Item Description", vbCritical, _ "Canceling...