Search results

DOP_new is a table i do spell it correctly... thanks

Hi, I am trying to update fields in a table. everything get updated correctly except the field [Modify By] DoCmd.RunSQL "UPDATE DOP_new SET [Modify BY] = '" & Itm_Logged_by & "' where [TrackingID] = " & Me![TrackingID] & ";" DoCmd.RunSQL "Update DOP_new SET [Modify BY] = '" & Itm_Logged_by...

Hi, I would like to enable a button when open another form I tried the following: DoCmd.OpenForm "frm_Create", acNormal, , "[TrackingID] = " & Me![TrackingID], acFormEdit, , Form_frm_Create.cmd_Delete.Enabled = True the above code does work but it can't enable the button. please advise...

SWITCH Function does the work. many thanks

Hi, I received syntax error for the following statement SELECT CASE [File Type] WHEN 'Security' THEN 'SEC' WHEN 'Admin' THEN 'ADM' END AS FT FROM [tbl_Core Non-Core] please advise thanks Alice

Hi, I have a form which RECORD SOURCE (you can find it in the form design) consists the following query : SELECT DOP_new.[Barcode #], DOP_new.[Deal Name], DOP_new.[Client Name], DOP_new.[Reference #], DOP_new.[Document Date], DOP_new.[Document Type], DOP_new.[Number of Documents]...

DateDiff function does the work! thanks

Hi, I would like to compare an input date and current date in a IF statement I have no idea why the following code doesn't work properly If Format(Itm_Date_of_Shipment, "mm/dd/yyyy") >= format(now(), "mm/dd/yyyy") then ' update the table... else ' display error message end if...

thanks.. it works

Hi, I wrote an UPDATE statement in vba which would take and update input date into a table. here is the code: DoCmd.RunSQL "UPDATE DOP_new SET [Shipped] = -1, [Date of Shipment] = " & Itm_Date_of_Shipment & " Where ([Date of Shipment] is null) And [BarCode #] = " & Itm_BarCode & ";" it...