Search results for query: *

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

Hi, The eassyest way to build up a connection string is to put an ADO control to Your form and set up the conection with it. After that You just copy the connection string from it and You can remove the control.

The database it's accessed at same time by more then one user?

"CustomerNumber = '"& Me!CustomerNumber& "' And OrderNumber = '"& Me!OrSub.Form!OrderNumber & "'" The CustomerNumber and the OrderNumber are really numbers? If yes then don't use ' And beatween the CustomerNumber and & leave a space "CustomerNumber =...

Hi, I suggest to try not pass parameters but change the whole sql string of the query!!!!! You have to use the DAO object (references), declare a QueryDef object, set up this object with the query what is the source of Your report and just change the SQL of the query! In this way You don't...

Hi, You can get the ID (autonum) value: 1. If You use mdb right before the UpdateBatch method lngID=rst![ID] rst.UpdateBatch 2. If You work with SQL right after the UpdateBatch rst.UpdateBatch lngID=rst![ID] Tibi