Search results for query: *

Hi Guys, We have an app which, after a minor update, we've redistributed to users. A Swiss guy (who himself hadn't had the previous version installed that I'm aware of) installs the software fine but on running gets the following error message: System Error &H8007007E (-2147024770). Module...

Hi I know how create an instance of powerpoint and load and manipulate presentations and slides but I now need to show a powerpoint slide in a form and I'm stuck... I've embedded a powerpoint presentation as an OLE object in a form but it shows the first slide. How can I make it show slide x...

Hi I've got an app that is now to be used globally and therefore needs to be made unicode-compliant. I've read that as VB6 controls aren't unicode the best solution appears to be to replace them with the equivalents from the Microsoft Forms 2.0 component (users should have Office installed)...

Hi I have a question I can hope you can help me with... I have a reusable form and want to create a recordset based on the form's recordsource which contains distinct values in one of the fields. So I guesss something like: mySQL = "Select distinctrow JobNumber from " &...

Hi I have a form which on opening comes up with the 'This recordset is not updatable' status if the recordsource is set to a certain query (other simpler queries are updatable...). OK so you'd think the problem is the query is not updatable. But if I go into the recordsource and run the...

Hi I have a front end/back end Access 97 database with c70 users (up to 15 concurrent ATM) which is working fine for users on our site. However we have now got some users at another site using it too and it's very slow for them such that it's becoming a barrier to data entry. Access times to...

Hi I have an Access 97 db whose users will be upgrading to Office 2k or Office XP, depending on where they're sited. I know that Access 2k and Access XP are file compatible so, once I have got over any issues converting the database, users with either version should be able to use the database...

Hi, We have a database in Access 97. Users should all have been using Office 97 and the database worked. Now, most of the users of our database have had Excel/Word/Powerpoint upgraded to Office 2000 (but not Access) for some reason. So I have set the references to the correct version of Word...

Hi guys, I have taken over a program (which graphically shows some analysis of data) which is rather slow and I was wondering if anyone has any tips on making it quicker. On running the program, it reads in a text file using line input (the file contains a header line which explains the...

Hi guys, I have an Access 97 database with a front and back end running over our network. All users at our site can use fine if they have Office 97. Now there is a plan for us to get people at another site to use it as well. So I have a guinea pig (who has office 97) but when they try and go...

Hi guys, I'm using a gantt control (phGantX1) in some Access forms and I have a problem with the fact that Access doesn't have a Printer object. The control comes with some VB example code for printing (VB DOES have a printer object...): Printer.Print "This is a test printout&quot...

Hi How do I name the objects I have on a Powerpoint slide? When I try to set up animations the items are all called Chart 1, text 3 etc. On the other hand if I iterate through the shapes in VB they have names like Object2, Text Box 5. I don't want to do it through VB if I can help it but I...

Hi Having added a few more fields to a few more forms, some users are getting this error message. I've pruned the queries to only required data per form and set some forms to close others if open, which fixes some occurrences. Does anyone have any other tips on how to minimise the...

Hi We have a VB app that produces CSV formatted files. I have done a macro that opens these CSV files and creates charts based on the data therein and it works fine. Only I (in UK) have given this Excel macro to other offices in our group (French, German, Danish, Norwegian, Spanish) to use...

Hi I've got an Access database split front-end and back-end over a network, with potentially 50 users though the max at one time doesn't exceed about 5. I want to distribute the front-end locally as an MDE file, to prevent user modifications and cut down on network traffic. I am, however...