Recent content by rocky09

Sorry for the late reply. Thank you so much much. I will try and update you.

Hi Thank you very much for your reply. Sorry, the data is a bit sensitive. I will try to get some dummy data. If productA is not in Storedata, it has to copied from ELR table.

I have Two Tables. 1. ELR Table ( ProductID, ProductName, Date of Expire) - Updates every day. 2. StoreData (ProductID, ProductName,Date of Manufacturing,DateofExpires,TotalProducts and Status) My Requirement is to get the New data from ELR Table to to StoreData. Example: ProductA is...

Hi All, I have a Issue System where user can open tickets and input their comments in it. The tables are SQL linked tables. I am trying to implement auto fetch emails by adding a Button. Basically, it will goes to a particular folder "Working" in Outlook and get all the emails which are not...

Excellent. Thank you so much for the doc.

Thank you for the links.

Hi Thank you very much for your reply, So, you are saying I have to move Interviewer details from Interviewer table to Candidate Table?

Greetings, I am by my TL to develop an Recruitment Tool in Access. I tried to make tables and other stuff. But, am not able to find a proper data model. Can any one suggest me a good data model or if any working recruitment sample if possible. Here are some basic needs: * When a Candidate...

@Uncle Gizmo Thank you so much. :)

Greetings, I am building a CRM for my internal team. I would like to look at the CRM's functionality and want to adopt into my crm. If any one has any sample of reference CRM, Please share. Thank you so much in advance,

@Ranman256 Thank you very much for your reply. @CJ_London Yes. I will try to make a routine to pull the data from SQL Server at some interval. Thank you so much for your suggestion.

Greetings, I am trying to build a small CRM Utility which will be using by 6 - 8 members. Basically, it has three tables, one form and few queries. tblemails (some fields will auto populates from outlook) emailsid vehicleno manufacturer receivedon from body subject tbllive This is linked...

Thank you so much. You are a life saver.

Thank you very much for your reply, I am getting an error saying that Variable required - can't assign to this expression at the following line : Len(strFilter - 4

Thank you very much for the reply. But, the First filter only works, the second one is not working.