Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Francis
  • Content: Threads
  • Order by date
  1. Francis

    Best way to automatically generate Visio diagrams

    Hello Visio people I have a product, ControlDraw, which is a diagram based modelling system. People seem to want Visio output, so I am looking into ways to export the diagrams as Visio files. ControlDraw models are databases (Access) and they contain tables and records that define each object...
  2. Francis

    Can't Find Installable ISAM on some iinstallations

    I have a program written with VB6, using DAO and Intrinsic Data control The Setup is written in InstallShield 2008 and includes the MDAC 2.6 merge models. Normally all works fine, but on some of my customers installations (German and Italian but not all of them) it fails as soon as the data...
  3. Francis

    Setting Database Page Locking in DAO3.6

    Can anyone tell me how to set Page-Level Locking for an MDB (Access 2000) via VB6? I want to do this to optimise multiuser performance Thanks
  4. Francis

    Symantec Auto-Protect kills my application

    My software, which has been in use for some years at several sites around the world has recently been prevented from working by Symantec Auto-Protect. It removes a small exe file that downloads a small text file. The software works without it but because the file is missing Windows Installer...
  5. Francis

    Access 97 - 2000 DAO Differences

    I have an application that uses DAO and I have just upgraded from Access 97 to 2000 and DAO 3.51 to DAO 3.6. The application stores files in memo fields in a database using AppendChunk. In the DAO 3.6 version the fields are twice the size as those in the previous version. If I step thru the...
  6. Francis

    Can I use a second HD to mirror the first one

    I have XP pro, and two identical hard disks. At the moment I use the second as a manual backup. Can I set XP up to do this automatically and use RAID and Mirroring to get hot standby. The first HD has several partitions Thanks
  7. Francis

    Use file dialog in Access 2000

    I would like to have a button on an Access form that brings up a file dialog. Specifically I want to get a new file name and then make a new database with that name. I use VB a lot, but there is no common dialog in the Access toolbar. Do I need some reference? Your Help appreciated, thanks.
  8. Francis

    Why should I upgrade to the next VB version

    I did it from VB2 through to VB6. New version, new re-write. However now I do not want to re-write, I just want to go on improving it. I do not need .net to do that. VB6 and it's third party components are wonderful, the computers get faster and faster and my software can go on improving without...
  9. Francis

    Left(fld,len) works in Access97, not in 2000

    I have an Access97 query that calculates a field on the basis of the left n characters of several other fields But it does not work in Access2000. The Left function is not supported. What is the equivalent in 2000, ideally also usable in 97. Thanks
  10. Francis

    Record number in a query

    Simple question I hope. I want to add a calculated field to a query that contains the record number. I have looked in the help but cannot find it. Thanks
  11. Francis

    Access Database Corruption problem

    Scenario: Access database, VB front end , 2-30MB in size, up to 300 tables Multi-user, typically 1 to 5, sometimes 10 users.. What Happens: At one site, the one with most users, there have been occasions when one user cannot open the file, which denies it is Access. Meanwhile other users are...
  12. Francis

    Access Database Corruption problem

    Scenario: Access database, VB front end , 2-30MB in size, up to 300 tables Multi-user, typically 1 to 5, sometimes 10 users.. What Happens: At one site, the one with most users, there have been occasions when one user cannot open the file, which denies it is Access. Meanwhile other users are...
  13. Francis

    Cannot see Dial-up Properties

    On my laptop I cannot see the properties of any of the Dial-up connections. When I right click on a connection and select properties nothing happens So when I need to change one I have to Add a new one. Any suggestions what causes this? My OS is Windows 2000 Professional
  14. Francis

    Build Relationships in VB Code

    My application uses Access to store the users data. When starting a new file it copies a 'Master Database' . Sometimes I update (add tables, fields, Queries or relationships) the Master and then need to update the application files. I have written a routine to do this - it checks the...
  15. Francis

    Word Basic and pictures

    Hello I am trying to use Word Basic to import a collection of picture files into a document, one on each page. I can create the page throws ok and bring in the pictures, but I can only get them all the first page. How can I do this please. Thanks
  16. Francis

    Appending related records to two related tables

    Can anyone help with this?<br>I have two tables, related via an index where the index is an autonumbered field in one of the tables.<br>I then want to append a collection of related records to both tables, retaining the relationships.<br>At present I do this record by record, appending the first...
  17. Francis

    Monitoring GDI, User and System resources

    I need to Monitor GDI, User and System resources to allow my app to warn and go to a safe state before resources run out.<br> Does anyone know how to do this? I have used 16 bit API calls before - GetFreeSystemResources - but I<br> cannot seem to find the 32 bit equivalents<br> Thanks for any help

Part and Inventory Search

Back
Top