Recent content by mazz

Hi Alan yes it is more a flat file than a relational DB but that is the way it was given to me and they want it kept that way but maybe I could find quick ways to normalize the data for calculations. You have me thinking :-)

Hi I have created a function that has 43 parameters. When I call this function from a query the error I get is "query is too complex". This function will work if I have 28 parameters which seems to indicate a parameter number limit. Is there a way I can either call all 46 parameters or use...

Hi Rat1sully I adapted your code and replaced the print screen with my sql and it works fine. Rat1sully I like your code because it is simple and succinct. Thanks very much. As for my code you are right with the strColor replacing colors. It still wasn't working til I captured the nulls and...

This is the code I have so far but an error comes up: type mismatch. The fields are both the same type in both tables. The error occurs at: For i= lBound(colors) to UBound(colors). the code: dim strColors() as string dim ID as integer dim rs as dao.recordset dim i as integer dim strSql as...

Hi Recyan the color limit is unknown. How would I do 2) to loop thro & split each field, then insert in to a table This will not be a one off operation thanks mazz

Hi Big John thanks for you comments. I will look at article mazz

Here is what I have: ID colors 1 white, black, red 2 red, orange 3 blue Here is what I want to achieve: ID colors 1 white 1 black 1 red 2 red 2 orange 3 blue The separated field would be written to another table in the same DB. Any help would be greatly appreciated Thanks in advance mazz