Recent content by Waxmann

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...