Search results

  1. S

    Mysql server

    For me is the First case. How to transform access database, with all table, and append in mysql server? Note: Account is root and no password is sal21 In vb 6.0 if is possibile.
  2. S

    List of street/way of Italy with related zip code

    Exist a way in vba or vb6. Tks
  3. S

    get and post method on web page

    https://italia.indettaglio.it/ita/cap/cap_citta.html?regione=campania&regione_estesa=Campania&citta=Napoli Based this link. ho to select 80128 from Cap, and press on button Ricerca? In effect the, after Ricerca the web retrieve a table with result, of cap 80128 My code, but not return result...
  4. S

    ACCESS 2003/2007 Know the name of user...

    I use in my project VB6 classic. I need to know the name of users use or open the Access database located in \\myserver\mydir\db.mdb, and return from the find in ADSI directory the name and UserId. Possible.? Tks. Sorry for my bad english.
  5. S

    Getrow very slow

    note: - I have access database over netowork dir - all fields filtered with "where" clausole are indexed my conn: ... ENVIOR = "" ENVIOR = VBA.Environ("COMPUTERNAME") 'If CONN Is Nothing Then strProvider = "Provider=Microsoft.Jet.OLEDB.4.0;" If Not (ENVIOR =...
  6. S

    alter filed format date time

    I need to alter filed 24-gen-64, in 24/01/64... how to?
  7. S

    sorry for my english... dcount query, i think?

    Have 2 tables with fileds: CUMULO FIELD1 FIELD2 FIELDCOUNT AAA V1 0 AAA Z1 0 ... BBB Z2 0 CONTANTI FIELD1 FIELD2 AAA V1...
  8. S

    delete a milion of records

    I use the tipical ado ject conn with vb6 to connect a Access databse. Now i need to delete approx 4.500.000!!! value in 43 fields in table via vbcode. Have a fast way to make tath.? Tks.
  9. S

    summing range of row

    is possible to add total in column N for each orizzontal range do until last cell in column A is filled? Example: summing range B5:M5 put total in cell in column N summing range B6:M6 put total in cell in column N ... summing range B69:M69 put total in cell in column N In this case the column...
  10. S

    text like Ms Access mdb

    assuming i have a txt file into a dir server here is the global dim: Global Const PATH = " Is possible with a vba macro ,to make a vlooup into sheet (attached) with the index in column A and retrive the result of match from the text file, into column B Note: into txt the first line is the...
  11. S

    dlookup in excel vba....

    Assuming i have this mdb: http://www.mytempdir.com/548579 and a sheet TEST where into A2 is:OI14006 is possible to use the table into mdb to return in B2: GERVASIO CRISTOFARO IN effect i would want to use all in vba for excel. this is a part of code i have maked, boh?: Sub test() Dim cn As...
  12. S

    import stockquote/ticker price ....

    how to import stockquote/ticker price directly into a access table, also if with throu excel or an excel interfcae?
Top Bottom