Search results

  1. 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)...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. C

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

    Hi All, I’m Italian so first of all sorrry for my bad english. :p I need to realize a “ SELECT TOP n “ function (function preferred than Sub, cause I can call it in a normal access query), but I don’t know anything about VB. I tried to search on the net, on this forum, and I found some kind of...
  9. C

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

    Hi All, I’m Italian so first of all sorrry for my bad english. :p I need to realize a “ SELECT TOP n “ function (function preferred than Sub, cause I can call it in a normal access query), but I don’t know anything about VB. I tried to search on the net, on this forum, and I found some kind of...
  10. C

    function Date() not recognized + OFFOWC.dll request!

    Hi, I'm Italian and I started playing (I don't work on it) with access to create an Airline Simulator for MS Flight Simulator. My "program" read data imported in an Access table by a secondary program, and work on it. :cool: One or Two of my Beta testers found this problems: 1) function...
Top Bottom