I have a form on input of data finds the duplicate feeding and warns. I used DCount function earlier with two text fields it was working perfectly. No I would like to add one more filed which numeric. How Do i go about it.
My fields are : Purchase_Order_Number = Text...
I have several access files created fro each single purpose and formats. I would like to combine them all in single form selecting each from the main form. Is it possible and how?
I have a members list and want to update each member through messaging (email or whatsApp) their registration umber and other instructions.
Is it possible through access. Kindly help.
I have a report which would be exported in to pdf format. I want to include a scanned page after the report and make it as a single pdf file. Is there any way of doing such report.
I have the following codes
Option Explicit
Option Compare Text
Private Const ConRed As Long = vbRed
Private Const ConYellow As Long = vbYellow
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Ord_Supp <> Me.Inv_Supp Then
Me.Ord_Supp.BackColor = ConRed...
I have done that but in report no desired result appears. The report appears in the normal colour only.
I have tried with VBA code and the font colour changes in first two fields. I have another similar fields such as "Ordered Currency" and "Invoiced Currency" , "Ordered Qty" and "Invoiced...
I have a report in which one of the field value (Text) to be highlighted based on the value of the another filed.
My Fields are [Ordered Supplier], [Invoiced Supplier]. If they are not equal should be highlighted with yellow and blue respectively.
I tried with user wizard in...