Search results

Hi, I have an order form which uses the tables CustomerT and OrderHeaderT with a subform for the order details. The Order Form has a combo box to select which supplier the order is from and puts the SupplierID (from the SupplierT) nto the OrderHeaderT.Supplier field. This has all been working...

I'm trying to concatenate address lines on a report so that empty lines don't show up. I've searched the forum and found a thread that recommends doing this: =[InvoiceAddr1]+Chr(13) & Chr(10)+[InvoiceAddr2]+Chr(13) & Chr(10)+[InvoiceAddr3]+Chr(13) & Chr(10)+[InvoiceAddr4]+Chr(13) &...

Hi, I have a form NewOrderF which is called as follows:- Private Sub NewOrderBtn_Click() On Error GoTo Error_NewOrderBtn_Click Dim CustomerInputID As Variant CustomerInputID = Me.CustomerID DoCmd.OpenForm "NewOrderF", , , , , , CustomerInputID Exit Sub...

Hi, I call a FormA from several forms - e.g. Form1, Form2 and Form3. I want to code some processing in FormA dependant upon which form has called FormA. Is the only way to get the calling formname by passing it in OpenArgs? If I already pass an OpenArg, do I have to concatenate a string...

Hi, I have a Status field that can contain the numbers 1 - 5 which relate to various statuses. I have a form with check boxes that allows users to select one or more of these statuses. However I can't work out how to word the criteria in the query. I am creating a StatusSearch field in my code...

Hi, I have a form which lists orders. I have a Search button which filters the orders in the list. How can I then print these filtered lines? Do I have to create a report and pass the filter as typed in by the user to it? Is there an easier way to do this? Thanks Debra

I call my NewOrderF with an acFormAdd to add a new order. This form has a subform NewOrderDetailsSubF. When I open the NewOrderF form, it creates a record on the OrderHeaderT and even if I close the form without adding any items in the subform, the record remains. I have tried putting an...

This is more of a logic question than a programming question (potentially). Status of an order and an order line can be: 1. Active 2. Part-shipped 3. Shipped 4. Invoiced 5, Paid These are in a StatusT with a description of the status and just the StatusID is attached to the OrderHeaderT record...

Hi, Can anyone see what I'm doing wrong here? I have 2 ways to add a new order - one from the main menu, where I have a dropdown to select the customer, which works perfectly. The second way involves having a button on the customer's orders form (OrdersF) and passing the CustomerID through to...

Hi, Access newbie here, I have two tables, OrderHeaderT and OrderDetailsT. I have successfully created a New Order Form, bringing in the header details and a continuous details subform. I have summed the totals on the subform and I can display the totals on the header part of the form using...

Hi, I have a set of processes that I would like to put into an automated switchboard. The processes are as follows: - 1. Run a make-table query to select a list based on a month. 2. Run a query for each month using the previously created table and another static table. 3. Run a report on this...