TO easily select the lookup items in a combobox I put a text box over the combobox on my form with the arrow showing.
Choose format - send to back for the combobox.
Data will be entered in the text but completed by the lookup using these events -
Private Sub citieslkp_AfterUpdate()...
I think you just might need to like the form duplicates to the data you want to review. Here's a revision of your code to try. Hope it helps :)
Private Sub TheirClaimNumber_BeforeUpdate(Cancel As Integer)
Dim stLinkCriteria As String
stLinkCriteria =...
Is it office 2000? In access 2000 there is a NETWORKDAYS and a WORKDAY function that would seem to be a help.
NETWORKDAYS returns the number of whole working days between a start and end date, excluding weekends and any identified holidays.
If this function returns the #NAME? error value, you...
Then only thing I can think of is to do a search on the code for the entire database to see if the programmer sets a bookmark anywhere. Hope it helps!!
You can use the KeyPreview property to specify whether the form-level keyboard event procedures are invoked before a control's keyboard event procedures (KeyDown, KeyUp, and KeyPress).
You can set the KeyPreview property by using the form's property sheet, a macro, or Visual Basic.
You can set...
Create a blank Access database.
Right click and choose Import.
Change the file extension to .xls for excel.
The Import wizard should appear and walk you through the rest of the way.
the easiest way to customize the menu for the single DB is to create a new menu within the database at the top of the page using icons or buttons and creating OnClick event procedures.The button is the easiest way since the wizard pops up once you draw the button and will walk you through the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.