Search results

Anyone have any idea how to resolve this problem? I spent a lot of time trying to resolve this annoying separator problem.

Dear Gamma, in Access manager I can only refresh connection but you can modify connection path.

Dear Gemma in Access 2007 you cannot change ODBC connection settings. If I make new connection the situation will be the same. I found smth like this but I don't know how to change it: http://www.experts-exchange.com/Database/MS_Access/Q_28423001.html I see this decimal separator when I use...

Hi all, I have big problem with connection between ODBC and Access 2007. Everything is linked correctly but I have problem with separator in decimal field. In my country this separator is "," not ".". I found information about connection in MSysObjects.connect table that...

Dear All, I want to write code to select records where field yes/no will be selected on yes. I wrote code like this Set rs = Mydb.OpenRecordset("SELECT * from tblCalc WHERE ((tblCalc.taknie)=Yes)") tblCalc.taknie - it is yes no field. I allays has the Error 13 problem, I tried...

Dear Sir, I don’t know more details about this tables. They are connected (in Access 2003) by, file, connect new table, (file type) ODBC, and then I choose internal type of base. Then from long tables list I choose 10 of them. I want to create this backup button to run Access offline (when...

In my database I have a lot of queries which are based on that ODBC Oracle tables. I want to create button which will “backup” all ODBC tables to access file. But backup tables must get the same name like Oracle tables (query must works).

For example I have linked ODBC table in my Access 2003 database. Name of linked table is tblSYSDBAP. I need VBA that will remove this linked table and create new table as access table. This access table must have the same name.

Hi, Is there any simple way the create via vba table from ODBC linked table? Tables must have the same name like ODBC tables. Thanks for any replays.

Dear CJ_London, I adapted this code to my orginal project Set Mydb = CurrentDb ' WHERE tblCalcTmp.taknie=yes") Set rs = Mydb.OpenRecordset("SELECT * from tblCalcTmp") While Not rs.EOF For i = 1 To rs.fields("krotnosc") Mydb.Execute ("INSERT INTO tblCalcTmp2 ( nr_umowy2, nr_klienta2...

Dear CJ_London, Tanks for your time and any replies. Everything is working now. Greetings.

But if i remove " the i receive error: Compile error: Expected: end of statement

Thanks for you answers but still there is a problem. Dim Mydb As Database Dim rs As Recordset Dim i As Integer Set Mydb = CurrentDb Set rs = Mydb.OpenRecordset("SELECT * from tbl1") While Not rs.EOF For i = 1 To rs.Fields(howmuch) Mydb.Execute "INSERT INTO tbl2...

Dear CJ_London. Smth. is wrong with code. Let me explain: tbl1 name; surname; brand; howmuch; karol sss opel 3 anna ddd nokia 5 tbl2 name2 surname2 brand2 When I try tu run macro from form i receive syntax error Dim Mydb As Database Dim rs As Recordset Dim i As Integer Set Mydb =...

Exactly :)

Is it possible that you will answer? Thanks a lot I have big problem with it and i don't know how to resolve it :(

For example tbl1 name, surname, brand, how much John, X, Mac, 3 Anna, Z, Opel, 1 And how to make macro in vba that i will receive in tbl2 name, surname, brand John, X, Mac John, X, Mac John, X, Mac Anna, Z, Opel

Hi everyone, I have two tables: tbl1 and tbl2. In tbl1 I have filed "howmuch" - it is number. Is is possible to copy records from tbl1 to tbl2 times (3,4 and more) like number in tbl1 ? Thanks for replays.

Dear All, In my database I have one form with two subforms. For example main form name will be 1, and subforms A and B. How can I write simple macro that will check if I put focus on subform A macro will check value in subform B ? Sorry for my English and Happy New Year/

Hi, In my access file I have connections for 7 odbc links tables. Is there any option to make macro that can make normal table from this links ? The name of table will be the same like name of links. And when i run this macro again this macro will delete all information and make table with the...