Search results

Ok have done! I have linked to the two tables dbo.o_prac dbo.o_pat from Sql server and then I renamed the linked tables to o_prac and o_pat... Now I will have to disconnect the connection and make the subroutine read from the linked tables.. Please could you help me out in the code...

Tried it! The connection is fine and the database is taking edges connecting to SQL, it takes more than 10 minutes and I had to terminate it. This is just for one record which should come up instantly. Mind you the table it is reading is built up 100,000,000 records. Could that be a reason ...

The problem is remember when we had a print out of the select statement it reads from tables o_prac and o_pat. But in sql the tablea are saved as dbo.o_prac and dbo.o_pat? Meaning it will not find the tables or does it neglects the dbo? Thanks

This is purely a sql server problem if you have any clue.. The tables in sql are saved as dbo.o_pat and dbo.o_prac Is there any way i can change the schema to be empty. So that it will be o_pat and o_prac... Thanks

Ok , I think i'll create an DSN connection / linked table. Thank you very much for your help today. I'll keep you informed how it is getting on in due course. Much appreciated

this is what it brings; Select o_prac.o_prac_eid, o_prac.o_prac_go_id, o_pat.o_pat_eid, o_pat.o_pat_id, o_pat.o_pat_birth_yr, o_pat.o_pat_birth_mth, o_pat.o_pat_curr_gender FROM o_prac, o_pat WHERE o_prac.o_prac_uid = o_pat.o_prac_uid AND o_pat.o_pat_eid IN (11546, 37464, 2844646, 74747...

This are the areas where txtCodes is used, probably it will be faster for you to notice what this chap was really doing.. Private Sub cmdParse2_Click() ' feeds all the codes from the patEID table into a string variable TabChoice.Pages.Item(2).SetFocus Set dBS = DBEngine(0)(0)...

On the form I found the lblSQL label and the caption is SELECT there is no table mentioned. No events declared.... Sorry, but this project was developed with someone who has left the organisation and I have been given limited time to upgrade it before the odsaccess is shut down. If it happens...

Thank you very much for the explanation. When you typed - "With regard to context, that the querydef is created upon cON means it is a server query (again rememeber it's not created on the server, it's temporary - but it is connected to the server" Is there any way I can update the code not to...

Hallo, Please could anyone tell me what the following highligted in red codes means; Option Compare Database Option Explicit Public qDF As QueryDef Set qDF = cON.CreateQueryDef("", strSQL) Set rST2 = qDF.OpenRecordset() This code is inserted within an ODBC connection as shown below...

Ok, sorry my mistake. Then please could you let me know why it is connecting to the ODBC - odsaccess... If to access data, where is it showing it or directing it really!!! If I can ONLY know the data (such as a table name it accesses the data from) from odsaccess... I'll extract that data...

Thanks namliam, very helpful. I have a question - when it tries to correspond column in rST1 with data from the record in column in rST2. As you said ; rST1.Fields(i) = rST2.Fields(i) fill the corresponding column in rst1 with data from the record and column in rst2 rST1 comes from...

Hallo, The application I have is dependent on a database which will be shut down this weekend, therefore I was instructed to check this specific module and determine how it is connecting to the database and how it fetchs the data. Then I have to take the table from the database and make it...

Hallo, I am new to access please could anyone tell me what does this two line of codes mean; Set qDF = cON.CreateQueryDef("", strSQL) Set rST1 = qDF.OpenRecordset() Thanks

Hallo, I am working on an old developed Access database. One of the changes I have to make is to change the export from drive a: (disk) to drive d: (CD). I noticed that on the Export click button it calls the following module (see below). I have tried to change to d: drive by changing the...

Hallo, I have the following formula which works fine. However, when I select ALL the records are not sorted in ascending order as per the drop down list (i.e., ?Practice). Is there a way I can display the records in alphabetic ascending order? Thanks (if {?Practice} = "ALL" then TRUE...

Hallo, I have this code of line which works fine if the field is populated with NULL but doesn't work if it is an empty field, please can someone tell me how I can modify it so that it can recognise an empty field too, Thanks isnull ({QryQuarter2.address1})

Thanks done

When I inserted the code below the error "syntax error (missing operator) in query wexpression 'TOP 3 Table1.Salary'. SELECT Table1.ename, TOP 3 Table1.Salary AS MinOfsalary FROM Table1 ORDER BY Table1.Salary; Whats wrong?

it doesnt do it really