Want to use VBA UserForms in Access?
Access forms works fine form most of the cases, but could happen that you need a VBA form in your project, say you have already designed one for Excel application, and want to use the same in Access. Garry Robinson published a nice trick - A Different Type Of Access Form - The UserForm
posted by Alex Dybenko | 10:14
4 Comments:
The link is dead. Is it cached anywhere?
Hi,
unfortunatelly - author confirmed that he removed the page. here some more pages which discuss VBA forms:
http://www.fontstuff.com/vba/vbatut09b.htm
http://usa.autodesk.com/adsk/servlet/item?siteID=123112&id=3027392
Hi Alex,
Speaking of user forms, I happen to work on a project that currently got pretty stuck in a dead end.
I was wandering if it is possible to design a form in Access that would enable users to copy a column of references from an XL, paste them in the form and then run a bulk search for records matching the introduced references.
The quiery should address to a specific column in the database (Access 2007)
I just need to know if this is possible, in order to know if I should continue searching for a solution.
Sorry for bothering you and Spasibo Bol'shoe!
Emilia
Hi Emilia,
i did something like this, but i allowed user to paste certain number of columns into local table:
If adh_apiIsClipboardFormatAvailable(CF_DIF) Then
dbs.Execute "Delete * from ltblBudgetPaste"
DoCmd.OpenTable "ltblBudgetPaste", acViewNormal
DoCmd.RunCommand acCmdSelectAllRecords
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdPaste
DoCmd.SetWarnings True
DoCmd.Close acTable, "ltblBudgetPaste"
Else
MsgBox "Not a valid format in clipboard!", vbExclamation
End If
Post a Comment
<< Home