Recent content by n7kon

Thanks Wayne worked like a champ. I was stuck looking for something harder and could not see what should have been right in front of me. Thanks again for the help. Jeanette the strinfo was passed to the function so was good there but thanks for the try. Keith

In a with statement can you refer to a field header using a variable? With rsNoun .MoveFirst Do Until .EOF If !jde = strAJDE Then .Edit !strName = strinfo (here is where I am trying it. ) .Update End If .MoveNext Loop End With The...

Thanks JDraw for the comment. I am sure I should have asked a better question as I read my first post. What I am really doing is pulling all of one type of item and all its records from one file. A motor could be electric, pneumatic, hydraulic etc… and each one of those combinations will have a...

I found my answer from another person that uses access same way I do. We analyze data from much larger data files to answer questions for our customers. We never build front ends or reports. This job is to take all the data from the larger AS400 data file and bring it down into separate tables...

I would like to be able to build them all one at a time but I am working with a master file of over 2 million records and need to break each noun modifier combo out. The file holds about 139 thousand items with many records for each item. I have 1400 nouns and 3800 modifiers to go with those...

Ok here is where I am at now. This does not work because I am using the variable for the table name in the alter table statement. I need this to be generic so I can use different combinations of noun/modifier. Public Sub Add_fields(NounID, ModID, strNoun) Dim strAtt As String Dim strAttID As...

I have three tables called Noun, Modifier, and Attributes. I have created a new table using the first two fields as Noun and Modifier and planted a default value in them. Now I need to create more fields in the new table. The headers for those fields would be the matching attributes from the...