Search results

I can see you're stuck either w/ a japanese company or a jap bought PC, ....or both, like me :D Welcome to my life

How can I use certificates?　And how can I disable the "shift + click/enter to enter design view" thing? Please help

Ehehehe I would do that if he wasnt my boss hahaha. Anyway, I already made a work around to it weeks ago, but its sooo damn slow! I mean really really slow. It takes me 7 mins tops to transfer 70K datas. I mean, back then in SQL I can transfer 150K + datas in less than a minute because of the...

Umm they want the Oracle tables to be set through a UDL file, so I cant like the tables to the access page coz, they dont like um.. ODBC :( Is there something like an OPENQUERY() equivalent to access? In SQL you can use.. INSERT INTO tbl1 OPENQUERY(<connectionstring here>, <sql syntax here>)...

I was wondering if you can an INSERT SELECT statement for 2 tables w/ different data source? Like one's from Oracle and the other's from Access? Please help :D

YEY!! It worked, thanks so much :( Sadly I already made the manual version :(( So I guess I have to redo it again, hehehehe but no worries, thanks so much!

Oh umm I already figured it out HAHAHA It seems that you can actually make an ErrObject here, hence I can do: public sub errHandler(byval aa as errorobject) msgbox aa.description end sub ANd I can call it by: on error goto die code . . . die: errhandler err It worked YAY!! thanks anyway

I made an error Catching function where in I take all the err.numbers and output their respective descriptions. Problem is, I cant seem to pass my parameter into another error variable. I've tried: Dim dError as Error dError = <the passed error number> so like: Dim dErrorCatcher(errNum as...

I have a w/ problem with TransferSpreadsheet, although it does the work fine but the thing is, I want to use the Tags not the original field name in the exported file. My table's fieldnames are all numerical (semi-numerical J) to speed up the coding process, like "AATC0001" or "BC00439" and...

Sir Im not trying to be an a-hole or anything, its just, well I had knowledge of that approach alreadey... I do appreciate your help by the way, but unfortunately, I wasnt able to utilize it... If I oppressed you or you felt offended, I apologize, and I'll try to explain or reply much better...

Umm... sir I already know that :( The one I was aiming for was the programmatical approach :( sorry and thanks

Ummm I tried this "TransferSpreadsheet" method, the code went: Dim tdf as TableDef For Each tdf In CurrentDb DoCmd.TransferSpreadsheet acExport, 8, tdf.Name, strSaveFileName Next All is good except the headers on the excel file (signifying the fieldnames), are all in original fieldnames...

Is there a way i can copy tables from an Oracle server to my Access DB programmatically? Tables, fields, datas and all. Thank you

Ok, I know its easy to export tables, queries and reports in excels files, but I cant export an excel file for all the tables in just one xls files with multiple sheets. How can I do this? Please please help

and yet people are still part of this cult!? ........ stupid mammals....... sorry for the word, but who doesnt think they 'are' anyway!?

I saw this South Park episode about Scientology, it pretty much sumed up all their BS, ....accurately. It was hilarious!! I just cant imagine myself believing to such bullcrap. How can they!?

I have 2 databases, one inbound to access and the other to Oracle. Now the customer wants me to synchronize the databases by click a button, so I did, it wasnt very difficult anyway. The approach I used was programmmatically. Like each rows are inserted to the Oracle tables. It works but time...

My girlfriend said I work too much, so she bought me an Xbox 360 for Christmas (35K yen sale :D). Hahaha I didnt touch it first coz I wasnt a gaming person. Then I saw this Oblivion trailer in youtube and got Wowed. T'was ala Lord of the Rings, only there aint no hobbits :D I got hooked, and...

Unfortunately there are no indexes to beging with. The datas are from Oracle by this Post Office (yuubinkyoku). Even though there are relationships written for it in Oracle, most of it are impossible to execute in Access so I have to do the restrictions manually. W/c I already did thank God...

Worked, Thanks!