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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.