Recent content by Chromium

  1. C

    Need ad advice (Access frontend on MySQL)

    no other suggestion? :(
  2. C

    Need ad advice (Access frontend on MySQL)

    Max users: 12. But your way does need that my pc is everytime on the net? If so it's impossible. But maybe I'm wrong... to be clear: I don't understand because I don't know anything about your solution. If you want (if you have time... ) can you explain a little?
  3. C

    Need ad advice (Access frontend on MySQL)

    Hi to all, I'm looking for a good website host that give an access or MySQL database for free WITH external connection open for free: I'm working on a small access application that need to share tables beetween some user. Could you please give me some suggestion (website, ideas... anything)...
  4. C

    Question Pivot Charts - how to share the x axis while using different y axis..

    I have different kind of data (think as groups) in a Pivot Chart, and to make it readable I have to separate "y" axis for any group of data. The problem is that I need to share the x axis (that is time... days, weeks...) while splitting different y axis for any group, but access split also the...
  5. C

    Import multiple tables records in one

    hi, I have to do a job in Access 2003 but I really can't understand how... so any help is appreciated!. This is my objective: I have multiple tables with the same structures, column names and no primary key. I can not change this structures: it's provided by my costumer. Every two weeks...
  6. C

    Two question, same objective (different random numbers query vs compact and repair)

    Works Great tnks ;)
  7. C

    Select Top 2 by group

    Thanks to all ;)
  8. C

    Two question, same objective (different random numbers query vs compact and repair)

    Hi again, First of all let me say that you're my favourite resource :) I'm trying to generate a list of n random number in a query, starting from a table of 100 records in one single field with value from 1 to 100. The query took that table and add a column "random" filled with the GetRand...
  9. C

    Select Top 2 by group

    It works right, but it' slow. I have 46000 records, and about 20 groups... cuttin' em It's faster. Someone have any ideas to improve speed?
  10. C

    Select Top 2 by group

    Hi, I saw some posts about this but no one works for me.. (sometimes I got my computer stuck with 2 cores at 100% percent... 30 minutes.. something goes wrong). Query: Trasferimenti Q2 Fields: Nome giocatore (text) Squadra Offerta (text) Valore (integer) That's the...
  11. C

    Import tables via odbc

    Solved with ISAM driver. I had to reinstall MSOffice.
  12. C

    Split text records by "*" in variable amount of fields

    I'll try! Since now, I found a way with a triple function. It works... but less cleaner.
  13. C

    Split text records by "*" in variable amount of fields

    Hi to All, I’ve a problem.. I need to split a field records with the following format: Aaaaaaaa*aaa bbb nnnn* aaaa bbbb 123 cc*bbbbb … etc etc By “*”, to obtain as result: Field1 Field2 Field3 Aaaaaaaa aaa bbb nnnn aaaa bbbb 123 cc The...
  14. C

    Automatic Import Access records from table to MySQL table

    Hi to all, I need some help (if you can) to make this work: I've an Access table ("atable") with the fields: field1,field2,field3. There is only one record in atable, with: field1 = value1 field2 = value2 field3 = value3 I need a code that act like a macro (in Access environment) to...
  15. C

    Import tables via odbc

    Does not work cause of an error "3170 Can't find installable ISAM." (NB I use Access 2007 and 2003) Any suggestions?:(
See more
Back
Top Bottom