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!

  • Congratulations SkipVought 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. Calimero

    Compact Access MDB from VB without DAO or JRO?

    I don't know about a Jet API call, but you can compact an Access database through ODBC calls. Check the Access ODBC driver documentation and the ODBC driver API.
  2. Calimero

    Access and ODBC- Getting Access to find ODBC on an NT server

    TO TRAILBLAZER:<br> <br> You need to install ODBC on all clients in order to be able to use ODBC from the clients, even if your datasource (database) is on an NT server.<br> <br> The ODBC Driver API allows registering data source names by having a piece of software doing it for you. Check the...
  3. Calimero

    Word merge from Access

    Make an Access file with the default workgroup file (system.mdw). From that Access file you can attach Oracle (ODBC) tables and ask to save username/password.<br> <br> The user shouldn't then need to enter any username/password at all.
  4. Calimero

    Rounding

    SUB UpTrunc(x As double)<br> Dim result As long<br> result = Int(x) 'I believe it's Int, otherwise try Trunc<br> If result&lt;&gt;x Then result = result + 1<br> UpTrunc = result<br> END SUB
  5. Calimero

    FTP from Access VBA

    There are several ActiveX controls you could use for that, or you could stick to 'Microsoft Win32 Internet API' (WININET) from Microsoft, which is a DLL that allows among others ftp-ing files.<br> <br> I've however never used WININET, but I have complete function reference on the MSDN library...
  6. Calimero

    EVALUATE() FUNCTION IN VB, Is it out there?

    You could also use VBScript as a component ('Microsoft Script Control 1.0' or higher), included into your application. You can then fully dynamically create code (such as subroutines etc.) and have them run without any compilation or whatever !!!<br> <br> OK, OK, it's a heavy solution for what...

Part and Inventory Search

Back
Top