Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. alan1203

    MS Access query, ? Sum Issue

    Thanks to both of you for your time.
  2. alan1203

    MS Access query, ? Sum Issue

    Thanks guys, here is the SQL SELECT tblParts.PartDescription, tblParts.PartNumber, tblParts.Price, tblParts.Drawer, tblParts.Compartment, Sum(tblUsedRecd.Received) AS SumOfReceived, Sum(tblUsedRecd.Used) AS SumOfUsed, [SumOfReceived]-[SumOfUsed] AS Expr1, tblParts.[Do Not Re-order]...
  3. alan1203

    MS Access query, ? Sum Issue

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

    Help with =IF(AND formula in excel

    Thanks Skip. How would I use a reference for a date?
  5. alan1203

    Help with =IF(AND formula in excel

    Thanks Skip. How would I use a reference for a date?
  6. alan1203

    Help with =IF(AND formula in excel

    Thanks Skip. How would I use a reference for a date?
  7. alan1203

    Help with =IF(AND formula in excel

    Thanks Skip that works a treat. What a good function that is. Thanks also to Combo for your reply. I was thinking that there was something wrong with the way I was referencing dates. I'll keep that in mind for the future.
  8. alan1203

    Help with =IF(AND formula in excel

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

    Update excel date if any cells in a range change

    The code you gave me works fine with the one line that I asked for and i was thinking about just copying that code for each line in the list but the list I have could grow in the future and I was hoping to avoid having to go back into the VBA editor each time as i've no clue what i'm doing. I...
  10. alan1203

    Update excel date if any cells in a range change

    Thank you PHV. If I was wanting to do the same for other rows can I just copy this and edit the ranges? or is there another way of doing this? Thanks
  11. alan1203

    Update excel date if any cells in a range change

    Sorry for the repeat post but my interpretation of Johns second post in my office thread was that my problam would best be solved using VBA and that I should post another thread in this forum. Could you be kind enough to offer anymore advice on this? Thanks, Alan
  12. alan1203

    Update excel date if any cells in a range change

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

    Automatically update date if cells change

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

    Word Form Field

    Solved it. I had to put the If argument into a macro and run the macro on exiting the field and it works no problem.
  15. alan1203

    Word Form Field

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

    Cascading Combo Boxes

    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)...
  17. alan1203

    Populate field on form with data from anther open form.

    I've chosen to use the frmattachmodeltopart as a linked subform. thanks for your help and your speedy replies. Alan
  18. alan1203

    Populate field on form with data from anther open form.

    WOW amazinly quick reply, Thank you. I just used the button wizard on access so it looks like this: Private Sub btnAssign_Click() On Error GoTo Err_btnAssign_Click Dim stDocName As String Dim stPartNumber As String DoCmd.Requery stDocName = "frmAttachModeltoPart"...
  19. alan1203

    Populate field on form with data from anther open form.

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

    Access Database Structure Question

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

Part and Inventory Search

Back
Top