Search results

A2003 on WinXP I have 2 columns in a combo box called cbxAddSalesman. The first column is bound, so in VBA I can use that value like this: s=cbxAddSalesman ' Give me bound column. How do I get the second column of cbxAddSalesman in VBA? Thanks. p.s. The source data for the combo box is an...

I found the answer. http://j-walk.com/ss/excel/usertips/tip042.htm

I might receive an Excel file from a customer with 15 tabs in it. I want to set up my page settings on the first tab, and copy those Page Settings (margins, header, footer, everything) to all tabs. Is there VBA or a macro to do this? Thanks.

No, I did not close nor compact the db after deleting the relationships by hand. Could there be an SQL statement supported by Access, that deletes all Access relationships?

The relationships really don't matter, as I only run SQL code in this app and define my relationships via SQL. Well, I deleted all the relationships by hand, then tried to run my code again, and got the same error: The table cannot be deleted because it's in a relationship. Weird.

A2003 on Win XP Goal: Copy fresh data from production DB to my test DB. Code is in test DB. Steps: - Delete table "oldTable1". - Rename "Table1" to "oldTable1" - Import "Table1" from production DB to test DB. When I try to delete "oldTable1" I get an error about "oldTable1" being in a...

A2003 on Win XP I want to run an update query when the user closes a form. Which event would I put that in? Close? Deactivate? Unload? Something else? Thanks.

This is how Access is supposed to work. It runs the query (and asks the 3 questions) when the report is previewed, and runs the query again (and asks the 3 questions) when the report is printed. The query is rerun when printing in order to get the most recent data from the database.

Always, always, always, rename ALL controls with a special prefix. It will save you a lot of headaches. Here are the prefixes I use: labels = "lbl" text box = "txt" subreports/subforms = "subr" or "subf" list box = "lst" combo box = "cbx" command button = "cmd" Some people use different...

I usually have an edit screen where the user can edit one record. On this screen I have many buttons, Add, Delete and Print Screen (prints current record only). If a print screen will fit on one piece of paper, I do make a command button with this code (code from Access macro wizard): dim...

This is what I have in my Report_Activate event: Private Sub Report_Activate() Dim s As String Dim procname As String Dim i As Integer On Error GoTo MyError procname = "Report_Activate" s = InputBox("Enter quantity in box", "Quantity override", Me!QTY) s = Nz(s) If (Len(s) = 0) Then s =...

Isn't there a way to do this at the query level? Like, I enter a prompt string in the query somewhere, and when the query runs, it asks me for a value. I remember doing this many years ago but don't remember how. EDIT: a parameter query is where you enter a value in the criteria area. The...

A2003 on Winxp On a form a user enters a job number, then clicks a button to display a report in preview mode. This report prints a simple label with 3 fields. This report is based on a query, where the key field is taken from the form. One field on the report contains the quantity. The qty...

Problem solved. Go to Control Panel, printer, right click, choose printer Properties, go to "Printer Settings" tab, I could check "Always use driver settings" and this worked.

I see this is an old thread. But my LP2844 driver v2.6.42 for Windows now has, under Printing Preferences, "Rotate 180 degrees" checkbox. That should solve your problem.

Access 2003 on WinXP Zebra LP2844 barcode printer using "LP2844" driver (not -Z driver). Using yellow paper 4x6 self-stick labels. First I designed my label as an Access report and it prints fine, barcodes and all, on 8.5x11 paper. EDIT: I got the report preview the right size by specifying a...

Got it. Thanks.

The problem was I was not supposed to use an alias in a HAVING clause. I'm still learning these aggregate "gotchas". Thanks for the help.

A2003 on Winxp While I am researching some of the problems I have posted in this forum about aggregate functions in SQL queries, I am noticing something. In regular SQL, it seems you do not need every field in the SELECT clause also go in the GROUPBY clause, but in Access, every field in the...

GetFirst gets the first value in a list separated by commas. Public Function GetFirst(src As Variant, delim As String) As String ' Get first string from "src" delimited by "delim". ' Ex: src="1234,5544" delim=",", this returns "1234" ' LOG ' 12-27-10 If src is empty, just return src. Dim s As...