Search results

Brian, Thank you for the reply with the tip about activesheet etc. After a quick "Google" I have managed to get something almost working that I can build on. ManyThx Growlos

Would any of the excel gurus please be able to help me with a macro to run in an excel 2010 workbook? I wish to create a macro that checks the worksheet to the immediate left of the worksheet with the macro in it and looks for a text string in the cells of a column. When it finds the precise...

Personal choice.

The macro is not in visual basic and is not represented on screen as code.

Hi, Can anyone please advise me how I prevent a step from running in an access 2010 macro? I used to place a value of "False" in the conditions column to block that step from running but this has all changed in access 2010. Rgds Growlos

Many thanks, the fields were not indexed and by changing the status to indexed it runs very quickly. I did not realise that indexing the fields would have such an impact on performance. All resolved, many thanks once again for pointing me in the direction of indexing. Rgds Growlos

Hi, I am looking for a more eficcient way to rank some customer orders using the time of the order per day for the ranking. I can get it to rank OK in a query using an "Alias" option but for large record sets it takes hours and hours to run. Is it possible to create a vba module to do this...

Bob, You're welcome, I have received good advice from the forum over the years and am happy to help others on the occasions that I can. Rgds Growlos

Re: "System Resource Exceeded" Due To BIOS Memory Configuration I resolved this and the method might be useful to others who get this message. It was nothing to do with the query design at all as I suspected, after all, why would it run on seveal PC's of lower spec and then not run on a high...

The data types of the fields in the calculation are as below: [EqvScRF = Number as double [CalcST] = Number as double [EqvST] = Number as double Sample data as below: [EqvScRF], [CalcST], [EqvST] 69.21, 19.95, 20.25 204.34, 3.95, 4.15 200.00, 3.98, 4.24 127.99, 10.74, 10.95 I made a copy...

I have tried the query setting the value to 1 and it runs OK. The calculated values are saved out of personal choice. The macro I am running is not a vba directly coded macro, ie, I set it up using the actions column and with actions like openquery rather than write the macro directly in vba...

There are 25 queries that run in sequence in the macro, the first 16 are update queries and data definition queries then the remeaining 9 are more update queries which populate newly created columns with data. As I said in my original post, it all works OK on two lower spec PC's but on the...

The macro is just a collection of queries that run in sequence. It halts at a specific query and generates the error but the specific query it halts on is not a complex query.

Hi, I am getting a "system resource exceeded" message when running a macro in a database on one PC but the same database and macro do not generate the message on other PC's. The PC that is giving the error message is a Win7 64bit PC with i7-2600k CPU, 16gb RAM using Office 2003. Two other...

Hi, I would be grateful if anyone could please assist me in the creation of a query that checks the order date of a record and then retrieves the ordercategory for the record with [orderdate -2] with respect to the original record. To illustrate the result I have pasted below the fields and...

Yes, got one of those also

Not at the moment but I can add one to the data set if it makes things easier? It would be in the format of an autonumber. Thx for looking at the topic.

Taruz, Many thanks for taking the time to create the code and post it onto the forum. The code runs in an SQL query but it is not returning the hoped for results. However, that is probably due to my forgetting about a possible occurence in the data set. There could be cases where a...

Hi, I would be grateful if anyone could please help me with a query that will provide details of a customers next purchase category based on the category of their previous purchase? Using the example below: [Customer] [Site] [OrderDate] [OrderCategory] Joes Bakery, Rennes, 01/09/2011...

Hi, I have a ranking query that ranks dates for buyers and sites. The record set that is subject to the ranking is approximately 60,000 records and the query takes 100 minutes to complete. Would I be better splitting the query into separate ranking queries via an alphabetic split for the...