Search results for query: *

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

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

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

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.

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

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

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

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

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.

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.

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.

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

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

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

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

The simplest answer to this is: As long as you're the only user with write ability, you can have a large number of read-only users. To ensure everyone else is set as read-only, have someone set the folder permissions to limit everyone to read-only access and set you in a privileged group with...

What he's saying is that the error message he's getting has nothing to do with the actual problem. I'm glad to see you've looked at everything on the FAQ; unfortunately I don't think you've got much hope. I assume you've tried the trick of opening a new database (e.g. db1.mdb) and attempted to...

Check the Corrupt MDBs FAQ (link below); it has a lot of excellent possible solutions. You may be able to partially recover the data and forms. -- Find common answers using Google Groups: http://groups.google.com/groups?group=comp.databases.ms-access Corrupt MDBs FAQ...

Docmd.Setwarnings false ... then when you're done, Docmd.setwarnings true

I guess you're already in trouble for this project. The point is that you should expect more support. If they don't spend the $800 on the tool, they'll end up paying you $800 more, one hour at a time, as you try to work around the constraint. Anyway, the next time someone asks for someone...