Search results

Great work! RuralGuy, Thanks, that was it... somehow the "Access Special keys" was unchecked. I had a database error (crash) that MS Access tried to recover/backup that may have been the culprit. It is now working fine. Thanks for the info. isv_2004

Hi all, Has anyone experienced this problem? Ver: MS Access 2002 (10.6501.6735) SP3 MS Access / MS Visual Basic will not step through the code after I set breakpoints for debug. This has always worked but recently it has stopped? Anyone have any ideas? maybe a hotkey to toggle debug on/off...

Problem Fixed Problem Fixed I reinstalled MS Access .... (again) :D isv_2004

Hi all, (Please, no joke responses) Has anyone experienced this problem? Ver: MS Access 2002 (10.6501.6735) SP3 On a Form; I change from Form view to Design view, when I try to change back to Form view it will not change. It stays in Design view. I did Compact and Repair Database to no...

Thank you SMatthews, Thank you very much, it worked great! ISV_2004

Still need help! Please see the attached file, the Like argument will not work in this example. Anyone?

How do I use a wildcard in a query, see attached .mdb Table "myDATA" Sam and Zeb have serial number 23a4224A and 23a4224 in their records. I want to locate a serial number(s) in multiple fields of a table, based on the users input with a wildcard. query "Serial Number query" Enter Serial...

I cannot figure this out, I have values that need to be calculated in a field but it will not work with null values, I’m sure this is easy but I have not found a solution. Thanks in advance. The attached mdb illustrates my dilemma.

Lagbolt, Thank you! It worked great.

I need help with DoCmd.SendObject to Email, I cannot get a carrige return in the body of the form, HELP please! DoCmd.SendObject acSendForm, "Current_ICS", acFormatXLS, MyValue, , , "Shipping form for ICS# [ " & ICS_NO & " ] ", "1 " & "2 " & "3 " & "4 ", -1 The Email form looks like this...

Still need help! mohammadagul, Thanks for the help, but I still would like to know how to place a variable in the SQL statement from the VB code? in BeforeUpdate I need the value from =DMax("[ICS_NO ]","Shipping") assign it to a Variable such as intICS, and place in the SQL statement: Then...

:confused: I need help! (Sorry for being long winded) I have a Form “Shipping” with an AutoNumber TextBox [ICS_NO] that needs to be incremented by 1 on function NewRecord and cannot waste any numbers. NOTE: (I am responsible for a block of 50 numbers assigned to me by Management of which I...

Malcy, Thank you very much! It worked perfectly :) isv_2004

Help ! I hope this is not too confusing. From the "Assets Form", by clicking a button, I need to open the "Shipping Form" to the record that has same ICS# value. Field names: ICS# Forms: Assets Shipping _______________________ | | Assets Form | | System: _Raven_ | Shipped to: _ICS#_ |...