Search results

  1. S

    New to VBA

    Hi, I am very new VBA but have been creating queries etc for a while, I am also pretty adept at doing classic ASP pages and I want to modify data in tables programatically and build by own reports on the fly. I really don't have a clue where to start and was hoping there was sticky thread...
  2. S

    Back SQL

    Hi, I run a website and want to insert some records over the wire, this could range between 200-1000 records I currently download my access database and then update using a couple of queries and then re-upload it. both sides of the system are ms access and I wondered if there was a way to...
  3. S

    dots in filenames throws error when trying to link tables

    I've been using MS access to lift some text files for a number of years I have now got an issue where by the new machinary is very clever and has alittle server to collect the data. Machine1_127.0.0.1, Machine2_127.0.0.1 Previously I picked them up via ftp and downloaded the data into a text...
  4. S

    Sub Query Unsure and google failed me

    i have been running a query So [Select * from tblStudents] Now this is part of an ASP system which logs when the students log in [SELECT * FROM tblStudenttracker ] now I dont update the student record regarding when they log, I track when the logins occur so I have a login history. But I...
  5. S

    Mildly Stumped league tables,

    I've been asked to collate some information based on a kid league, I am trying to sort out how precisely it works the data I have is this finish position, name, club I need to calculate the best kiddie based on 3 of a possible 6 races So tbls tblResults fldSeries NAME CLUB Pos(isition)...
  6. S

    More Complex queries

    Looking to Create a complex query which I have solved in the first instance by using a report but I would rather do this in my query. My query contains 4 pieces of info name, time1, time2, time3, overall time I want add a rank on all the times by smallest time first then sort by overall time...
  7. S

    sms Gateway

    Anyone used SMS to verify information from Ms Access, I can plenty of unix sms gateways but I wan't to confirm appointments and information to users via sms. I would like a vb application which I could call through code server.create objects and all that and simply pass parameters through tot...
  8. S

    Here is a tooth grinder for you,

    I have seen in the past someone open a form/report and run down the list and then double click the name of an individual which appeared which then executed something which pulled up there details, I can probably do it with the on double click property of the form however... I can only get one...
Back
Top Bottom