Search results for query: *

Are you using Redim on any arrays? You may have lost control of the size of one of your arrays. Watch out for error or event logging to arrays. Dimension them with Integers instead of Longs and you will find out soon enough.

You might have some hassles with security on your Outlook. Auto-sending of email is heart of many viruses and microsoft throws up a lot of roadblocks. To make your application work without clicking a lot of "OK" buttons you will have to set your security levels to a low level. . . ...

quicker to program or quicker to run ? Likewise I have been playing around with .Net, but only at home. I can't compare the performance in the home environment. Home machine is faster, database is on the local hard drive etc. .Net seems to have more layers ?? any idea what kind of...

I think I tried the execute from both the connection and the command. The timing comparison was based on the command object execute. Thanks for the tip about the difference. The bigger issue is probably the Jet 4 provider on a Jet 3 db. The 'supports index' and 'supports seek' are both false...

Just a postscript: I converted one of my applications from DAO 3.6 to ADO. The run updates about 8000 records in one table with a long integer primary key and about 10,000 records in another table with a compound index (long integer and a short string). The ADO version takes about 5 times...

not exactly sure what you are up to, but taking a guess . . use 2 public functions in the DLL 1st function public function readFile(thepath as string) as long code . . . . opens the file redims and populates arrays Fieldx(Index) returns the number of records read end function...

Just a desparate long shot . . . Try naming your events something less generic and Windowese than 'Progress' and 'Process'. Maybe a naming conflict . . . A collegue named a public property 'Date' and had no end of problems.

I have encountered the same problem. As far as I know, and I don't know much, you cannot use the Access defined functions outside of the Access application. If you wanted to fire up an Access application as an embedded OLE object it might work; but I would not go there. After struggling with...

I was planning a corporate (a pillar of American capitalism) upgrade from MS Access dBs to server side. The licencing costs for MS SQLServer were breath taking. (and I thought that Bill made his money on 'Age of Empires'). The big boys are nervous about open source. I've been playing around...

I am very much of a newbie wrt MYSQL. I have justed started playing around with MYSQL and a localhost website. I came across the same problem.. I had defined the DSN as 'User' and it tested ok but would not connect via the ASP web page. ("Data source name not found") As a...

your workbook (say MyBook) has a collection .Sheets loop through the collection and test for name I can't remember the code exactly but: function isfound as boolean isfound = false for ic = 0 to mybook.sheets.count if mybook.sheets(ic).name = "DS" the isfound = true next ic...

what are you using instead of DSN ??

from Canada My perception is that everything costs more in the US. We have found that we need to be 20% below the U.S price to compete. Americans are loyal to their own. Outsourcing creates opportunities and niches. A crudely outsourced service may hit a low price point but it leaves gaps...

good info, thanks I was not aware that DAO only worked on old Access/Jet dBs. Given that we will soon be upgrading our dB's to Access 2000 (and SQL Server if we can find the $) I guess it is time to upgrade.

What are the advantages of ADO. I have used DAO for years and only dabbled in ADO. I am thinking of converting my commonly used classes but need a good reason to.

desperation move try the form activate event instead of the form load

2 IP addresses from ISP - DSL Modem - cheap hub/switch - two separate cables to 2 PC's works for me my ISP had a special offer, 2 IP address for every account your ISP might charge you a few $/month but the solution is simple cheap and robust and you can turn off any PC and the other will...

I don't think it is a problem. You have the option to install some server side components, like frontpage extensions, but I don't think your machine will turn into a server without a lot more help from Bill Gates. I have been using VB6 pro regularly since it came out and I have avoided its web...

I have had the read-only thing happen. The cause was burning the projects onto CD's, flying across the continent, then loading the code onto another machine. The CD burn changes everything to read only and the attibute stays after copying to a hard drive. It was a BIG project and a major pain...

I have used this function: The corprate LAN is somewhat tweaked so I am not sure if the call is to a generic NT object, and thus available to you or if it is unique to our NT. I borrowed the code from another application and have used it many times. Hopefully it works. Private Function...