Search results

My cellphone provider has a promo for exchanging your current phone with the new iPhone 3G for 20K yen, thats 190 USD or 120 Euros. I love my now-phone, it has a free cell-TV and youtube viewing capabilities. I know the iPhone has no TV whatever in it, I dont even use it anyway so it's no...

The system Im currently working on demands importing a lot of datas from an Oracle Server, and by 'a lot', I mean 50K to 100K volumes of data. Easily enough, I linked the necessary tables onto my mdb file and everything flew perfectly. Unfortunately my boss demanded that I use an UDL file so...

Im trying to format my textboxes that produces currency formatted values to "K" formats. Basically like 25,000 to 25K Can I achive this by just changing the format of the binded textboxes or do I need to code it manually, which ofcourse would mean the textboxes wont be binded anymore. But if I...

I want to copy a table from Oracle through ADODB Connection. I did an early draft of of it but its runs so slow. I have 11 tables: Here's my code: Dim conn As ADODB.Connection Dim cmd As ADODB.Command Dim rst As ADODB.Recordset Dim tblNames(1 To 11) As String Dim newName, InsStr, strModifier...

How can I use it in Access? Please help :D

I have my tables database separated from my app mdb and I connected them through linking. As we all know, everytime you use the db, it bloats, so my Backend.mdb bloated upto 300+MB but then when I tried compacting it through the compact on close from Access, and it shrunk to 15MB! Nice So how...

I have my tables database separated from my app mdb and I connected them through linking. As we all know, everytime you use the db, it bloats, so my Backend.mdb bloated upto 300+MB but then when I tried compacting it through the compact on close from Access, and it shrunk to 15MB! Nice So how...

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

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

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...

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

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...

I have 2 tables TKYOKUMD01 and TTOKUKMD01. So Im supposed to get the records that aint found by this query in the TKYOKUMD01 table: SELECT a.* FROM TKYOKUMD01 a, TTOKUKMD01 b WHERE a.KYOKUSYOCD & a.BUNSITUCD = b.KYOKUSYOCD & b.BUNSITUCD Easy right? All I have to do is use NOT EXISTS Right? So I...

I want to open my udl files programmatically so users can do the changing in just one sandbox. But, the Shell() function seems to only supprt exe files. Is there other ways to do this? PLease help

Im doing this program for a post office and stuff, their DB is Oracle and they want to front end it in Access coz its free or bundled w/ office. Im using the almost fossilized Access 2000, the laptop Im working on is a2.6 ghz Centrino w/ 1024 MB DDR RAM abd 250 GB HD. Now, since that I am...