Search results

Hello, can some one please assist on why this formula is not working? I've inheritated this workbook from someone else so really its not making any sense at this point. =IF(ISERROR(VLOOKUP(CONCATENATE(LEFT($C5,FIND(" / ",$C5)-1)...

hey jdraw, thanks for the post earlier do you know how to get this done? the kill bit stuff? sorry i dont know how to do this

not an expert at this suff but what this mean please? " KB973346 (Active X kill bit) caused this issue.... Not sure how... but will use filemonitor or another sysinternal tool to find out! Removed windows update KB973346 resolved this issue and can recreate it by re-adding the update!! " i...

Hello, can anyone pin point why this line is erroring? "runtime error - 438" Object doesnt support this property or method 'Get file selection from common dialog control With Me.ComDialogBTN .DialogTitle = "Select File" ' this is where its highlighting, if i comment this out then it goes to...

Re: Compile Error: "Cant find project on Library" in MS 2003 but works fine in 2007 ok i'm still getting this error and i've tried many things.. anyone have any idea? am i missing any refrences or something?

Re: Compile Error: "Cant find project on Library" in MS 2003 but works fine in 2007 help please anyone

Re: Compile Error: "Cant find project on Library" in MS 2003 but works fine in 2007 hey sorry to take awhile to get back to you, i did what you suggested but the issue was there was some refrences that had "Missing" in front of them and when i removed those it went through without issues but...

Compile Error: "Cant find project on Library" in MS 2003 but works fine in 2007 Hello everyone, can someone please help me in determining this issue? I have the following piece of code that is erroring in MS 2003 but it works fine in 2007. it highlights the "Set ref =" under the form_open and...

thanks for pointing that out..actualy i had a different code previousaly where i was lloking at multiple checkboxes but i kept that in there..not thinking... so thank you

hey thanks..that was really dumb of me..thank you though!

Hello, i have 4 checkboxes and have differnet queries that go along with it that i want to export to Excel. So the way i written the code is as follows, So if chkbox1 is clicked then qry1 is run and exported if chkbox2 is clicked then qry2 is run and exported if chkbox1 and 2 are clicked...

But lets say we want the null or space value to be interpreted as 0's then what should be done? I mean is there a way to do this??

Does anyone know how i can overcome this error? I currently have this query where i am converting the COBOL numbers into actual dollar amounts. What i want to now is sum up the actual dollar amounts (Amount_$ below) but when i do a Sum query it gives an error for "Data Type mismatch" can anyone...

also how can i display the actual field itself?

great thank you that works perfectly. Since i am new to this, what does Nz stand for and what is the use of it?

Hello, i am writing an append query where certain fields are written to a table, this is working fine but how do i write an if then statement in the query where i am asking to look for 2 different situations? table with 4 different fields, NameID, RecID, FieldNumber, Amount - tryingt o query...

thanks Mark!

Hello, is there an easier way to run multiple append queries using VBA? i know that i can put the docmd.openquery "query name" is one option..bt i have about 200 queries that I would like to run.. all the names of the query start with "qryedit..." so is there a way where i can say if the query...

i should be all set... SOOOOO thank you BOTH!! Also do you know how i can have someone recognized.. is there such thing? there are few folks who have helped me a lot and would like to say thank you...so i wonder if this site offers anything like that???

ok so i got a runtime error "Invalid procedure call or argument" and highlights the following code .FormatConditions.Add Type:=xlExpression, Formula1:="=IsBlank(" & cell.Address & ")"