Search results

My form requires a user to enter in an RMA number then press a btn which displays the results in a subform with a datasheet view. The RMA may have multiple lines. The user needs to find the correct line based on part number. Once the correct line is chosen the user fills out another form...

Here's a little background - Tables - Cust_Order_Line, RMAFrmTbl, RMADETAILSUB_2 It's an RMA tracking database. The Cust. Service department creates the RMA. Then QA tests the returned product. 1 RMA may have more than 1 line item. QA needs to enter their results from testing for each...

I have a form where the record source is a linked table. The primary key is the Cust_Ord_ID and Line_No. The main form (Enter_RMA) has a subform (Ord_Line). The subform is the form where the data source is a linked table. Right now users fill out the main form and then move onto the...

You are correct, you don't really need the person_id. It looks like the employment_ID is basically the samething as the person_ID. The employment_ID is a unique number so that will be enough.

Well it looks like the way the relationship is setup is what is confusing you. The way you have it works just fine. Your main form is linked to your employment subform by the org_id and the employment subform is related to your person subform by employment_id. So it looks like this - Main...

I think i'm making this more difficult than it is. I have an 2 excel spreadsheets with sales numbers like this - Zip CustomerType Sec Hes Fol 10001 S 0 303.23 0 10002 C -37 3461.39 1531.8 10577 S -71.25 287.56 0 11211 C 0 702.22 0 11803 L 14 365.27 -45 12401 S 0 280.99 0 12524 W...

Is there a way to code a btn to clear a form so the user can add another record? Currently my btn opens another form and takes the CustNum and RMANumber from the form with the btn. So can I have the same btn open a new form and also clear the currently open form so the user can enter another...

It's a btn on a switchboard - Here is the data in the switchboard table - SwitchboardID ItemNumber ItemText Command Argument 1 0 Main Switchboard Default 1 1 Enter RMA Data 2 frm_EnterRMAData 1 2 View RMA Data 2 frm_view This is the code from the switchboard - rivate Sub Form_Open(Cancel...

Yes the default view is set to Datasheet. That's why I don't understand why it's opening in the single form view.

I've got a switchboard which allows users to click a btn and view the data in the MFG_Tbl. I have to form's Default View set to Datasheet, however after the user clicks the btn on the switchboard the form opens in Single Form view. In the form properties I have set all views to No except the...

Awesome, thanks Paul

I have a btn that runs a query based on different checkboxes on my form. A user may want to run the query again based on different checkboxes so I would like to be able to clear the checkboxes after the user clicks the btn and the query is run. Thanks for any help.

Thanks that's exactly what I was looking for. It works perfectly.

I have a form that uses checkboxes to list all the fields in a table. How would I create a query based on that form? For example - Field Names - RMA_Num, Qty, Date_Rec, Part_Num, Desc, CC_Primary, CC_Secondary, CC_Tertiary, OF_Appearance A user may choose to see Qty, Part_num, CC_Primary...

No, only 4 fields are required.

I was looking through previous posts and I found this one - http://www.access-programmers.co.uk/forums/showthread.php?t=94508&highlight=disable+error+message I would like to disable my subform till the main form is filled out. I know how to disable the subform but I'm not sure of the code to...

Do you mean when I right click in the upper left corner and choose properties and then on the data tab choose filter?

My main form has a Customer_ID, Order_Status, Type, and Create_Date and a bunch of other fields that get pulled in based on the customer_ID from a Customer table in a linked database. I have another form that has all the order details - address, shipping info, notes, etc. A 3rd form in...

How do I code a cmdbtn to save the current record and then go to a new blank form? The form opens with all fields being blank except the field for today's date and order_time, which is fine. The user fills out the form and then I would like them to click a btn that will save the record and...

I have a form with the default view being datasheet. It's basically an order form. It's actually a subform linked to the main form by RMA_ID. So the user can enter multiple lines for the order. I need it to keep track of the Line Number. Is there a way to autonumber a field on a form so...