Recent content by stuey

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...

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...

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...

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...

Sorry I think I confused myself its not the postion that determines the score its the number of events you completes I think I cracked, not being very clever with VBA I did it ASP. I have create a table to store the results in which I am going to also use to display on the website, I generally...

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)...

thanks :)

Well basicaly for every athlete I have a start time, point 1, point 2, finish time and I work out the bit in between. I want to rank the bits in between

I thought the whole point of normalisation was to cut out duplicate data Secondly the fields I want to ranking on are actually calculated fields does this help or degrade matters stuart

where is this qrysamp hidden? Stuart

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...

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...

Why don't you set the field you want to be filled as the default value pertaining to the value used on the main form, look at the field properties. if you main field was Forms![MyMainForm]![MyDataField] then place it in your sub forms default value section regards Stuart

Okay finally similar performance from both machines connecting to a dedicated server. or the other solution is if you use file and printer sharing on a machine(98/95, possibly ME dunno yet) You can set the file system properties, by right hand clicking on my computer or going via the control...

Focused even further I decided instead of doing this in my devlopment envioronment ( laptop 2 PC file sharing I would use the server and try it out, no difference, workstation perfomrm fine and laptop dismally by comparison, worse so when user is logged in on both machines. so.... currently...