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: RSGB
  • Order by date
  1. RSGB

    system error - module not found (after install)

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

    embedding slides in a form

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

    embedding slides in a form

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

    Please help replacing listbox with MS Forms 2.0 listbox

    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)...
  5. RSGB

    create recordset from recordsource?

    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 " &...
  6. RSGB

    Updatable query - not updatatable as form's recordset ?

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

    Query works in Jet 3.5.11 and not Jet 4.0

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

    Automatically distributing MDE front-end

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

    Connecting to SQL Database???

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

    Connecting to SQL Database???

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

    Running Access Database from Server with multiple users.

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

    Will upsizing back-end to SQL Server speed performance?

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

    Will upsizing back-end to SQL Server speed performance?

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

    Email with Access

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

    Issues with Access 2k users and XP users in a multi-user environment?

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

    Issues with Access 2k users and XP users in a multi-user environment?

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

    Loading references depending on Access version

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

    Loading references depending on Access version

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

    Is Linking tables the cause of my slow database?

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

    Automatically distributing MDE front-end

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

Part and Inventory Search

Back
Top