Search results

Dear All! I need help from all experts i have Month Table (MonthID, MonthName) I want to change MonthID in another form combo box Like if current date is Ist Jan to 31st Jan (Month ID Is 1) if Current Date changes to 1st Feb (MonthID should change to 2) Regards

Ok i figured it out used Conditional formatting instead works perfectly.

It worked issue is text box is on dashboard and that form always stays open so the changes appear after i close and open Dashboard what i want is to changes to appear on dashboard without the need to open and close form

yes

ok i'l try to explain with Unmatched Query i get records TC1 is Text Box on Dashboard (Dcount in Control Source) TC2 is Text Box on Dashboard (TC1 &"Some Statement") TC3 is Command Btn (Open Form Customers to Deal with unmatched Records) Vba code in Dashboard On Load Event I just want to show...

Need one more suggestion i hide text box with if statement only visible when dcount>1 but this text box is on Dashboard Form which is always open after dealing with unmatched records when i click Dashboard Form nothing happens unless i close and open Dashboard what should i do ? Code: Private...

Thanks everyone for your time and effort , with Dcount IF Statement And Concatenation I achieved desired results By Showing unmatched records in a Form gives more control and flexibility.

Thx Pat will definitely try your solution

Yes i want Record ID in msg box

Yes i can do both but i want a reminder a msg box to show unmatched records is it possible?

Yes i am getting results with unmatched query

Hello everyone I m working on a small project can anyone help me with a vba code to identify unmatched records between 2 Data Tables and remind user through msg box to resolve the problem and it would be really helpful if msg box show which records are unmatched

Works Perfectly , Thx a alot

much appreciated

Thx Isaac for your swift reply if you can help with the complete code i know basic vba

Hello, I am using Access for sometime now i need help regarding subform selection. I have Customer Main Form with subform linked with customer ID. Subform includes 5 fields Email ID Customer ID Email Type (Combo box with selections "Work", "Personal") Email Address Primary (Yes/No Field)...