Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. leonepaolo

    Rounding up a number

    Thanks for the tip.
  2. leonepaolo

    division

    Thank you very much.
  3. leonepaolo

    Rounding up a number

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

    division

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

    ADODB Set Query as Recordset

    Thanks Roy-Vidar. Works Great!!! Paolo
  6. leonepaolo

    Combobox, Access and VB

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

    The need to compact and repair?

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

    Arrays

    Makes sense. Thanks Pete!
  9. leonepaolo

    Arrays

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

    How do I get App.Path to work in Access

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

    How do I get App.Path to work in Access

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

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=

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

    Skip a section in a For Next loop

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

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=

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

    Skip a section in a For Next loop

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

    Processing time clock.

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

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=

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

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=

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

    Processing time clock.

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

    Processing time clock.

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

Part and Inventory Search

Back
Top