Monday, November 30, 2009
Wednesday, November 25, 2009
|The Access Unlimited Newsletter|
Produced by Garry Robinson, Microsoft Access MVP.
Hello Access and Office Professionals and anyone else who wants to listen
This month I traveled to OfficeDevCon in Brisbane to see and hear more about the tools that I work with day and day out and I liked what I saw in Access 2010. What really stood out in the Access 2010 talks is the amount of lolly ($$$) Microsoft is putting into Access. Firstly there is going to be Access Services that runs in the Web (read SharePoint) and it looks pretty compelling. Will it take off? History shows that most New Features through last decade flopped but if this one is big with SharePoint centric IT departments, it could be a winner. Another thing in 2010s favour is that it is 2nd Generation so IT departments cannot hold off for another release.
Wednesday, November 18, 2009
Thursday, November 12, 2009
Private Sub cboLive_Click()
Dim tbl As DAO.TableDef
For Each tbl In CurrentDb.TableDefs
If Right$(tbl.Name, 1) = "1" Then
tbl.Name = "MyPrefix_" & Left$(tbl.Name, Len(tbl.Name) - 1)
Here is a similar post for removing DBO prefix for SQL linking.