Reminder System Access 2002

Closed

Objective is to examine a Microsoft access 2002 table named "Contacts" for all birthdays and cause a reminder form to open displaying the data in the table that meet the birthday criteria of x days prior to the current system clock date.

Using Visual Basic in Microsoft access 2002, create a recordset and loop through the recordset for dates appearing in a field named "birthday" in a table named "Contacts".

Compare the Month and Day parts of the dates that appear in the field "birthday" in a table named "Contacts" to the parsed Month and day part of the current system clock date.

If a date is x days prior to the current system clock date, then open an access form named "fmUpcomingBirthdays" and display on that form {Continuous records form} all the data in the table named "Contacts" for each birthday in a field named "birthday" that meet the criteria of X days prior to the system clock date.

Need the SQL select query that parses the Month and day part of the system clock date so that the data in the "birthday" field of table named "Contacts" which contains the full birthday as in "03/05/36" can be parsed and compared th the parsed system clock date.

Also need the SQL query to select the records to be displayed on the form named "fmUpcomingBirthdays".

MORE:

I'm developing a much larger Access 2002 Desktop application, within which the "Birthday" date reminder system is a small part.

I will distribute theAccess 2002 Desktop application as a stand alone Access database, that will run on PC machines without Microsoft Access installed.

I will create an .exe files using Microsoft Office developer addition tool.

I'll make available a second version which will run on PC machines that DO have Microsoft Access installed. That version will simply be an .mde Access file.

I will supply the necessary Access tables and Access forms needed for the project.

END

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

* * *This broadcast message was sent to all bidders on Saturday Sep 23, 2006 10:56:51 AM:

Further project clarification:

I'm developing a much larger Access 2002 Desktop application, within which the "Birthday" / "Anniversary" date reminder system is a small part.

When I complete larger Access 2002 Desktop application I want to distribute it as a stand alone Access database application that will run on PC machines that do not have Microsoft Access installed.

Therefore I will create an .exe files using Microsoft Office developer addition tool.

I'll make available a second version which will run on PC machines that DO have Microsoft Access installed. That version will simply be an .mde Access file.

I will supply the necessary Access tables and Access forms needed for the project.

Sorry that my first definition of project was not more clear. I welcome your questions.

Bob Milburn

## Platform

Iindows 98 or better running on PC computer

Skills: Engineering, Microsoft Access, MySQL, PHP, Software Architecture, Software Testing

See more: web developer contacts, sql developer open source, php developer objective, php developer contacts, parts database access, named query, microsoft visual web developer, microsoft office package, microsoft office access developer, microsoft access web database, microsoft access parts database, microsoft access database developer, hire web developer for small project, hire web developer for 10 days, hire objective c developer, hire microsoft developer, hire microsoft access, hire access developer, engineering needed for computer engineering, definition of software developer, definition of hire, computer developer for hire, access parts database, access developer software, sql microsoft access

Project ID: #3814168

54 freelancers are bidding on average $90 for this job

ksil

See private message.

$102 USD in 14 days
(144 Reviews)
7.7
GetReal

See private message.

$85 USD in 14 days
(311 Reviews)
7.3
pShankar2

See private message.

$85 USD in 14 days
(409 Reviews)
7.1
kmzacks

See private message.

$85 USD in 14 days
(188 Reviews)
6.9
Premshanks

See private message.

$85 USD in 14 days
(349 Reviews)
6.5
dominique1

See private message.

$85 USD in 14 days
(422 Reviews)
6.5
sergiomatteodavw

See private message.

$85 USD in 14 days
(230 Reviews)
6.5
branislavm

See private message.

$85 USD in 14 days
(253 Reviews)
6.4
SanLko

See private message.

$93.5 USD in 14 days
(165 Reviews)
6.2
coder85

See private message.

$85 USD in 14 days
(58 Reviews)
5.9
advantixvw

See private message.

$85 USD in 14 days
(59 Reviews)
5.3
DeanMan

See private message.

$85 USD in 14 days
(68 Reviews)
5.2
jscurless

See private message.

$85 USD in 14 days
(27 Reviews)
5.0
manojshinde78

See private message.

$85 USD in 14 days
(110 Reviews)
5.0
zaj575

See private message.

$85 USD in 14 days
(61 Reviews)
4.7
lerend

See private message.

$85 USD in 14 days
(13 Reviews)
4.3
shraddhamit

See private message.

$127.5 USD in 14 days
(8 Reviews)
4.2
Humanier

See private message.

$85 USD in 14 days
(10 Reviews)
3.8
openmindcon

See private message.

$102 USD in 14 days
(22 Reviews)
3.7
fridaysoft

See private message.

$127.5 USD in 14 days
(8 Reviews)
3.9