Search results for query: *

That is just a brilliant piece of code. Thanks Skip!

How can I make a macro fire when I double click for the drill down? I tried recording a macro to try and replicate it, but I don't know how to trigger it.

I love pivot tables. I love the option where if you double click in one of the cells it drills down to show you records. My question is, how do I change the font size of the records you see from the drill down? I have a lot of data there, and I want to make it smaller so more fits on the...

I am importing an excel spreadsheet every month into one of my DBs. One of the fields can (but not always, and not even frequently) contain data with multiple values. These values are user IDs and are seperated by a semicolon. I need to analyze each of these IDs individually, but when I run...

Hi all. I have a long macro (running from excel) that runs every night running a variety of reports out of an access database for me. The last thing I want the database to do is to compact. I know there is a command line you can use with the /compact option, but I can't figure out how to run...

Also, this spreadsheet will be generated daily, based on a criteria of code. So I can't set it every day by hand, which is why I wanted to use code. Is there a VBA alternative?

That's cool. To take this a step further, what if I wanted it to check a range of cells? Say, AD2 through AD10?

Hi all. I am looking to do the following: If AD2 = 0 then 'Fill row 2 with color(red)' Either the entire row or a selection of cells in that row, whichever is easier. I've googled like crazy, but I can't find this command. Thanks!

I have several rows hidden in a spreadsheet. I want to use the autofilter on the displayed data only, however wheneven I make a selection with the filter, it unhides all hidden rows. Is there anyway to keep the hidden rows hidden? Doing so in VBA would be ideal, but i'll take anything at this...

Hi guys. And here I thought Math not Zathras skill :) Fireftyr, originally I did not need it to loop. Just to perform a simple formula. However, I have since been asked to add a lot of new criteria to the calculation. Also, it is the result of that formula that needs the if, not just if it...

Awesome, that did it. I love tektips. Thanks Rofeu!

Hi all. I am using the following bit of code: Dim rngCalc As Range Set rngCalc = Range("AD2:AD" & Cells(Rows.Count,1).End(xlUp).Row) rngCalc.Formula = "=(8-K2)" rngCalc.Value = rngCalc.Value In this case, the first cell to be replaced is AD2 and it continues for as many rows as I have. What...

Thank you both! Both codes work, though I am going with firefytrs code as its more compact, thanks again!

...it is done, the have it do so for the next row and so on until each row is done. At which point have it terminate. For example, for row 1: Take value from Cell A1, place the result of formula (8-A1)*10 into cell E1. Proceed to next row, using cells A2 and E2. I hope that is clear. Thanks!

Its not that simple unfortunately. It's not my DB, and this is the way it needs to be done for a vareity of reasons. I do understand your point however, and the DB DOES compact and repair itself daily after these tasks are done.

I completely agree, gmmastros, it's not the way I would do it, but its the way I was told to do it. Unfortunately it's not my DB. It looks like our two posts overlapped a bit, but the table is effectively deleted everyday and remade via a push through a ODBC link from another system.

No, the table is pulled from a daily feed from another system and creates table1. So I will need to create this field on a daily basis. Effectively the original table is deleted and recreated daily. It's not my DB, im just being asked to make changes to it.

There is nothing wrong with doing it that way, but my end result is to have this query part of a macro I have run daily. This way everything happens automatically and I don't have to create the field by hand every day. I would rather not use code. I will search for more information on...

I need to update table1 with data from table2 using an update query. The problem is there is no field in table1 for me to update to. I want the query to create a new field in table1 so I then have a valid target to update the data too. Example: Table2 has a field named 'DataField' Create...

I would like to thank you both very much. Golom's statement when input worked exactly the way I wanted it. However, Lynchg, you work more my speed, a query to make a query, so with your explanation, I was able to understand what Golom was saying. So thanks to both of you, I have the results I...