Search results

  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

    Select Top 2 by group

    Thanks to all ;)
  7. 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...
  8. 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?
  9. 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...
  10. C

    Import tables via odbc

    Solved with ISAM driver. I had to reinstall MSOffice.
  11. 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.
  12. 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...
  13. 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...
  14. 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?:(
  15. C

    Reconnecting ODBC linked tables in MS Access via VBA

    To me does not work, It says: (in bold the error line) Run-time error 3265 "Item cannot be found in the collection corresponding to the requested name or ordinal" What's my error? (N.B. dsn modified for my ODBC driver)
  16. C

    Help needed! : SELECT TOP "n", where n = query value

    Muaahahaah, no, I'm a guy, but I'm sure that my girlfriend won't like it too :D
  17. C

    Help needed! : SELECT TOP "n", where n = query value

    Can I say that I love you? A pair of modifications and it works like a charm!
  18. C

    Help needed! : SELECT TOP "n", where n = query value

    This: I need to recall a value from a query (or from a form) that must be used as "n" in the "SELECT TOP n" query. Any suggestion is appreciated, it doesn't matter the way to do it, I only need that the work is done (you can expect a lot of error: I never saw anything about VB)
  19. C

    Help needed! : SELECT TOP "n", where n = query value

    The Error is (I'll try to translate, the line code you indicated don't do anything... i don't understand how it's used): " Runtime 3141 The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. " I need to recall a value...
Top Bottom