Search results

Thanks for your reply Micron. Was able to figure it out after your reply with the following code in from BeforeUpdate Private Sub Form_BeforeUpdate(Cancel As Integer) If ((DCount("DriverID", "queValidDrivers", "[DriverID]= " & Me.txtJourDriver & " And [CerStatus]= 'Valid'")) > 0) Then...

I tried below code in BeforeUpdate but keep receiving errors Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strMsg As String strMsg = "Data has changed." strMsg = strMsg & "Do you want to add New Request?" strMsg = strMsg & "Click Yes to Save or No to Discard changes." If...

Thanks for the suggestion. The attached database is only an example, the one I'm working on will have like 60 drivers from different departments and would like to make it as a textbox if it can be done.

I'm not that good in VBA and trying to get this figure out if you can help with a code or Macro. Attached you can find example of what I'm trying to do. The database have two tables. tblDrivers: with list of all drivers and license expire date tblJourney: Where the journey information is added...

I ended up ditching all the check boxes and replace them with combo boxes with YES/NO. check boxes created nothing but headaches for me.

I have a query to be run by form that contain yes/no checkbox and cannot get it right to function. I did all the combo and text boxes as explained in other thread but couldn't find a way to do the checkboxes.

Thanks guys, you gave me more options to do it. Perfection

[SOLVED] Custom Row Heading Sorting in Crosstab Query! Hi, Been searching this and tried everything I know with no luck I have a table name tblOrder with field OrderID , OrderType and OrderStatus I created a crosstab query to group by OrderType and count the total of orders, opened orders...

I'm trying to have this done but couldn't :( I have multiple combo boxes in a form and I want the user to select the values (Active/Not Active) with double click instead of click and look-up for the value and another click again to select it. Any comments?