Search results for query: *

Mustangcoupe you are a star, that works perfectly!! All I have to do now is change the "On Exit" procedure and it blanks out the value. Thank you very much. [2thumbsup]

Thank you mustangcoupe for your idea and let me apologise for time taken to respond. People expect me work on more than one project at a time!!! I've looked at this: http://www.tek-tips.com/threadminder.cfm?pid=705 and that seems to make sense also. This is how I've started writing the code...

Thank you M8KWR for your tip. I've changed the tables as you said, when I raise a Purchase Order The values are still displayed. I've used a word document and embedded it as a report. Next I've overlayed the necessary textboxes, would this make any difference, as the textboxes are just copies...

help!! I have written a Purchase Order System and have now reached the stage of debugging. Even though this system went "live" a couple of months ago, one (Of many) problems remain. The Most important fields I have are: "QTY", "Description", "Cost" (per unit). The QTY & COST fields calculate...

I'm having bit of a 'mare at the moment. I've created a simple db that uses a switchboard to either edit or add a new record for a purchase order. Everything seems to work fine apart from the button on form which should print that record to a report. The form is ADMIN FORM, whilst the table used...

Hi. The easiest way I found to do this was: In your current Db click on TOOLS in the menu bar & select options. From there click on the ADVANCED tab. You will see 'DEFAULT OPEN MODE' set that to 'SHARED'. In the 'DEFAULT RECORD LOCKING' options click on the 'EDITED RECORD' radio button. This...

Thanks for the tip, but now I've tried that a requester box opens "Update values: Entry Sheet (From addins)" additionally the cell reports a #VALUE! error. I'm obiously doing something wrong!!

Ok, apologies. Sheet 1 is entry sheet, The user types in a location into a row of cells, say A1:A10. On the next work sheet(Sheet 2) a table picks up the text entered as a value of 1 or 0 (true or false). chart 1 then calculates these rows to produce my final graph. I hope this makes it clearer???

I,m a novice with Excel, I'm trying to convert any text enterd into a cell from one worksheet, then let the other worksheet dislplay that text as a true or false value (1 or 0) I've tried using the IF statement, but am not getting very far!! Can anybody help????

2 ca8msm. Thanks a lot you've been a great help, this should resolve the conflicts with other users. All the best.

I don't think I explained v.well!! My system works like this: C00xx. Obviously each new p/o increases the value of xx by one. So the idea would be to generate a new number on opening or saving the document. Sorry for being unclear!!

I am using Word 2002 for my commercial Purchase Orders. I would like to add a unique order number to a form when it is saved or opened, is there a solution to it???

That's great, you've saved my bacon from the network administrator...thnaks a lot

Hi, I'm a new user to access. I had a problem with a database that I'd secured. After deleting it off the server and before my machine crashed- Access came up with a message "Unable to find system.mdb, do you wish to repair?" After rebooting, the program continually messes up my...