Search results for query: *

Hello, No, the form is set to close once you view the report. Which I now see is the problem. But I need the form to close once you view the report. So how would I make it stick when I print the report ? Thanks for your help

Yes it is a source in a text box The name is Text57 The Control Source is ="Due Date from " & [Forms]![frmSalesSelectorbyDateRange]![BeginningDate] & " to " & [Forms]![frmSalesSelectorbyDateRange]![EndingDate] Thanks

Hello, I have the following on a report: ="Due Date from " & [Forms]![frmSalesSelectorbyDateRange]![BeginningDate] & " to " & [Forms]![frmSalesSelectorbyDateRange]![EndingDate] However when I print the report it just comes up as "#Name?" When I view, save, or print to a PDF the parameter...

IT WORKED ! =abs(Sum([Status2]="On Time")) I thought I tried that already. Apparently not =:-) Thanks guys. You are GREAT help

I am trying to total a status field which is based off a lag time formula which is then turned into a status (Early, on time, late, or pending) I am trying to calculate how many early, on times, lates, and pendings I have for each quarter. This is the formula I am using: =Sum([Status2]="On...

Hello Is there a way to create a PDF of a report through a command button ? If so, does anyone know how I would write the code ? Thanks

I am not sure if this makes a difference or not. But I have the same type of thing in my database and this is how I would write it: Between[Forms]![frmReportSelect]![txtStartDate]And[Forms]![frmReportSelect]![txtEndDate]

Hello I have created a form with a combo box that pulls a report based on the parameter choosen. I have gotten the command button on the form for view and print to work correctly but I can get the one for export to snapshot to work correctly. When it exports it pulls the whole report and it...

Yes the original work before I made the copy and renamed it. I ended up importing everything into a new database. And it works find now. Thanks all for your time and suggestions !

I am really stuck on this one. I made a copy of a form and renamed it. However the copy I made does not show on the database window but does show in the Visual Basic window. Since this happended I have been receiving this error: "Module not found" When I am in the visual basic window to try...

Never Mind..... I just figured it out.

Hello, I have created a form that opens a report based on the parameters I choose in the form. I got the first parameter to work on it's own "Head Office" , but I can't seems to get the date range part to work. FYI - I gives me this error: Syntax error (missing operator)in queary expression...

THANK YOU THAT WORKED !

Hello, I am getting this message in my Access Database: Your Microsoft Office Access datase or project contains a missing or broken reference to the file 'OWC10.DLL' version 1.1. * To ensure that your datatbase or project works properly, you must fix this reference. I can't figure out what...

Thank You Remou !!!!! That worked. And yes I needed to put it on closing the name form. Hats off to ya ! I was racking my brain for over a day on that one.

Hello, I have a mainform: frmLetterApprovalNewCase With a dataview subform: frmApprovalLetterInput_Subform 2 combo boxs in the subform: Sales , Sales2 on the mainform I have a command button that takes me to another form so I can add names to a table which 2 combos are connected to through a...

YIPPEE.....Thanks it works now !

BC Anchor is the name of the combo box that needs to be updated on the form (frmLetterApprovalNewCase)

I am stuck on this error "Object doesn't support this property or method" Here is what I have done so far..... On the click event of the button that opens the name table I added: stDocName = "frmInputBCAnchorName" DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog...

I have created a form with a subform and need it to auto refresh when a new name is added to the list table. The way I have the forms setup is if the sales person is not on the drop down list you link to the name table via a command button and add the name. However once you close the name...