Recent content by Nuqe

I have an excel file and would like to manipulate the data and merge a couple of excel files. the only way i know how to do this is to copy all the data from the excel files into an array... manipulate it there and then store it back into an xls. i'm not familiar with accessing data in excel...

Strange, i just tried it and it doesn't matter what i have displayed, but i did set the height of it during the forms load event, so hopefully that clears it up. Before... it was hard to figure out what it could be, cause it worked, then it didn't... retarded!! anyways thanks a bunch NUQE We...

I don't have a clue at this time... i'll look Nuqe We all know about the "stupid user" don't we... :)

Hey there are examples on www.planetsourcecode.com on opening and closing cdrom drives. just select visual basic in the top right corner and then search for "open cd rom drive" the example is about 3 entries down or so. good luck Nuqe We all know about the "stupid...

Hey, I've had this problem in a couple of cases, and i dont' know what it is. When i'm editing my form/code, the form displays properly, but when i go to run it, the bottom of the form gets cut off... now you can resize the form and all, but its not professional its buggin me lol. If anybody...

Wait... CInt?? what is that used for anyways i used it and it worked.. heh my head hurts Nuqe We all know about the "stupid user" don't we... :)

well if i dont' do it like this returned = IsOdd("" & intRecNum2) then it gives me this error: Compile error: ByRef argument type mismatch intrecnum is just an integer holding number of records. We all know about the "stupid user" don't we... :)

actually this worked returned = IsOdd("" & intRecNum2) good to go thanks again Nuqe We all know about the "stupid user" don't we... :)

Adoozer, this code works, but doesn't allow me to enter a variable into the function ex. returned = IsOdd(intblah) can it be done? Nuqe We all know about the "stupid user" don't we... :)

I tried both of these ways and neither of them told the difference between even and odd... i don't think i did anything wrong. Nuqe We all know about the "stupid user" don't we... :)

Thanks a bunch Nuqe We all know about the "stupid user" don't we... :)

I'm looking for a way to determine if an integer is even or odd. i'm doing a print procedure and need to take the number of records in a database and half it, then print each half on different pages. This is easy unless you have an odd number. If i can determine if the recordcount is odd then...

Yes, i know how to manipulate the data no problem, i have it in an array which i could probably use as a source to print from, or i could create a table and put it in there to print from. I just needed to know if it was possible and if so an idea of how... thanks NUQE We all know about the...

Hello I need to print some data from an access database, i'm not too sure on how to do it. If it is possible to print from a table in an access database with vb?? that would be great. Or is it better off to try and print from an array. I've used to dialog control before but havn't done...

Hey, just wondering if anybody would know what the problem is. I have a few compaq v700 17" monitors and they just display black screens. they turn on no problem and seem to power up... its not the video card as i've tested that aspect of the problem and all is well there, any help would...