Search results

Unfortunately not close enough for my very limited VBA skills, thanks anyway.

I'm afraid I'm a complete novice and iliiterate when it comes to VBA code can anybody point me in the right direction with this function.

I was looking to try and achieve the same thing but don't want to use a sub form. My parent has about 8 different sub Items and I wanted to put the buttons on the main form and have the sub forms pop up when each button is pressed. I have achieved this but it only works if theer is already a...

Any offers om the function?

I have a field in a table that is an order number of the from yy/xx where yy is the year and xx is an incremental number starting from 01. For example the first order this year was 03/01 and I am currently on 03/63, however I am currently inserting these details manually. Does anybody know of...

That's cracked it. Thanks very much for your help.

It is text

Hi again, On the form it's actually a combobox which is populated from the list of works in the Work table that have a Status 'I' and therefore available for ordering. It is actually called Combo28 and its control source is the IDWkNo field of the Order Table. Sorry if this information misled...

Tried your idea but it didn't work using the strSQL as: "UPDATE IDWorks SET Status = ""O"" WHERE IDWkNo = " & Me.IDWkNo & ";" Pops up a 'Enter Parameter Value' Dialog Box With the Value of IDWkNo is what it seems to be requesting.

I have an access 2002 database which includes 2 tables in particular. Work and Order. When a work request is received in the office it is entered in the Work table and has filed 'Status' that is set to I for identified. When the work is to be come an order on a contractor a record is created in...