Search results

Is it possible to create a customer format like 0235-ABC Where "235" autoincrements and "ABC" depends on a related record in another table? Obviously it would have to be text format due to the leading zero and once it gets too 999 to bump over too 1000 etc Accepted strings: 0111-ASD 1021-ERW...

Hey, I currently have a form with a subform in, used for a simple order proccessing system. The subform contains details about products. When i first open the form details are displayed correctly in the subform, when i click a button which will allow me to add another product to the order i get...

I have a report which has a subreport located within a group header, i'm trying to save the report as a .pdf via vba The name of report when saved will use some of the values located within the subreport. How can i access these values, or atleast move the recordset on by one when generating the...

I'm trying to create a query in which depending on which record is selected in Frm_News it will add that record to an existing record in Tbl_Temporary details. Is this possible? Thanks TG

I have a report which is linked to a table which holds order information. Within the report i have included a subreport located within the detail, and obviously it is repeating the detail for as many pages as there are records in the table. How can i prevent this? I only need to read/access the...

Just created a report and had the following code: Private Sub Report_Activate() TxtPurchaseOrder.Visible = True TxtPurchaseOrder.SetFocus Label17.Caption = "Thank you for your purchase order " & TxtPurchaseOrder.Text & " received " TxtDate.Visible = True TxtDate.SetFocus...

I have a Table (Tbl_Orders) which holds information about orders, it consists of an order_id and is a number data type. Is it possible using vba to find the order_id value and then increase it by 1? If so how would i do this? Increasing by one is the easy part just need some guidance as how to...

Trying to create an append query which will take details from a form. In the form i have the field Customer Name. The table in which will be appended has Customer ID. I have another table (Tbl_Customer) which holds ID and Name, is there anyway to match the appropriate records and then save the...

Hi, I'm trying to create a form in which a user selects a Customer from a Combo box and then can select a "Dongle" (or Product they have) from a list box. Below is a screen shot of the relationship between the tables. Also here is a screen shot of the form in which the combo/list box are found...

I'm trying to create a database to store product and customer information. An item have many batch numbers (batch ID) a batch number can only belong to one item an item can be in many products a product contains many items an order can contain many products a product can be in many...