Search results

I agree Chris, it has something to do with the old ADO Here is what I think I’m going to do, I’m gonna try one part/form at a time … and try to use more SQL statements instead wherever I can and eliminate procedures I don’t need any more … If can get the export procedure to work I will be more...

try this Dim Oracle_Db As Database Set Oracle_Db = DBEngine.Workspaces(0).OpenDatabase("", False, False, "ODBC;DATABASE=Your_DB;UID=Your_UID;PWD=Your_Password;DSN=Your_DNS")

did you try to add it thru ODBC administrator ?

I compiled it many times, every time I did that the only errors I get are the missing preferences .. so I added them and the errors gone …

hey guys, I have this little problem that I need some help on I tried to use 2 subforms and queries ... but I end up with 4 subforms and about 8 queries … and still didn’t get it to work Here is the scenario: I have this Form(image) and a Table called “SO Master “ fields (SO, Qty, Reviewed...

good point Banana, but there are tones of codes to go thru!!! and that was just one action(load) one form...

thats the reason i'm trying to upgrade to 2007!! jijijijijij but honestly it is running very smoothly on win XP pro SP3. so far I’ve created another 2007 DB that connect to tables on that 97 one, and I was able to use the sales_orders from it. But my problem is that I have to run that code that...

but the code is working fine (with Dynaset) under access97!!!

error @ .CreateDynaset Set Temp1_Set = Db.CreateDynaset("SELECT * FROM [Import_ALL] WHERE [order_no]=" & New_S_Set![Order_No]) Compile error: Function or interface marked as restricted, or the function uses an automation type not supported in visual Basic

thanks BOB, The declarations part I have it at the top (General declarations) not within the load procedure. I will make the changes and let you know Thanks guys

it is MS access 2007.

thanks BOB ... sorry i'm new to this forum ... will do next time ;)

now i get an error at DAO.Dynaset!!!! says: Compile error: User-defined type not found here are the variable i have Dim D As Long Dim int_qty As Integer Dim Temp1_Set As DAO.Dynaset Dim Temp2_Set As DAO.Dynaset Dim Temp3_Set As DAO.Dynaset Dim SS As String Dim PI As String NOT DAO.Recordset...

Option Compare Database 'Use database order for string comparisons 'Dim Db As Database Dim New_SO_Set As DAO.Recordset Dim New_SO_PT_Set As DAO.Recordset Dim New_Status_Set As DAO.Recordset ---------------------------------------------------------- Private Sub Form_Load() Dim D As Long Dim...

first of all, Thanks a lot Guys for looking into this @David: the code is old and it used to give me an error at Recordset .. and after changing it to DAO.Recordset it passes that error .. and stops at EOF!! @Spikepl: this code runs at form activate action, and what it should do is open...

i'm using MS access 2007 i get en error at : .... Set Temp1_Set = Db.CreateTableDef("SELECT * FROM [Import_ALL] WHERE [order_no]=" & New_S_Set![Order_No]) If Not Temp1_Set.EOF Then .... Error sayd: Compile error: Method or data member not found