Recent content by 1127

Hi, I had the same problem. If you know, the Access has a lot of properties that has to be declared to work! For ex. the "AllowBypassKey" property! Or the "AllowShortcutMenus" propety! Once you declare this kind of property you can't declar it again - you will receive an...

Why You use a declared recordset? Why don't just search on the frmmain.recordsetclone The whole code don't have logic You set up a recordset with the form's recordsetclone, search for something and after that you bookmark the first recorset. By the way. After You find the record save the ID...

After You set up the source of the list box (lst.rowsource=sqlstr) You can use the same variable for the next list or combo. After You set up the source for a listbox You don't need anymore the data saved in the variable because the source of the listbox it's setted and he dont use the variable...

Sorry rst![Field]=FormatNumber(Nz(txtbox),2) By the way...where You validate the data?

Where You validate the txtbox value query it like this: If Len(Nz(txtbox))=0 then If its true nothing vas entered. If Your txtbox needs a number in the AfterUpdate say this if Isnumeric(FormatNumber(Nz(txtbox),2))=0 then txtbox="" Check out the IsNumeric and the FormatNumber...

RecordID=(Request....)=vbchecked If You want to know the value for a chackbox press F2 and search for vbchecked

and in the SQL string pass trough de data as string.

use FormatDateTime function

Hi, Whatch out with the dot evaluation. The whole story will be wrong if the decimal separator is "," Tibi

Hi, Once You declared the conection New You don't have to Set it in Your MakeConection sub. After You close the application check if the DER.ldb disapers!? What is the version of ADO. I 've experienced somthing like this with ADO 2.6 and ADO 2.7. Use ADO 2.5. Tibi

Hi, when the checkbox is changing the it's value the ItemCheck event fires. Best regards, Tibi

Hi, The answare is short: NO! It's only to save typing. But like every "cosmetics" it's slower. Think! How can be faster??? Tibi

Hi, Use Me.Refresh or Me.Label1.Refresh. The doevents it's dangerouse when You operates with data!!! Read about the doevents in Your help! Also read about the Refresh method! Tibi

Close the Excel application and then set the Excel object to nothing. xlsApp.Close Set xlsApp=nothing Tibi

Hi, delmardog's right but there is a more cool function: FormatDateTime Tibi