Search results for query: *

I have a listbox on a form that is used for my own search. The user types in information they are looking for and a list of Invoices shows up in the list box. The listbox is bound to a query that pulls multiple fields from a table (ie. Firstname, Lastname, Invoice Number, etc). One of these...

Access allows a quick and easy way of counting the number of pages on a report. You can place this code in the control source of a text box that is in either the "Page Header" or "Page Footer" = [cableNumber] & " (contd. SH " & [Page] & " of " & [Pages] & ")" Where [cableNumber] is the...

Thanks, I didn't realize I could check the status of control properties so easily. Worked like a charm. Tom

Richard, I do this a lot in the program I am working on now. I use openArgs to pass a value from my txtID field to the popup form. DoCmd.OpenForm "frmPopup", OpenArgs:=Me.txtID.Value Then in the popup forms onOpen I use Me.txtID.Value = Me.OpenArgs and then I set the Me.RecordSource =...

I have code on a few of my forms that adds the date to the text in the textBox control that has the focus when a specific key combination is pressed. The problem I have is when a textBox that is locked has the focus. When the key combination is pressed a run-time error occurs saying the property...

A possibility that I have used before is to make a command button on the form. Give it no graphic and no action. Set its "Transparent" option to "Yes" and then give it the focus in formOpen using Me.cmdHidden.SetFocus where cmdHidden is the transparent command button you made Tom

I have a set of three tables that I am using to print out a report, they are: tblContact ---------- ContactID . . tblInvoice ---------- Invoice ID ContactID . . tblParts -------- PartID InvoiceID PartName . . There is a one-to-many relationship between tblContact and tblInvoice with there...

I am writing a program for a repair company and there is a memo field on one of the forms where the diagnosis for the repair is listed. These are often very long and involved which is why a memo is needeed, but they consistently have generic short messages such as "Check and Adjust." I would...

mndrlion, that worked perfectly! Thank you.

I have a textbox on a form that I would like to contain the total sum of the price of parts for an individual client. The textbox should only contain the values for the prices of the parts for the current individual only. I have no problems obtaining this information through the following query...