Help

Sharepoint security settings for distributing Access 2010 databasesvia Sharepoint 2010
Anyone know the security settings for sharepoint 2010 relative to using Access Services to distribute an Access database? See posting here http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/8a028a99-a00f-4f08-86a9-98c644c3695d Bob ... 24 Dec 2009 18:23

Ping Tony Toews - AutoFe question
Let's say all users have A2003 and A2007. I guess by using the following it should always start A2003 for the app. ;this is the expected default directory Shell="C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" StartMethod=FIlePath But what does one use if MSAccess.EXE is stored in Shell="C:\Prog... 22 Dec 2009 03:49

frm.OnGotFocus = "[Event Procedure]"
In a class form I am doing the following. Public Property Set Form(FrmIn As Access.Form) Set frm = FrmIn frm.OnGotFocus = "[Event Procedure]" frm.BeforeUpdate = "[Event Procedure]" End Property Private Sub frm_BeforeUpdate(Cancel As Integer) MsgBox "This code is running. :)" End Sub Priv... 21 Dec 2009 12:21

Combo box on an instance of a form
When I open the form normally, ie: From the database window, the combo box works correctly. The query behind the combo box references a field on the form and shows the data. For example: SELECT tblStates.State_name, tblCountries.Country_name FROM tblCountries INNER JOIN tblStates ON tblCountries.ID = tblStates.t... 16 Dec 2009 21:18

Word Merge Problem from Access
Using Word merge from Access 2002 has just started generating the following error: 'word cannot start the converter mswrd632 wpc.(5132)' Has been working fine up till a couple of days ago. Also happening on client PCs using the same program. Anyone else having this problem? Bob Darlington Brisbane ... 3 Jan 2010 18:15

Technique used to rotate text labels when creating a PDF file from Access
This might be of help to some people. I have been producing some PDF reports lately directly from Access using the basic techniques found here: http://groups.google.com/group/comp.databases.ms-access/msg/a49f0ddea9315902 The rotation technique I use below can only be used when Access creates the PDF file dir... 14 Dec 2009 18:49

access97, commitTrans, creates error...
simplied code Dim wrk As DAO.Workspace Dim rs As DAO.Recordset Dim db As DAO.Database Set wrk = DBEngine.Workspaces(0) Set db = wrk(0) wrk.beginTrans strsql = "some valid query" set rs = currentdb.openRecordset(strsql, dbOpenDynaset, dbSeeChanges) wrk.commitTrans error... 8 Dec 2009 16:23

Accdw file and Sharepoint 2010
A nice article: http://dmoffat.wordpress.com/ Scroll down to "Performance Over A VPN Is Very Good in Access 2010 Hybrid App" The next article "Access 2010 And SharePoint � Welcome To The Hybrid Access Application" is also quite good. Here is a link to an Access newsgroup for Office 2010 http://social... 6 Dec 2009 18:20

Using Sharepoint 2010 for data storage but still running full Access client with vba and normal forms
Some time ago, Albert Kallah wrote that with Access 2010 it was possible to store access 2010 data on Sharepoint 2010 but still run the Access client in windows much as a "normal" access client, accessing the data on Sharepoint 2010. "Well, the rich VBA application can sit on your desktop, but the data sits on ... 11 Jan 2010 05:23

printing an existing pdf document within a report
using access97, with a folder of PDF documents, one per item, created by the supplier and provided in pdf form I added an unbound object frame to my report with these settings OLE CLASS = Adobe Acrobat 8.0 DISPLAY TYPE = CONTENT UPDATE OPTIONS = AUTOMATIC OLE TYPE = LINKED CLASS = AcroExch.Document.7... 4 Dec 2009 18:30