Search results for query: *

Sorry - found out it was because of conditional formatting. I had to enclose the table names in quotation marks. My brain wasn't functioning well working late yesterday... Thanks for the help though.

I am almost certain the table names are correct as I have been using them on formulas everywhere else on the spreadsheet. I am trying to enter this formula in the Conditional Formatting section though - does that make a difference? And thanks for the help!

hi there, For some reason I cannot get this code to work no matter what I tried. I have a table called tblTracker in excel with the columns Name, Start Date and End Date. The table starts on Row 6 (Row 5 are the headers). Column D is the Start Date Column and Column E is the End Date Column...

It is located on the same folder as everyone needs to access that one file. But I do believe it's got something to do with security/trust settings.

hi there, We have an accde (Access 2007) db that everyone can open except for one person. She can open accdb files fine but when I tried to open the accde on her computer, it just opens Access (to the general screen - you know, where the db templates are and stuff). We have the security warning...

Thanks again :).

wow - I didn't know that. Thanks, mscallisto! I thought it is 'implied' that all variables declared in that line would be type String. Thanks also Lee Nash - I will try your suggestion. :) It looks 'cleaner' than mine. :)

Thank you! :) That worked! I didn't want to hard code the range. :) You are pure genius!

hi, I'm not quite sure how to make this work (I think I'm close). The paths to the files are stored in cells in Column B. I would like to loop through each row and grab the path and copy the file. So far this is what I have: Dim fso As Object Dim cPath, nPath As String Dim x As Range...

Ok...maybe this will help: I3 holds the value for completed pieces for a particular item. H3 is the TOTAL number of pieces (completed or not). Which is why if the TOTAL is zero (H3=0), I can assume that I3 will be zero (no items = nothing complete). Does that make sense?

Not sure what you meant there...

The reason I said this formula will just work in this particular instance is when H3 is ZERO, I3 will ALWAYS be zero. That's why I was just putting H3=0 in the beginning - putting I3 =0 also will be redundant.

I just changed the formula to: IF(H3+I3=0, "", H3-I3) It seems as though if I just put H3=0 it doesn't read the result correctly. But if I put some type of calculation in the first part it works. Like I said, it worked for my particular situation but it's still not my ideal solution. :)

Oh. I think I kind of solved the problem. I just manipulated the formula. It worked for what I needed for now. I still don't know why the above didn't work but oh well.

hi Skip! H3, I3 and J3 all have formulas. H3 and I3 are Vlookup formulas that return a number. J3 just has the formula: =H3-I3 I think looking at it closely it seems as though it's not reading it as 0 because of the formula? Is there a way around this? I tried conditional formatting too but same...

hi, I'm sure this is real simple but I can't figure out why. I am just trying to do a simple IF statement in Excel. Basically, the scenario is: If cell H3 = 0 then put a blank in cell J3. Sounds simple huh? Well, I've put this formula on J3: IF(H3=0,"", H3-I3) But it keeps coming up with: 0...

Never mind. I figured it out :). I guess I didn't see the "expression is" selection. How can I delete this post? Is that possible?

hi, Just wondering if there is a way to do this in the conditional formatting box. I have a textbox (txt1) in my report that has the following control source: = [field1] & " / " & [field2] which pretty much shows: 1 / 2 3 / 3 etc. How can I set the conditional formatting so that if field1 =...

hi duane, i've figured it out. it seems like it's running the queries for every time every page opens. i tested it and turned the queries into tables and fed it into the report and it opened within seconds. :) thank you so much though for your help. jen

Yes, the report is several pages long. I basically have 5 small tables (it comes in from a different source so it has to be in different tables). I use one main query to link the 5 tables together (they have a common itemID but that's all that's the same). Then I feed this query into the report...