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
The link is dead. Is it cached anywhere?
ReplyDeleteHi,
ReplyDeleteunfortunatelly - 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,
ReplyDeleteSpeaking 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,
ReplyDeletei 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