Recent content by hatstand

Hi, I've read and created a macro that imports a simple CrossTab Query into Excel. I just recorded it and played it back. Works perfectly. But when I tried it again with more columns headers (50 column headers that are time broken down into 15 minute intervals) and run the code. Nothing...

No problem. You have been more than enough help. I think I've cracked it by creating a query then using that query in another one. There maybe a better way, but it works. Thanks.

Hi again, It does I think. But I must be doing something wrong as the only way I can get it to work is to make a query using: TABLE1: Month TABLE2: Date /Part Number Then create another query using the Linked table and the Query above. Am I right or over doing it?

Hi All, As per the guidance above, I created a linked table, used it in a query to allow me to use Excel to set the criteira in my query. It works perfectly. But, I would now like to expand the criteira. So if I add a new column to Excel it appears in the linked table. Fine so far. My...

Sorry for the late reply. Thanks very much RainLover. That worked perfectly and is a much better way of using Excel to set criteira. It's saved me so much hassle. Thanks once again, it's much appreciated.

I see. I didn't realise I could do that. I would have to add a third table as the main table is used by a lot of people and the second table. The one with the criteria, is a linked table and Access won't allow me to modify it. So if I add a third how do I create it so it's limited to my criteira?

I take you point. In my query I have selected my table and have added: Dlookup(“MyFieldName”,”MyTableName”) as my criteria. This allows me to alter what my query uses as criteria. It works perfectly, but will only use the first record in the table as criteria. Is there away to allow more...

I know this is an old post. But it's answered part of what I'm trying to do. If I have one record it works perfectly. But I can't get the -1 part working to allow more than one record to be set. Any pointers would be much appreciated.

Is it possible to use data in a table as the criteria in a query.

The only way I could see of solving this was to enter a parameter for each part number. Which will work for small amounts. But if you want to go above 50ish it causes an error. It’s the 256 text rule I think. I guess it just can’t be done this way. Does anyone have any ideas how I can set...

Hi, I have an Excel sheet that has data pulling from Access via ‘Import External Data’. I use 6 cells for Parameters Years, Months, Part Numbers etc. This works perfectly if each Parameter has only one criteria. What I can’t figure out is how to allow more than one Part Number to be...

Thanks for the reply. I can't access the video due to security software as I'm at work. But I will post the link home and have a look tonight. Just as a quick question. Am I on the right track by using the criteira or an IIf. My usual program is Excel so I keep thinking If statments.

I’m new to Access and new to the forum, Hi. I'm in the process of creating a database that uses an Update Query to populate one table to another. I've created a simple 3 field database to practice on. The fields are ID, Colour, Amount. My problem is updating only one figure without wiping the...