Recent content by Cold Zero

  1. C

    Validate one field in form based on query

    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...
  2. C

    Validate one field in form based on query

    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...
  3. C

    Validate one field in form based on query

    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.
  4. C

    Validate one field in form based on query

    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...
  5. C

    Checkbox Query by Form

    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.
  6. C

    Checkbox Query by Form

    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.
  7. C

    Custom Row Heading Sorting in Crosstab Query!

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

    Custom Row Heading Sorting in Crosstab Query!

    [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...
  9. C

    Combo Box value quick selection via double click

    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?
See more
Back
Top Bottom