Recent content by realstandman

Bada Bing!!! Have a star!!! Don't think and the solution will come.

IIf([Forms]![frmQA_Report_Interface]![Producttype]="All Medical","HCFA" And "UB",[Forms]![frmQA_Report_Interface]![Producttype]) This is the one piece not working. Everything else works fine if I take this out. Don't think and the solution will come.

There are alot of references to the interface form for criteria. Here is the whole SQL. SELECT AUDIT.Audit_Number, GROUPS.Group_Name, AUDIT.Audit_Type, AUDIT.Audit_Product, AUDIT.Claim_Number, AUDIT.Claim_Amt_Paid, AUDIT.Claim_Should_Have_Paid, Int([lines_audited]) AS [Lines Audited]...

I have a query that I'm using the criteria to pull from a form. If the form = "All Medical" then I need it to use 2 of the value list for criteria. Here is what I have. It gives me the expression is too complex error. IIf([Forms]![frmQA_Report_Interface]![Producttype]="All Medical","HCFA"...

anyone know where I can find the old Great Plains DOS version? I have the data but can't find the installion disks from way back. This was at my company and discontinued now they need some data out of if. Don't think and the solution will come.

Anyone know where I can download the old DOS Installation? I have some old GP DOS Data that I need to get into... Don't think and the solution will come.

What are you using for your Primary keys? Don't think and the solution will come.

Make sure you have primary keys set on your tables. If not it will not update. Don't think and the solution will come.

You can go to the properties of the combo box and have the number column be the bound column and you can specify the widths of the other colums. That will expand them when you use the drop down. Don't think and the solution will come.

I have datasheet form that has a datasheet subform. When I click the "+" on the subform to view the record I want to see the current record remains on the first record. Sorry if this sounds confusing. Here is an example. If you select the + on the 3 record the ">" cureent record remains on...

I have found the solution. I have code behind a button that sets certain perameters based on the dates for a month range it sets different perameters and then set them back to default after the report is ran FROM the Button. When you print the report it doesn't set those perameters therfore...

I have an access 2000 database used for reporting claim production and inventory. On my main report, which is a report with about 7 subreports on it, I can run the report for a weeks range and the report in print preview and printed are the same. I run the same report for a months period and...

I found a work around that worked out. Here is the code. On Error GoTo exit_Command31 If Me.sbfSubmissions.Form.SubID = "" Then MsgBox "test" Else DoCmd.OpenForm "frmRein_SubmissionEDIT", acNormal, , "subid=" & Me.sbfSubmissions.Form.SubID, acFormEdit, acWindowNormal...

I am trying to an onclick event that would give the message below if there are no records. The error message is Runtime 2427 You entered an expression that has no value. Which is true and thats what I'm trying to do with the message box so they know to generate a Submission prior to editing...

Drilled it down. Its not my pc sending the lockouts its one of the network servers doing this. Any suggestions as to why a network server would lock out an account. We checked all of the services and none are under my login profile. Any suggestion would be cool... Don't think and the...