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

    Assistance with Split/ Main, Subform creation please

    Great, now working as expected with some dummy data in the table, Thanks for all your efforts and persistance in assisting me to get this right.
  2. mearmortal

    Assistance with Split/ Main, Subform creation please

    tblCommodities now reduced, easy. tblCommodities subform created with record source: SELECT [tblCommodities].[StationID], [tblCommodities].[MaterialID], [tblCommodities].[OptionID] FROM tblCommodities; I think this is wrong, as when I look at the first two records, there's nothing against...
  3. mearmortal

    Assistance with Split/ Main, Subform creation please

    OK, Can I keep the combo boxes I have with the dropdown's reducing the selection critera, and use then the StationID & MaterialID from cboStations and cboMaterials. Then using(as you say) link Master properties, of the subform, use these values for two of the entries, and then just the options...
  4. mearmortal

    Assistance with Split/ Main, Subform creation please

    Here you go tblCommodities contains: CommoditiesID - AutoNumber SystemID - Number (1-M tblSystems to tblCommodities) StationID - Number (1-M tblStaions to tblCommodities) MaterialTypeID - Number (1-M tblMaterialTypes to tblCommodities) MaterialID - Number (1-M tblMaterials to tblCommodities)...
  5. mearmortal

    Assistance with Split/ Main, Subform creation please

    Hello, I've read around that this might work: - INSERT INTO tblCommodities (CommoditiesID, SystemID, StationID, MaterialTypeID, MaterialID, OptionID) Values (CommoditiesID cboSystems, cboStations, cboMaterialTypes, cboMaterials, cboOptions) I'm also unsure where to put this code or if...
  6. mearmortal

    Assistance with Split/ Main, Subform creation please

    Finally after several hours of painstakingly trying different methods, I now have two sets of two combo boxes selecting values, Systems against Stations and Material Types against Materials. I have another combo box 'Options' selecting an option based on tblOptions, Fields OptionsID and...
  7. mearmortal

    Assistance with Split/ Main, Subform creation please

    Thanks for the response, so here goes. I'll explain the table structure first, and see what you think. Table 1 is a list of Systems. Table 2 is a list of Stations, belonging to a system, so there is a 1-m relationship with several stations in any 1 system. Table 3 is a list of material types...
  8. mearmortal

    Assistance with Split/ Main, Subform creation please

    It's been 10 years since I worked on Access and now a different version and I've lost some information on creating Main Subform or Split form stuff. Old age I guess. I've got 6 tables all working, relationships created and everything looks good. The main table is made up of data from three of...
  9. mearmortal

    Help required with putting data into comments fields

    Running the second macro does the following: - It creates a separate sheet with the information formatted horizontally. What I would like to do is have the second row which has number in places sometimes and not in others, put into comments on the line above. giving the association. In doing...
  10. mearmortal

    Help required with putting data into comments fields

    Find attached the second filehttps://rcpt.yousendit.com/813344934/e3da38348ea8f57c6ab1acc122d0d5e3
  11. mearmortal

    Help required with putting data into comments fields

    Strange it's only a rar file. I've recorded Macro's before, but the VBA script I'm using is working on Offsets a lot and I don't know enough about VBA to workout the differences. The Script was given to me by another colleague. Find attached the first...
  12. mearmortal

    Help required with putting data into comments fields

    I load the txt file into excel format with delimited set with TAB and other | character Delete the lines down to and including Row27 and select the first cell. I run the clean macro first removing unwanted text. Running the second macro does the following: - It creates a seperate sheet with the...
  13. mearmortal

    Problems with Pivot Table in 2007

    I find it interesting because it used to work fine in Excel 2003.
  14. mearmortal

    Problems with Pivot Table in 2007

    I've got columns containing labels : - Alpha, Beta, Charlie, Delta, Echo, Foxtrot and Golf. Rows are some 2000 lines filled with data. I've created a pivot table, and selected the following: - Column Labels = Golf Row Labels = Charlie Values = Count of Golf So what I have in the pivot table...
  15. mearmortal

    Need help with a formula

    I can see where you are going with this, but new items on the list do not have a Y in column F therefore, I need to know how many of them do not without having to manually count them. Also this value has to change automatically to ensure accuracy. Thanks for everything
  16. mearmortal

    Need help with a formula

    I changed the formula in the one cell (H11) to: - ="'Games'!C1:C"&MATCH("Y",'Games'!F:F,0)-1 And this formula in another Cell to: - =COUNTIF(INDIRECT(H11,TRUE),"Europe ") I then changed the formula to 1 cell: - =COUNTIF(INDIRECT(("'Games'!C1:C"&MATCH("Y",'Games'!F:F,0)-1),TRUE),"Europe ") And...
  17. mearmortal

    Need help with a formula

    I use this formula: - =COUNTIF('Games'!C1:C46,"Europe ") But the end cell number changes based upon it being the last empty cell, calculated from this formula: - =MATCH("Y",'Games'!F:F,0)-1 This formula reports the row number in column F with a Y in it and returns the value -1. Hence the last...
  18. mearmortal

    I want to access multiple machines behind NetGear

    I want to understand the easiest method, or the best method. I can use vnc and I understand a little about VPN's. But I don't want to make this complicated. I'll be on the internet using a normal broadband connection. I want to access the home network behind a netgear Wireless router. I know...
  19. mearmortal

    Product Serial number

    If you know the original shipping number, (think it starts with an 8 and is some 8-9 numbers long), why don't you ask Mitel for a duplicate. It's in the system. They just need to find it.
  20. mearmortal

    SX-2000 Map E/M/S/U

    How do you talk to the other systems, serial interface or IP. If you are trying to communicate with the SX2K over serial with a MAP, I'm not sure it will work. The MAP is primarily IP Based and can be set-up to communicate with the MC3E card on the ethernet port. You have to tweak the IP port...

Part and Inventory Search

Back
Top