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!

  • Congratulations Mike Lewis 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: *

  1. mmusick

    Scaling Report to Print to one Page

    I am also trying to scale a report that was designed for A4 paper to print on one page (letter size). Can you use the intScale to accomplish this? I have not had any luck. Thanks!
  2. mmusick

    Rename Secured .mdb and .mdw

    The objective is to save the old (in production) version of both the .mdb and .mdw by renaming them. Then rename the new (tested) version of the .mdb and .mdw by renaming them to what the production version was called. Leave the shortcuts alone. Thanks
  3. mmusick

    Rename Secured .mdb and .mdw

    Will renaming a .mdb and the corresponding .mdw cause problems? I have multiple users accessing a secured database using a shortcut copied to their desktop. I want to replace both the .mdb and .mdw with new and not change the shortcut. Is there a way to accomplish this?
  4. mmusick

    NT Folder Rights - Secured Database

    Thanks. That is the information I was looking for.
  5. mmusick

    NT Folder Rights - Secured Database

    If other users don't need the db, they will not have any rights to the folder. There will be other items within the folder that I don't want a user that has access to the db to be able to delete. Am I missing something obvious? Thank You.
  6. mmusick

    NT Folder Rights - Secured Database

    All - If an Access database has security established (mdw), what type of NT rights to the folder (where the database and mdw reside) will the users need? I have Access groups established with basically read privileges, and read/write privileges. I would like have their NT rights limited as...
  7. mmusick

    Query recordset

    All, I was having the same problem too, and this post was a great find! Thanks. One related question. My initial query was so large that I created another query to test with that included only the expressions with parameters. Can someone explain why in my original query the replace will...
  8. mmusick

    Multiple Command Parameters

    The report is now accepting parameters (don’t have to create 6 copies of basically the same thing). I have another question: I’m also trying to graph the information, in essence the same as the cross-tab. As I stated, the cross tab has column Idate (for each week), row of type, and summarized...
  9. mmusick

    Multiple Command Parameters

    Thanks to everyone for your suggestions. I'll try them today.
  10. mmusick

    Multiple Command Parameters

    I’m new (10 days) to crystal reports V10 and need some help on the following. I have two Oracle tables that I built the following command to use as the record source for my report: SELECT F1 as Idate, F2 , F3 , 'TEXT1' as type FROM a WHERE F5 in ('67','43','64','49') AND F6...
  11. mmusick

    Slow after compact?

    We have an mdb w/ internal data, running remotely. Before and after compact - a query of records used to take 4 seconds is now approaching 40. The sql is selected from an ini file based on 4 passed parameters and the output is a csv file feeding another application. I am not familiar with the...
  12. mmusick

    Visual Basic Versus Access Project

    Any comments if the backend is not SQL Server, but Oracle?
  13. mmusick

    How to avoid corruption or changes to a database by other users?

    jfgambit, Can you please send me a copy of your database? This is something I've wanted to do and finally found the correct post. Thanks! Send to mpavlidis@atekton.com

Part and Inventory Search

Back
Top