Search results for query: *

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.

Hi Everyone...I'm using Access 2003... I have a table called "Transaction": Hours (Number) Qtr (Text) Date (Date/Time) Analyst (Text) Customer (Text) trid (Autonumber) Comments (Memo) Activity (Text) I have a form called "frmTransactions": Analyst (Combo Box) Customer (Combo Box) Activity...

Afternoon All... I added a module to open a Dialog Box to import some files. Works great unless you hit cancel, then you get a runtime error 2501 "The RunCommand action was cancelled". Here's the code: Function GetPMSL() DoCmd.RunCommand acCmdImport End Function I want to add an...

Thanks guys... I figured it out...it was in the type of specifications I was using to import... ChiTownDiva [ponytails]

Hi All... I have a database that I'm idiot-proofing (if that's possible--it seems a better idiot is born daily)..anyway--got a form, press a command button and an imput form pops up asking for the location path of a file. The path is fed into some code that imports the file using an import...