Search results

This is what I have done; Dim objHttp As Object Dim strMsg As String Set objHttp = CreateObject("MSXML2.ServerXMLHTTP") Call objHttp.Open("GET", "http://mysite.co.uk/Version.txt", False) Call objHttp.Send strMsg = objHttp.ResponseText I can now read in the content of the text file and use...

Hi, thanks for the reply. Just an update. It would also work if I could just code to copy the file from the server to the C drive of the pc with db on it and then I could open that file immediately to read contents. thanks

Hi, I am looking for a way for a user to check the latest versions of our Access db. When they log in to the db (which is a stand alone db on C drive) I want to run a routine that connects to our server via the internet and opens a text file to view the version eg . 4.13. I know how to open and...

sorry, db now attached hopefully

Thanks for the reply. I dont think I've explained it very well. I have attached a mock db I quickly made. If you look at query1, I need a calculated field that will use the relevant field eg. row 1 of the query will require 4 * 12.50 (price1), row 2:4*11.00 (price1),row3:8*7.50(price2) etc.

Hi everyone, hopefully someone can help me out this evening. I need to be able to return a field name to use in a query; I have query1 which returns a code eg.either 1001,1002,1003 etc and other data including price1,price2,price3,price4 I have a table holding info about the code...

Hi I am trying to send some data from Access(generated by a query) to a bt web service (sms) Basically I am generating the name, phone number and message but I do not know how to get that data from within access to the web service/url. I want to be able to do this from vba behind a buttton click...

thanks Bob, i tried everything except that

Hi, I have written the following function; Private Function GetMaxValue(ByRef strTable As String) As Long 'gets the number of records from table which will allow us to determine how many records to add Dim db As DAO.database Dim rs1 As DAO.Recordset Set db = CurrentDb() Set rs1 =...

Thank you Jdraw so much for your help on this. Before I saw your posting, I managed to work out a solution as follows; Dim db As DAO.database Dim rs2 As DAO.Recordset Dim strSQL As String Dim strSQL1 As String Set db = CurrentDb() Set rs2 = db.OpenRecordset("t_2") strSQL =...

Thanks for the reply but I would like to be able to do this with vba code as I may have to do it several times with several users. I think I am almost there as i can add the records in table B. I just need to be able to amend them now but I'm struggling with that

I used the 3 records as a quick example. There are 20 records in table A (this table is correct). However, various users of the database have incorrect values in their table (table B) I need to correct the table with the values from table A. The autonumber field values must remain the same ie 1...

hi, I am trying to update values in a table with the correct values from another table. The first column is an autonumber field and is linked to another table and so I cannot just delete the records and add new ones. I want to loop through table A and insert records to table B that have the...

Thanks MStef - that works great thanks also Dave for your reply

fCountD custaccDate 2 02/05/2003 16 06/05/2003 10 07/05/2003 I want to return: 16 06/05/2003 ie. 16 is the max of that column and I require the date with it thanks

Hi everyone, I am trying to create a query that will return 1 row as follows; I have a query with 2 fields: CountofSomething, AccDate I want to return the max(Countofsomething), AccDate I am getting the max for each date - I want the max count and the date for that field ie. one row (I am...

Thanks for your replies. I've got a lot to think about. I like the idea of importing the databases and running analysis on it after. I'm thinking of maybe SQL Server doing this by creating an import job for each db.

Yes, we currently get a datafile sent in once a month and analysis is done on each one. You mentioned the host db importing the extracts - was that Access? How did that work?

I have just started work for a company with 200 satellite offices running a client db

Hi I would like to open several databases (up to 200). These have exactly the same tables. I would like to run a query on each database and append the data to another table in my new database ie. loop through databases run query A on table A Append to table B in my new database next This will...