AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Friday, October 14, 2005

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

4 Comments:

Anonymous Anonymous said...

The link is dead. Is it cached anywhere?

4:23 PM  
Blogger Alex Dybenko said...

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

8:50 AM  
Anonymous Emilia said...

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

3:48 PM  
Blogger Alex Dybenko said...

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

4:59 PM  

Post a Comment

Links to this post:

Create a Link

<< Home