Search results for query: *

VB6 Office 2007 I have a VB6 program that builds fairly complex Word documents. The documents contain: Normal text Hyperlinks to documents stored in a Filenet image archive Command buttons that delete rows from an Oracle database, and also update a SQL Server database Various Subs and...

Hi All, A am about to create an image archive at work. It will initially contain about 520,000 pdf files, ranging in size from 150KB to 550KB, with the mean size being about 240KB. We will be adding about 70,000 new images to the archive every year. The archive will reside on a 500GB Seagate...

Hi, I have a home peer-to-peer network consisting of: 2x Win98 SE 3x WinXP Home 1x Suse Linux 9.2 (with Samba) Running TCP/IP and DHCP via a DLink 808HV NAT Router/ switch/VPN and a cable modem. One of the XP Home machines is an HTPC (SageTV/3x Avermedia 1500), and so is always on. There is a...

Noob to vb.net Trying to install it at home (install worked fine on XP Pro at work). Here at home (Athlon XP 3000+, 512 RAM, 55GB available, XP Home), here's what happens: 1. Inserted VB.Net CD 2. It told me to do prerequisite CD. 3. Installed prerequisites--Framework, J#, Java 4. It told me...

Hi All, Fairly new Compaq/XP Pro SP2. Two CD drives (1 reader/1 burner) Both drives Read UDF CDs and Drag and Drop CDs fine, but cannot even read the label of CDFS disks. Flash the light a bit then just stop. Not too many ideas of how to proceed. Remember I can't read CDFS, so even...

Hi All, Sometime since last week, the masking character in Access SQL on my computer (Access 2003/WinXP SP2) changed from the old standard of asterisk (*) to percent sign (%), like it is in Oracle and SQL. Here's a snippet which DOES NOT WORK: Private Sub del2005() Dim strSQL As String Dim tdf...

Hi Guys, I have a really simple piece of code that concatenates a bunch of CSV files into a single file which I then manipulate in Excel then import into Access. The code is in an Access Sub which has worked in the past, but today, it will not work at all...gives "Error 53 File Not Found" on...

Hi, This will sound dumb, but I've been using VB for about 10 years (since 2.0 release), but have never written a single line of VBScript. I have no idea where to start (can I instantiate objects/forms/create dll's/exe's/use ADO/ole animation/whatever?). Where do I find the interpreter? Could...

Hi, I have a Word document that is created by a VB program through automation. This document contains anywhere from 10 to 200 or so command buttons that I use to delete rows from an Oracle database and update rows in a SQL database (the same button performs both functions). Randomly, for no...

Hi, I notice from time to time that people respond to threads and parts of their responses are in red, or bold, or whatever. I've tried all of the tricks I could think of, including writing a response in Word, highlighting, and pasting it back into the response box. Nothing I've tried works...

Hi, I have 3 big old Microfocus (Workbench) programs (about 20K lines of source each), that do batch loading/editing/reporting on an Oracle 8i database, using Pro*COBOL, Exec SQL;etc. Anyway, I am going to convert these programs to run in NetExpress, because there is no support available for...

Can someone please help me? I need to make an ODBC connection from SQL*PLUS to Access so that I can query/update Access tables. I am not talking about connecting from Access to Oracle--I've been doing that for years. I did this a long time ago, and it worked very well for what I wanted to do...

Does anyone know if there is a way to share a linked Excel spreadsheet between multiple concurrent users? Thanks in advance, Tranman

Hi all, I have a couple of fields that are built up from strings. They are both in YYYYMMDD format. The first one is: YMDA$, and contains a value of "20020220" The second is: YMDB$, and contains a value of "20000315" When I try to compare the two by saying: If...

Hi all, I need to know is there any way to create a select query in a module (ADO, oleDB) that includes columns from both local Access tables and remote Oracle tables in the same query WITHOUT USING LINKED TABLES/ODBC. I already know how to do this with linked tables and DAO or ADO, but I want...

Hi All, I just upgraded from Oracle 7.3 to 8. I have a big query that runs in Access that works fine on a 7.3 server, but fails on the new 8.1 server. Here are the particulars: 3 linked tables Acc 860,817 rows AccCans 294,652 rows AccSumm 860,817 rows one local table SpecFeat 391,495...

Hi all, I have a big Oracle 7.3 database that I need to manipulate with VB. What I am wondering is, if I have an ADO connection object, how do I use it to set the rollback segment, then process a sql statement as a transaction. Something like: cn.execute "Set transaction use rollback...

Hi All, When I open a table (or a query) in datasheet view by double-clicking on it in the database window, the display window is so low on the page and so large that I cannot see the record selector. How do I change the default behavior of this window so I can see the whole thing every time...

Hi All, Let me preface this by saying I am a web rookie, so please keep responses somewhat simple. I have an app whose purpose is to retrieve the html from a web page and parse it into an Access DB. To get to the page, I first have to log in. I have code to fill in the UserId and Pwd on the...

Hi All, I have a system (NT4.0, Access97) where I cannot see ANY activex controls. When I click on the button on my toolbar that has a hammer and wrench, and the tooltip says "More Controls", instead of a list of controls I get a little box about 1cm square with nothing in it. I do...