Recent content by mearmortal

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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