Seeking individual with expert knowledge in MS Access, and VBA? .? Program will involve two components.?
?
**#1:**? ? filter? clients from a combo box to another combo box depending on criteria
?
**#1a.**? Then able to select that specific client with a command button that directs to a? new form which will display client details.
?
**#2.**? Second part is update the clients information as emails are sent to a centralized email inbox.?
?
Project has **VERY** high probability of repeat service from coder if done well.
?
?
## Deliverables
I'm looking into building a very simple database that does only a few things (search for clients, and does an email send/receive function).? ? I’ll break it down into a list so it’s very clear what I’m looking for.?
**Note:**? ? I will provide further details so it’s a fast easy process.? Fast job = win/win for both parties.
**Part 1**(finding/selecting and displaying the client’s information)
·? ? ? ? ? ? ? ? Simple switch board to begin and exit database
·? ? ? ? ? ? ? ? A combo box that lists clients based on a search criteria
·? ? ? ? ? ? ? ? Selecting the client from the list and using a command button to direct to a new form with all of the relevant information of that client
**Part 2** (email)
·? ? ? ? ? ? ? ? Each client sends monthly emails to a MS Outlook inbox.? Depending on the name of the attachment (each client has unique file name they use), the database should update that clients records to indicate the email was received for that month
·? ? ? ? ? ? ? ? If the email is not received by the end of the month an automated email is sent to the client indicating they need to send the attachment ASAP.
·? ? ? ? ? ? ? ? Sometimes clients are late and send two attachments in one month (1 for current and 1 for previous month).? The client will always include the date of the attachment in the file name.? A special field should be made for late attachments received and then should cancel out the record for not receiving attachment the previous month.
·? ? ? ? ? ? ? ? Finally once the email attachment is received it sends the attachment to a folder specifically made for that client.
·? ? ? ? ? ? ? ? Programming should allow for additional clients to be added and function properly through the email system
Note:? attachments are sent from an external email to a shard drive inbox.? Then those attachments are sent to another folder in the inbox on the shard drive.
?
**Update:**? ? August? 30th, 11:00pm Eastern time?
I am going to upload 3-4 pictures tomorrow that will make coders life 100x easier.? This will show exactly how it should look, and what fields i need.? and just make sense of it all.
?
?
?
?
* * *This broadcast message was sent to all bidders on Monday Aug 31, 2009 7:52:55 PM:
Hello everyone, Thank you ALL coders for replying to my bid request. However at this moment of time I must cancel my bid request because the scope and requirements of the project has changed dramatically. Therefore, I will repost a new Access Database / VBA bid request with the changes in the very near future. Thank you all again, and please look forward to my new post either this week or very early next week. Kabiner