Recent content by RSGB

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

OK I managed to work out a way to do it myself but it's not the most elegant, basically copy the slide I want to show and delete everything then paste it back in: MasterPres.Slides.Range(3).Copy Do Until MasterPres.Slides.Count = 0 MasterPres.Slides.Range(1).Delete Loop...

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 Another tack is the version of Jet 4.0 which caused me mucho problems - check: MSKB "ACC2000: Access Quits When You Add Data Through a Query After You Upgrade to Jet 4.0 Service Pack 5" Updating Jet 4 to version SP6 fixed this for me... Cheers RSGB

Hi Bruce, This did happen on a couple of machines when we first installed it. It was caused by references not being right e.g. if you have a reference set for Word 2000 but the user has Word 97 (application needed to use early binding). My application had references to DAO 3.51, Word 9 and...

Hi I know but the SQL server can use trusted connection instead of it's own login thing. I've tried it briefly 'cos I'm looking at upsizing the back-end to SQL server from Access. Maybe the SQL database needs to be configured to allow trusted source first... Laterzzz RSGB

Hi I'm not an expert on this at all but when you link the tables you can select "You trusted connection" instead of a login and password I think on NT servers. This uses the network login so bypasses the issue. Hope this helps RSGB

Hi I'm considering this same issue as although the speed for people connecting at my site is fine, now people at another site are using it and it's too slow for them. This is my current thinking: 1) back end to SQL server. Seems to be thought of as the best solution BUT according to...

Hi Thanks for your prompt & helpful replies. Sounds like it's worth trying upsizing the back-end to SQL Server (it would be easier to get a good enough server than improve the bandwidth between the sites!) and giving it a go. If it works then it would be a quicker fix. Regarding taking an...

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 use this in code: DoCmd.SendObject acSendNoObject, , acFormatRTF, "Person 1", "Person 2", , "Title here e.g. ref" & YourReferenceValue, "Put the text of the message here." Need to have a reference to Outlook selected from Tools/References to use...

Hi JennW Thanks for your reply. I was thinking of probably converting to 2000 rather than XP as it would be better to develop on the older of the two versions anyway, and also the issues of conversion to 2000 are well catalogued in these forums. I'm just hoping M$ are right when they say they...