Recent content by SilentBreaker

Month(date) :D

Or If its text: "SCOfull = " & Chr(34) & CurRec & Chr(34) :D

If the Value type is Date, use this one: DoCmd.RunSQL = "Select..........WHERE.....DateField =" & Chr(35) & dtmDate & Chr(35) If the Value type is String, use this one: DoCmd.RunSQL = "Select..........WHERE.....StringField=" & Chr(34) & strString & Chr(34) If the Value type is Numeric, use...

Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Dirty or Me.NewRecord Then 'add statements '.... '.... 'To cancel the change or new record Cancel = True Else 'accept new or changed record '.... '.... End If Or you can do the other way around Cheers :D

You can do this: strSQL = "Select ........WHERE............Like "*"& Chr(34) & [Enter keyword] & Chr(34) & "*" :D Cheers

Use the ReadBlob and WriteBlob functions. You can search them over the www.microsoft.com....in the Knowledge Support Base or Technical area. Just copy and paste them in your module. Cheers :)

That's a good stuff, mate :D

I'm with you, namliam:)

You still can write VBA with DAO to retrieve data and load them in the list box. :eek: .Overview of DAO Data Access Objects (DAO) enables you to use a programming language to access and manipulate data in local or remote databases, and to manage databases, their objects, and their structure...

try to adjust the sql statements: sql = "Select [C/F], EELoan, Profit, NetProfit, Tax from test" Recordset needs a set of field names for reference :D

Let make it clear. If you have a modal form with a command button and the user click that button to open another modal form. Yes, this does work. But you cannot go back to the previous form until you close the second modal form. Your comments are correct and yes, of course it's a tricky part...

In my MS Access applications, I have no problem with the property of Model set to "Yes".:confused:

This is a good stuff, mate. I have used this often, but not this many forms as five forms. :D

Do not need to write VBA to do this. All you need to set the Form's property of Modal set to "Yes" in the Form Design Mode. That means the user cannot open another form until the opened form is closed. Cheers :)

Please read the ADO and DAO papers available from the www.microsoft.com. You'll know the differrence. If you working with the Multi List box and querydefs, always use the DAO.