Search results

hmm okay, is it possible to put focus onto the main report not the subreport on report_activate?

Yeh autoprompt pops up everything, double and triple checked the referenced names are correct but to no avail preventing the error. added me. to the affected controls to. TxtPO is bound to the PO field, could this cause a problem? Done some google searches, most people seem to get this error on...

Hmm, i've changed TxtDates to something different, still getting the same error on TxtPurchaseOrder.setfocus

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...

Works perfectly, Thanks :)

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...

Okay that would work, found another way of performing it by creating a normal select query and then running that in the append query seems to do the job. In the customer table the fields are, Customer ID and Customer Name. Couldnt be bothered to write them out fully earlier. Thanks for quick reply.

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...

It works, thank you very much! Kicking myself now i changed the Customer ID to Customer Name in the Dongle table earlier. Thanks again for your time. Slowly learning my way further round access

Okay here it is, i've removed all the other tables and anything irrelevant for the moment

yeh thats fine, give us a few mins and i'll post it back up

No problem, okay that parts all sorted. I still cant get it to display the query results. 1) Added Me!CmbDongle.Requery 2) Added SQL tp CmbDongle's Row Source Have i missed anything ?

Okay, have added the SQL into CmbDongle into the Row Source, is this correct? The error has now gone, although the combo box is not filled with the expected data. I get two pop up parameter boxes asking me to enter "DongleID" "CreationDate" and "CustomerName".

Thanks for the reply, is that record or control source for the SQL statement? Also adding in the .AfterUpdate event produces activex errors. Any idea how to solve?

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...