Recent content by wyvern621

Hey Guys...you all get a star... Figured out how to get a module and John's code works perfectly... Skip, not sure why your code won't work for me, but I sill get that #Name? error--you get a star for being patient with me... Thanks again... ChiTownDiva [ponytails]

Hey Geoff... I'm Excel challenged... Where do you find a standard module in excel? I thought they were all either sheet or workbook modules. Forgive my ignorance... ChiTownDiva [ponytails2]

Hey Skip... Did that and I still get the #Name? error... ChiTownDiva [ponytails2]

Hi John and Geoff... I went to: Tools > Macro > Visual Basic Editor and pasted in the code on [Sheet3(Code)], saved it and then used it as a function on sheet3, column x (which is where I need it). ChiTownDiva [ponytails]

Hi Skip, Hi John... I'm Excel challenged...at this morning I am... I tried both pieces of code in a module and used it as a function and got the dreaded #NAME? error. Skip and John, I copied and pasted your codes in a module on General Declarations, then used it as a function in column X...

Murnin All...[bigcheeks] I was told to come here, so here I am... I have a spreadsheet with a few thousands rows on it and some of the rows are highlighted yellow. Is there a way to sort this spreadsheet by color? Thanks in advance... ChiTownDiva [ponytails]

Happy Monday All...[bigcheeks] I have a spreadsheet with a few thousand rows, some of which are highlighted in color--the highlight goes completely across the row. Is there a way to sort a spreadsheet by color? Thanks in advance... ChiTownDiva [ponytails]

Thanks BrianLe.... I have the subform property link set up correctly. My subform is collecting information to the transaction table. The problem is with the comment text box on the second tab--it keeps taking whatever comments I type in and recording them in the comment field of the first...

Happy Monday All... I have a database that keeps up with how many customers are being "worked"--we like to call it a Scorecard. There is a main form ("Scorecard") and a subform ("Transaction Subform"). The main from has a drop down box with a list of customers. The subform has 4 fields that...

Thanks Remou for responding... It's based off of a Oracle table, so it's huge...I was trying to think of ways to get the data in without having to do a pass-through query... ChiTownDiva[ponytails]

Happy Friday All!!! I have some code that I've been using: Function Import() With Application.FileSearch .NewSearch .LookIn = "S:\PROJECTS\LINKAGE\OMSGROUP\Military\" .SearchSubFolders = True .filename = "*.txt" .MatchTextExactly = True...

Remou... Sorry...I think I looked at this for way too long... It'w working... Thanks everybody for your help... ChiTownDivaus [ponytails]

Remou... Now it's adding all of the hours for all of the Analyst, no matter what Analyst I pick from the combo box. I even removed the date criteria and it's still giving me a total sum. ChiTownDivaus [ponytails]

Hi Djayam... Thanks for the response...yes the Analyst combo box is tied to an Analyst table. I'm getting a "Run-Time Error '3075': Sytax error (missing operator) in query expression 'Month(Date)= AND Year(Date)=2007 AND Analyst='Keith Smith'." on this line: vHours = DSum("Hours"...

Thanks for responding Remou... Now I'm getting the dreaded #Name? error.