Recent content by techsupport1

hmmm, is it possible a filter is being applied? Could you post a sample file?

click on the cell then data->Validation->Settings. Change Allow to "Any Value". This is pretty simple, remember google is your friend :) (first link in the search below)...

Hey Gareth, What if you set it up to determine how many columns were in each row when it started and then execute from there? I'm not entirely sure what you are asking, if you could post a sample file that would make things a lot easier.

I'm not entirely sure if I completely understand what you are trying to do, but here is some code that could work. Sheets("Sheet1").Select RowNum = 1 Do While RowNum < 33947 If Cells(RowNum, "H") = "" Then Range(Cells(RowNum, "A"), Cells(RowNum, "K")).Select...

Re: VBA - Save as certain filename when "save" or "save as" is pressed Interesting thought, something that hadn't crossed my mind. I'm using 2003 so there isn't a ribbon per say but I'll take a look into if that kind of thing is available for my version. Thanks :)

Glad to! If you don't mind, could you take a look at the issue I'm currently working on? It's VBA heavy and is slightly beyond my current ability. http://www.access-programmers.co.uk/forums/showthread.php?p=1136274#post1136274 Any help is greatly appreciated :)

Aboslutely, see the modifications below. Note that instead of D14, D15 or D16 you can put "delete" (including the quotes) or something similar. =IF(OR(NOT(ISERR(FIND(D14,E13))),NOT(ISERR(FIND(D15,E13))),NOT(ISERR(FIND(D13,E13)))),"found","not found")

Hey mmuu, I made something really quick that should get you started. I tried to explain things with comments since I know what it's like to just be starting in VBA. If this doesn't do it, or you can't modify it to work, upload a sample file and that'll give a better idea of what is going on...

Could you provide a sample excel file or more details as to what was different with each failed/successful attempt?

Hi Tom, There is one way to do this but it does not calculated automatically, you have to press f9 to update it whenever you want the value to be displayed. =IF(AND(CELL("row")<41,CELL("row")>9),CELL("row"),"") This is assuming the range you provided is what you want (10-40). It's possible...

Hey LadyDi, I can only answer the first two as I'm somewhat lacking Access skills haha. I wrote these to go into excel, not sure if you wanted VBA or what but here ya go. 1. =IF(ISERR(FIND(D13,E13)),"not found","found") Where D13 is the text you want to search for and E13 is the field you...

Re: VBA - Save as certain filename when "save" or "save as" is pressed I don't like to bump my own thread but with over 200 views doesn't someone have any insight? Somewhere I could start looking or a similar program that could be manipulated to fit my application?

My initial guess is that it is pointing to the incorrect cell...could you send some sample files?

Hey, I realize you might have an answer already but I figured I'd send you what I did anyways. The macro below enters the information into column J. I've attached a modified file that will execute the macro when the button is pressed. Sub Button1_Click() Row = 2 Do MultiPerson = False...

Hey LadyDi, I'm working on a solution using macros, will that be an issue? Also I'm working off of the fact that the project numbers will be grouped, will this ever not be the case?