Search results for query: *

Thanks for the tip.

Thank you very much.

Hi! How can I round up any number to the next interger or long. i.e. 30.00001 = 31 Thanks in advance, Paolo

Hi! I'm sure this is real easy. When I divide two numbers, or have a decimal number, I only want the digits to the left of the decimal. Aside from: Left(MyDecimalNumber, InStr(1, MyDecimalNumber, ".") is there a more mathematical way of doing this? Please note that I'm not looking to round...

Thanks Roy-Vidar. Works Great!!! Paolo

Hi! How do I clear all the values in a Combobox? The values were loaded by "Value List" Thanks in advance, Paolo

Hi, I have several mdb files that are used for reference purposes only. I link to them and I create run-time connections to them to retrieve the data I need. Do I need to compact and repair these files? Any comments or suggestions are greatly appreciated. Thanks in advance, Paolo

Makes sense. Thanks Pete!

Hi! I know it's important to close recordsets and connections and set them to nothing when we're done with them. Is there a need to erase arrays as well? Thanks in advance, Paolo

Thank You CautionMP. Thank You CautionMP. Thank You CautionMP. and THANK YOU!

Hi, I trying to create a program that'll run off a USB drive and as such I won't always know the path of the application. I tried a couple of the methods on this site but I must be missing a reference. I'm really hoping for a simple straight forward solution as I'm not sharing the data...

Really... I didn't know that. Looks like I have a lot of reprogramming to do, good thing I'm fond of Sub's including opening connections and recordsets. I have a dangerous question for you: If I recode my CreateConnection sub procedure From: Set cnJet = CurrentProject.Connection To...

Hey TheAceMan1! Well that was nice and simple now wasn't it. I just love one line "If" statements, those nasty "End If"'s just get in my way. Thanks for the headshake. Until next time, Paolo

Thanks cmmrfrds, I think I get it. That means that I'd need 2 files, one to store the data and the other to run my applications. Is this right? Thanks again, Paolo

Hi! When Something = False I want to skip the balance of the code within my For Next loop. Right now I'm using a GoTo SkipToNext but I was told that GoTo commands shouldn't be used like this. I'm also not crazy about how the "SkipToNext:" flushes left in this instance. Any suggestions or...

Thanks TheAceMan1, Looks great! I can't wait to try it. Thank you, Paolo

Thanks cmmrfrds I like much of the functionality that connection type provides, is there a different connection I can use. Thanks again, Paolo

Hi, How do I set this type of connection to current file I'm working on, i.e. vb code in Access. I get an error that the files been locked. Any suggestions will be very much appreciated. Thanks in advance, Paolo p.s. I've tried a variety of things, but from VB6 this works, provided the file...

Hi TheAceMan1, Too bad about processor speed affecting a timer. My heavy sql statements come before the loops. The heaviest process reverses a date sort on 1.5 million records, and 8,000 new records get added every day. I decided to split this table, I only really need the 11 most recent...

Hi TheAceMan1, I'm great! How are you? The last time I ran it, it took 58 seconds, not to long bear, but I'll be incorporating the process into another, which takes a "few" seconds of its own. Once that's done, it's going into another process... I love automation! I use a lot of sql, so...