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

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

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

...OK another approach would be to make multiple MDE files of the front end, each labelled with what versions they should be run with, with each having the different combinations of references set. Anyone tried this? Cheers

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 Ruthcali, I've put the code for the dummy database in this thread: thread181-52728 In answer to your question, it copies it over every time, not just when there's a more recent version. This was quicker to do than add in a check whether there is a local version already and then some file...

Hi guys Sorry for the delay in responding!!! Must've accidentally switched off email notification on this one... OK the database users link to merely has an autoexec macro that runs the following function: Function MakeLocalMDE() 'copy latest MDE file on network to c drive and run locally...