Recent content by leonepaolo

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...