My MS Access Blog
Tips, tricks, best practices and more about Microsoft Office Access and Visual Basic for Applications (VBA). Links to great articles and posts around the web plus some things I've learned that I'd like to share.
Here's another version of "how do I prompt the user for a folder name/file name? This one adds additional sophistication. On the folder dialog you can pre-select a folder. On the file dialog you can specify the X and Y coordinates for the dialog box. It's at http://www.lebans.com/callbackbrowser.htm.
See also How to display and to use the File dialog box in Microsoft Access (Oct 2007).
at
10:03 PM | Permalink
|
Tweet this!
| Add This!
| Blog This |
UtterAccess is the web's leading help forum for Microsoft Access. The community of Access enthusiaists who post there provide help to newbies and veterans alike, always in a friendly and supportive manner.
Access 2003 resource Centre on MSDN
Access Developer Portal on MSDN
Allen Browne's tips for Microsoft Access Allen Browne is one of the web's leading authorities on Access. Several of his articles are the standard reference for the topic at hand. Allen is also the most often cited cataloguer of Access bugs and the related work-arounds.
The Access Web This site, established way back in '98, features tips and solutions from several Access MVPs. The code samples posted here are always clean and effective. Often you won't find a lot of text, but you will find code that works. The solutions here are cited all over the web as the best way to get things done.
Stephen Lebans' site is the authority on the web for some types of solutions. It's a site every Access developer should know. You'll find tips, plus downloadable working solutions ranging from zooming images in and out, to disabling the mouse scroll wheel, to a calendar, to creating PDF files. In particular I look to Stephen's site first for advanced topics related to forms and reports, especially interacting with the Windows API.
1 comment:
I have a combo called Subfunction which i have populated based on a query with 3 columns. i just show 1 column. When there is a change here i want to load the cmb_RetFtr with values based on the selection in Subfunction. This requires i retrieve the hidden fields and parametrize the query.
It works the first time. i can retrieve the combo recordset. However on the second change it says "object is invalid or doesn't exit. Can you help me resolve it ?
Dim nTypeId As Integer
Dim sSql As String
Dim rsCmdData As DAO.Recordset
What's wrong with the code below ?
Set rsCmdData = Me.cmb_SubFunction.Recordset
If rsCmdData.RecordCount <> 0 Then
nTypeId = rsCmdData.Fields(1)
End If
sSql = "SELECT distinct RuleTable.[RET/FTR Range], RuleTable.TypeId, RuleTable.ContextId FROM RuleTable" _
& " WHERE (((RuleTable.TypeId)=" & nTypeId & "))"
Me.cmb_RetFtr.Enabled = True
Me.cmb_RetFtr.RowSource = sSql
Me.cmb_RetFtr.BoundColumn = 1
Me.cmb_RetFtr.ColumnCount = 3
Me.cmb_RetFtr.ColumnWidths = "2 in;0;0"
Me.cmb_RetFtr.Requery
Me.cmb_RetFtr = Me.cmb_RetFtr.ItemData(0)
Post a Comment