Search results

Don't think so. Now the form is working as expected. I inserted me.refresh, me.requery in a bunch of places. I think I fixed it but don't know how!!

I have a frmScan that has 2 fields. One is a txt.description - control source is tblPrtChoice.Description The second is me.txtscan and is looking for operator input that triggers a qry to run and print a label (quick screen says printing) then returns to the frmScan. The problem is that when it...

Where do I add; Option Compare Database Option Explicit And can you expand on why I need it?

Thanks for the help, It now works!

I have a table called tblConfig. I need to make this function (Public Function ExportBatch()) to make a decision based on whether the tblConfig.UseServer is true or false. If True it should run Export-FORM. if False it should run Export-FORMServer. I'm new and not sure what I'm doing wrong...

Dim mChoice As String mChoice = lstReports MsgBox mChoice ''DoCmd.OpenReport "mChoice", acViewNormal DoCmd.OpenQuery "qryPrtChoice", acViewNormal Thanks, that was it. Really appreciate your help.

That looks GOOD!! Thanks, I'll let you know

Thanks, I should have used report instead of template, as template is really it's purpose, not its name. :) But what I really need is a way to select the report to be set as a default, to be used later on when printing from other forms. Thanks for your response!

How do I get the report named in PrinterChoice.Exp1 to print see DoCmd.OpenReport "StrMyLab", acViewNormal below? Private Sub cmdPrtLab_Click() Dim StrMyLab As String StrMyLab = "PrinterChoice.Expr1" DoCmd.SetWarnings False DoCmd.OpenQuery "qryUpdateMenuItemPrice", acNormal DoCmd.OpenQuery...

Currently I have it hard coded, but it will change depending on the label stock size., so yeah I'm thinking a table. I do compile. What do I change to get it to open the report in a tbl? If Me.txtScan.Value = DLookup("PLU", "dbo_Menuitem", "PLU=" & """" & Me.txtScan.Value & """") Then...

I wrote an app that scans a barcode and prints to a label printer. In the beginning, I want to choose which label template/report I want to use from tblReports and set the choice as default until changed by user. The choice takes place in a frmSetConfig a list box named lstReports that shows...

OK, first - not on a domain - Simple peer to peer. Second, the issue occurs on the computer with the SQL db. Not checking 'Use secure... 'causes the error. On the other client computer, Not checking 'Use secure... ' allows the connection. There is a screen that will allow Access to save the...

Fails on first query

Yes, I'm also using the same ODBC driver (WIN - Admin - ODBC Data Sources) The only thing changing is the application version. One uses the checkbox, one doesn't

I have an Access 2007 application that uses the SQL ODBC driver. When setting up the connection to the sql db, there is a check box that says 'Use trusted connection'. If I check that box, package the application, and run on a new (different) WIN10 computer it will not allow the applications...

Please understand that this will be exported to a | delimited file and then submitted to a clearing house. This is the format they require.

There should be a lineItem# (Not copied in the example) . He purchased 2 packs of cigarettes and they were each scanned. Causing 2 lines on the invoice

? What are you looking at?

This is a rebate program. They only give a rebate for 2 purchased at the same time (Buy2 save .50) Know anyone who could write that code? - For a price? :)

I'm looking for a query to look at the invoiceNo and when it finds two that are =, look at the plu's. If they are = then delete one row and increase the Qty to 2. If there are 3 that are =, just count the first 2 and leave the third row alone. If there are 4 that are = then delete three rows...