Search results

Hi can anyone help me please??? I have a button that when pressed copies some fields from one table to another. However if when these details are changed on the form, if this button is clicked, i get an error saying that this record cannot be copied as it is a duplicate of a primary key value...

A very simple solution!! Turns out that when i added my supplier table to the query it formed a link to my 'order' table. This relationship was not in my relationship diagram, and was not intentional! This occured because i had supplier ID as a primary key in my supplier table. Supplier ID was...

unfortunatly it won't!!!

Thanks for your help sorry new to VB... where would that go?

Had a very similar problem not long ago.... this is some old code i used... this code is deleting a record from the table orders and copying it to the table 'invoiced' Private Sub DUPLICATION_Click() On Error GoTo Err_DUPLICATION_Click Dim rsOrders As Recordset Dim rsInvoiced As...

Yer that sounds about right. It should automatically update. Is there a reason your using combo boxes rather than a subform?

thanks for your help, but i've solved the problem!!

dmax???? sorry...i'm not quite up there with you!!! Just looked it up on help.....(proper novice) And i think i kinda get it. Is there anyway you could give me a starting point on the kind of code i should be writing?

Can anyone help me with some code? I'm looking to have an if statement... which looks in a table to see if a record is currently there...it is looking for the unique reference 'detailID' Is this code similar to java???

obviously this button has to be pressed on the relevant record!!!

No the database won't be supporting orders on a large scale. The users simply press a button ...'print invoice' which generates the relevant report...... i suppose the invoice number should really be generated at the 'click' command??? (not that i have a clue!)

No, because there is already a 'orderID' at form level. Not every order will generate an invoice. But for analysis reasons the invoice number should be unique form the orderID and the invoice numbers should be in sequence

Hi i have set up a macro 're-size' based on the MoveSize command. I have placed this macro as an 'on Load' procedure, however nothing seems to be happening!! i have designed the form so all objets on the form would fit into these boundaries. AM i missing something simple???

hi, can anyone please help?? 1. I have a 'Order' form which gives a user the option to generate a 'Invoice' report. I would like an 'invoice number' that is sequencial and produced everytime this 'invoice' report is generated. 2. ideally this number would then be copied onto a field 'invoice...

Thank you sooo much Liam. The code worked like a dream!!! ...you solved a big problem thats been bugging me for ages..cheers :D Sarah

I'm trying to create a search function on a form using a combo box. The following code is what i used when looking up a primary key. Which worked fine. Private Sub Combo72_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[SupplierID] = " &...

ok....so I've got the footer up now.....the only problem is that it is appearing under the 'detail' header....i need it above this Pleeeeeeeeeeaaase if anyone has any ideas..let me know

Hi have a really strange problem... I've made areport to show a series of records from a subform in my main order form. The problem is i have a 'purchase order ID header' but not the footer. in my other reports this footer (its equivalent) is my bookmark to where the next record should be...

Sorry Liam...am not great at describing myself... 1. Yes i want to copy the information ! 2. Form A will remain open in the background!! (I want the fields from form (table) A to be copied if the user accesses Form B from form A - and formA will be still open) However these fields need to be...

hi..am soooooo confused.. I'm creating a query as a basis to create a 'order report' I have picked the various fields i need for this query..however...when i choose the field 'Supplier ID' i find the query will only display the records if the ID is 2! if i put an entry in my form where the ID...