Recent content by supercharge

Fire the AfterUpdate event of your input box to perform the "enter key" operation. Hope that helps.

Don't get a thing! Rephrase please.

I'd like to learn Cobol too. Any recs on where to find info about it? Thanks

Wow, haven't been in here for several days. If you use my previously attached sample, you won't have any problem adding a Close button just to close the form without saving any data. Just a simple DoCmd.Quit will exit Access. The form I have on there is unbound to any table so it won't save...

Whenever you're ready, just PM me of it if you refer not to go public.

Yes, one is to create the form in VB and compile it to an .exe application or go here if you like to stick with Access. http://www.access-programmers.co.uk/forums/showthread.php?t=100545

Is it possible to strip off all the data and attach it here?

I'm not sure what you mean by "working fine". As I'm understanding of what you're trying to accomplish is that you want to display an hourglass, then launch the Search form. When the search is done, change the mousepointer back to normal. At least that's the logic. The original code you...

You don't even need to ask for password or anything, upon loading the form, get the Windows userID and enable the relevant form for that user only. Of course, this is assuming the db is a shared one.

Now try this - Private Sub Option2_Click() 'DoCmd.Hourglass True 'Changes pointer to an hourglass Screen.Mousepointer = 11 ' 0 is normal DoEvents Dim stDocName As String stDocName = "FrmSearchAssembly" DoCmd.OpenForm stDocName 'DoCmd.Hourglass false 'Resets it to...

Private Sub Option2_Click() DoCmd.Hourglass True 'Changes pointer to an hourglass DoEvents Dim stDocName As String stDocName = "FrmSearchAssembly" DoCmd.OpenForm stDocName DoEvents DoCmd.Hourglass False 'Resets it to the arrow pointer End Sub

Hi SM00000, Here is what you neeed, go here: http://www.access-programmers.co.uk/forums/showthread.php?t=100545

Have you checked its Cycle property? Is it Current Page, Current Record or All Records?

Good! now if you can figure out how to embed pictures in a table then there you go.

A form can only display one record a time. To show all records, you can set its Default View to Continous Forms or Datasheet. Continous forms will give you multiple identical forms showing each record on it. Datasheet is like a table-view of your table. Hope that makes sense.