Recent content by lblastick

If you choose Tools, STartup, Advanced, disable 'Use Access special Keys' Hope this helps.

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()...

Or you could create a 'Find Unmatched' query. I find using the wizard makes it less confusing. Hope it helps :)

if you change the table where the data is stored to format mm/yyyy it should work :)

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 =...

Have you tried to make an MDE file. Choose tools - Database Utilities - Make MDE file

Try using the DateDiff function. Example - DaysElapsed: DateDiff("y", [OrderDate], [ShippedDate])

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!!

I had the same problem. Are you using Access 97 or 2000? Did you install the mousewheel.dll file on the computer you are using??

You can change the way that the form is loaded by changing the startup properties off of tools on the menubar. Hope this helps you :)

Just a thought of something to check - on the form properties, under other - make sure the cycle is set to current record. Hope this helps :)

Are you using 97 or 2000?

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.