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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by psemianonymous

  1. psemianonymous

    Combining Records in Access to Word Mail Merge

    The short answer is that this is not something Mailmerge is designed for. My first recommendation is that you build a report in Access to build your "letter"--reports have very good support for subgroupings and subreports. The downside is of course, you can't use Word for this. If you...
  2. psemianonymous

    Acces to Word Mail Merge Problem

    If you're going the "pure data" route, I'd recommend you try running the query with all forms closed. You need to be able to run the query without it popping up any parameters or assuming there are any open forms. This is essentially how Word's mailmerge sees Access. I also think (I'm fuzzy...
  3. psemianonymous

    Acces to Word Mail Merge Problem

    If you're comfortable with VBA and SQL, I'd recommend using my Mailmerge code: faq181-5088 If you have complicated requirements (e.g. pull data from the user/a form), dropping into VBA is the only clean way to get this done. If you're not comfortable with VBA, you can instead store the date...
  4. psemianonymous

    Looking for Scheduling Database

    If you're using Exchange/Outlook, you can get the admin to create a shared calendar for each resource, and then have everyone update the shared calendar. This is of course programmable so if they want something even fancier like reports, you can do that as well.
  5. psemianonymous

    Issue with mousewheel

    Try this thread: thread181-1181597 Basically, it says that you can leave the mousewheel on if you use the form events correctly (and how to figure that out).
  6. psemianonymous

    Totally stuck: Database possibly corrupted...

    Check the FAQ I link to below if the above tips don't work. -- Find common answers using Google Groups: http://groups.google.com/groups?group=comp.databases.ms-access Corrupt MDBs FAQ http://www.granite.ab.ca/access/corruptmdbs.htm
  7. psemianonymous

    Looking for search suggestions

    Run the OpenForm code in an error-trapped function and capture the error number. Also you can hide links to forms based on user membership in groups which makes your application more usable (that's what I did). Honestly if I was to go back and do it again, I'd do it all without security if...
  8. psemianonymous

    Access making me loggin on new db

    Are you talking about Access or SQL Server? If you answer my question, I think you won't need your question any longer. -- Find common answers using Google Groups: http://groups.google.com/groups?group=comp.databases.ms-access Corrupt MDBs FAQ http://www.granite.ab.ca/access/corruptmdbs.htm
  9. psemianonymous

    Exporting reports to microsoft word

    Export to word generally doesn't work. Use Export to RTF, and if that doesn't work, get a PDF printer program and print your report to PDF.
  10. psemianonymous

    Record locking?

    Check the folder permissions. If your users can't do "create/delete" operations on the folder, then they will lock the database exclusively. If it's not folder permissions, then I don't know what's going on.
  11. psemianonymous

    Access 2003 sudden crashing problem

    PHV said it all, only I'm going to add just a little: This is an unusual problem. Make sure you are up-to-date with all patches, then try to eliminate your hardware as a problem. There are no likely suspects as this is an unusual case.
  12. psemianonymous

    "Fill out this Form" does not work with Firefox

    Sharepoint was designed to run on the MS Office stack. This means that it works best if you have Office 2003, InfoPath 2003, FrontPage 2003, IE6, Active Directory, Exchange Server, BizTalk and so on. Your attitude toward Mozilla should be 'it's a miracle it works at all'. Think of Sharepoint...
  13. psemianonymous

    Using SQL Server Application Roles with Linked Tables

    My understanding is that you set the role for the user on SQL Server, otherwise the users won't be able to access the data. In other words, from Access, go ahead and leave all the passthrough queries and linked tables, even if that user doesn't have access to them. In other words, Access...
  14. psemianonymous

    Sharepoint User migration

    I'm not an AD expert, but there should be something like a "historic RID" or a "historic SID" or something to that effect that you can copy from the old NT4 accounts to the new AD accounts that will keep the security ... identity for lack of a better word. It's possible. I don't know about a...
  15. psemianonymous

    Disable the copy paste function

    Maybe just use the textbox's BeforeUpdate() event to clean up the string? e.g. Private Sub txt_BeforeUpdate() 'use the .Text property, not .Value on this function only txt.Text = replace(txt.Text, vbcrlf, empty) End Sub That's an extremely (over?)simplified example of what you want to...

Part and Inventory Search

Back
Top