Search results for query: *

Hi, I have a simple Access query that Sums the number of items received and the number of items used, then uses an expression to calculate 'Received' - 'Used'. The table that contains this data just has 'Date', 'PartNumber', 'Received', 'Used', 'OrderNumber' and 'Comments' fields. I populate...

I have a spreadsheet with outstanding repair / maintenance jobs. I have been asked to break that down into jobs that are > than 3 months old and then break them down into Yearly stats. I think i have the greater than 3 months jobs sorted with =IF(AND(PlannedDate <> "",PlannedDate <...

Hi I was hoping somebody can provide me with an easy was of updating a date in an excel cell if I change any cells in a range in a worksheet. For example; If I change any of the data in range "A2:G2" then the date in "H2" will update to todays date. Thanks Alan

Is there an easy way of entering the date in a cell if any of the cells in a range are changed? For example If any of the cells in range A2:G2 are changed then H2 = the date that the cells were updated. Hope this makes sense. Thanks, Alan

Hi, I have a form created in MS Word 2003 and one of the fields is for a price. I was hoping to have a message box if the price was greater than £5000. The form field bookmark name is "Price". I've tried If ActiveDocument.FormFields ("Price").Result > 5000 Then... as a general decleration in...

Hi. I hope somebody can point me in the right direction with help on how to use cascading combo boxes on MS Access forms. I have 4 tables; tblManufacturer; ManufacturerID (PK) Manufacturer tbl Model; ModelID (PK) Model tblMachineParts; PartID (PK) ManufacturerID (FK) ModelID (FK)...

Hi, I have a database for keeping track of spare parts in my department. Currently users have to enter the part information and then assign that part to a machine on another form. The new part form has the following fields. Part Description: Part Number (PK) Part Supplier Part Price Part...

Hi. I'm trying to develope a database to keep track of spare parts in my department and i'm not to sure how best to structure it. What I have just now is 4 tables: tblManufacturer: ManufacturerID: (PK) Manufacturer tblModel: ModelID: (PK) Model tblSupplier: SupplierID (PK) Supplier: Address1...

Hi all. My problem is probably very simple to solve but as i'm new to this sort of thing i'm unable to work it out. I have a document that I need to print 3 times, each with a different watermark on them. I have recorded some macros to insert the watermark then delete it to be replace with the...