Search results

Mike You can attach a command to the 'Click' property of the radio button that prints a certain report, but... You may want to add a 'print button' and a 'preview button'. The user would then select a report with the radio buttons and then select how it is to display (either print or preview)...

Hi On my 'Invoice' form I have a subform with the line items. The user must select each line item from a combo box called 'StoreNo' If the user selects a 'StoreNo' that has already been used in the Invoice, they get an Access error. I would like to supply my own MsgBox message. I think it...

Nate The printing of forms is troublesome business. Your best bet is to make a Report. Have your print button open the Report and have the Report's control source be tied to a query that looks up the information on your form. HTH Tom

muaddip Did you check the Allow Edits property on the sub form? If this is set to No, it may cause some problems. HTH Tom

Purplehaven You should be able to put this calculation in your Line Total Control Source =[Width]*[Quantity]*[UnitPrice] HTH Tom

William It sounds like you may need to add some fields to your main table, although you kind of lost me there. You mentioned 25 combo boxes in your second paragraph, but only 4 combo boxes in the first paragraph. Please give us a bit more info. Try to explain your combo box situation a bit...

Stephen When I get bogus error messages I try compacting the data base. Tools - Database Utilities - Compact and Repair Database If that fails, you could try installing your Ms Office disc 1, there is a Repair Office option that may help. It takes for ever though. Good luck and hope that helpsTom

Hi When I enter tickets on my Invoice Form, I enter the date and ticket number for each in a new line. Many times I haved numerous tickets for the same date. On my Invoice SubForm I want the date to give me a default value equall to the previous line items date. How do I make this happen? Tom

Thanks. That works great! Tom

Wayne I'm not sure how to administer this code. Could you give me a few more instructions? I'm still learning. Tom

Hi On my Invoice form I have 2 hidden look-up text boxes. 'CPhone' looks up the client's phone number. 'CExt.' looks up the client's extension number. In the client's info section I have a visible text box that uses this control source; ="phone " & [CPhone] & " " & [CExtension] This works...

Hi On my 'Invoice' form I have a text box displaying the 'CustomerID'. Of course this gives me a number in the text box not a name. I want to store the number (CustomerID), but I want to display the 'Customer Name'. Is there some SQL or some other method of having the text box look up the...

Dan You could also set your sub form to Visible=False when your main form opens. Then have your sub form Visible=true when the button is clicked. Tom

Thanks Ricky You are a genius! Tom

Irfan In your code you will have line that looks something like this; Msgbox("Birth Date can't be in the future",vbOKHelp,"Error") The Message Box format is ("message",buttons to add, form "header") After the first comma there may be a number instead of vbOKHelp. Change vbOKHelp or the...

Hello 1. My Invoice has a subform. Set continous forms. 2. Ticket items are added to the subform. 3. One of the items is a ticket number. 4. Ticket numbers are usually in sequence. example: line1 would have ticket number #200 line2 would have ticket number #201 line3 would have ticket number...

Shareen I'm not really sure what you have going on there, but try doing a requery or a refresh command. You can go to your 'Records' menu and select 'Refresh'. If that helps you could also automate the processby adding some code. Me![ComboBoxName].Requery Hope that works! Tom

deadcalm If you are just using your form to view one file at a time, the DLookUp function might work. In your 'LastName' text box in Control Source enter something like this; =DLookUp("[LastName]","[NameOfTableWhereLastNameLives]","Form.[SS#]=[SS#]") The DLookUp will look in the Table under...

PaulA What kind of error messages? What your doing should work. Tom

Stephanie On your subform; In your control source for 'AmountDiscounted' add AmountDiscounted Or you can click into the control source line and a pull down arrow will appear. If you pull down the list it will show the names of the fields in your query. 'AmountDiscounted' should be there. The...