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 Chriss Miller 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. asp3232

    Best way to improve performance on a form?

    Quick follow-up to my previous post -- I took a quick look at pass-through queries, and it appears that they will only talk to an ODBC server (such as SQL server), and our back-end database only lives on a network shared directory as a file, not as something that has a server running. Is there...
  2. asp3232

    Best way to improve performance on a form?

    Hi ssecca, Thanks for your reply. Please clarify what you mean by "pass through queries" and "moduleless forms" Thanks! asp
  3. asp3232

    Best way to improve performance on a form?

    Ok, unfortunately, the indexing doesn't seem to make much of an appreciable difference on the speed of changing records when the filter and/or sort is active (still 3 or 4 seconds). And I didn't have any NAMEAUTOCORRECT boxes on options/general (I'm on 97 -- are they somewhere else?) The...
  4. asp3232

    Best way to improve performance on a form?

    Hi all, A little background: my database has a main table of projects with about 275 records (with about 40 fields per record), and each record is linked with 0 to 10 additional issue records in another table (depending on the project). I've got a form for entering and modifying the data...
  5. asp3232

    How to get "Sender" to show up in Explorer for Outlook messages?

    Hi all, Since this is a question related to Windows Explorer, I hope this is the correct forum! In trying to make my Outlook messages more bearable, I wanted to try to save the individual messages directly on the disk in their own directory (rather than using .pst files). Outlook lets me drag...
  6. asp3232

    How to save user preferences?

    Thanks for the reminder -- I had forgotten about being able to get the login ID without using access security -- that's almost certainly the best way to do it, and I'll put the table in the back-end db. Could you please post the code/other ideas for how to get the login ID? I'd really...
  7. asp3232

    How to save user preferences?

    Hi, I've got a DB that multiple people access, and would like to have a flexible way for them to have a query that they can easily input the parameters for (such as looking for their own name in the contact information, etc). I know I can do this directly in the query, having it prompt them...
  8. asp3232

    URGENT -- How to save from a web to local disk?

    Hi, I'm fairly new to FrontPage, and have a bunch of pages on a development server. So far, all is going well. However, I just found out that later today the development server will be inaccessible for about a week and a half, and I'd like to be able to continue to develop on my local...
  9. asp3232

    How do I fake frames on pages to get consistent layout?

    Hi, I know this may sound like a bizarre question, but our corporate IT group is not allowing frames on pages, so the standard way of doing it is to create tables to do the layout. A typical page will include a standard module that has a "tabbed-style" navigation bar across the...
  10. asp3232

    Restrict/allow File Access

    Hi, I've got some files on a network share drive, and we'd like to have everyone be able to read them, but only a select few be able to write/modify them. I've used the security tab on the files and can't seem to get it to work. What I've done is used the "everyone" group and set...
  11. asp3232

    Why is 97 front-end much faster than 2k?

    Hi, I've got an Access97 DB that I've split into frontend/backend databases, which works fine. Since about half of the people accessing the db are on Access2k, I converted the frontend to 2k also, so both types of users can operate natively (the backend is in 97 format, of course). However...
  12. asp3232

    How to create a field based on other fields in a query

    Thanks! That does what I was looking for! asp
  13. asp3232

    How to get multiple running selective counts?

    Hi, I've got a report that's almost where I need it to be, but need some summary information on it that I'm not sure how to accumulate. Here's the situation: I've got multiple Organizations (I'll use 2 for simplicity -- call them AA and BB), each with Divisions (call them A and B). Each of...
  14. asp3232

    How to create a field based on other fields in a query

    Hi, I need to create a field in a query that will be a logical "OR" of other fields -- for example, if I have a table with the following structure: Name Issue1 Issue2 Issue3 I'd like a query that will return Name HasIssues where HasIssues is True if any of the issues exists, False...
  15. asp3232

    MDE vs MDB for front/back -- is it critical? (reports)

    Ok, the access security sounds like a good idea. What about the mde vs mdb issue? Thanks for your reply! asp
  16. asp3232

    MDE vs MDB for front/back -- is it critical? (reports)

    Hi all, I've got a DB that has about 5-10 users, some with access97 and some with access2000. The DB is in 97 format, which has caused a little trouble with the 2000 users. I've heard that splitting the DB into a frontend/backend makes for a much more robust database, so I did that and it...
  17. asp3232

    Securing DB makes "Dim rs as Recordset" break!

    That did it! Thanks a bunch! asp
  18. asp3232

    Securing DB makes "Dim rs as Recordset" break!

    Hi, I just started trying to secure a database, which seemed to work well, and then wanted to convert it to a front end/back end arrangement. So I ran the database splitter -- no problems encountered. Then I tried to make the .mde file, and got an error on one of my functions that the...
  19. asp3232

    User Permissions

    What is the best way to propagate the mdw file? I've just started setting up a DB for secure access, and have the mdw file locally on my machine. Since the DB will eventually live on a network drive,what is the best strategy for giving others access to the mdw file? Thanks! asp
  20. asp3232

    How to save user preferences?

    Hi folks! I just inherited a DB that is used by about 10-20 different people, and each one in the past has created their own queries and reports (many of them very similar to each other, but with slight differences, such as filtering on different names, projects, etc). I've changed the DB...

Part and Inventory Search

Back
Top