In Progress

Access 2007 Programming

I have been developing an Access 2007 database to support data collection.

The database has a table for communities, then related tables for aspects of that community (for example, a table of schools, which has a row for each school in the community).

The user interface has a main form where the user can select a community. Then there is a series of tabs. So there is a schools tab, where the user is presented with a list of schools for the community. The user can select one and open it for editing, or create a new one. A detail form is shown, with "Save" and "Cancel" buttons.

I'm having 2 issues that I'm seeking help with. So this project is related to helping to resolve these 2 specific issues, but really I'm looking for an expert Access 2007 developer that I can turn to with similar questions in the future.

Issue 1: I have a currency field in the database, let's say "School Budget" for example. When I'm in the Schools list, and I edit that field with a non-currency value, I get a beep and an error message displayed. But when I'm on the detail form for the school, I get no feedback about the bad value – I just can't tab or enter off the field, or click any other buttons on the form until I change the value to a currency. I'd like the error checking on the value to work like it does on the list view.

Issue 2: Whenever I load the application, or click on one of the tabs, it creates new blank records in the database. So I wind up with a lot of empty school records. I'd like to not have it create new records except when "Save" is pressed on the detail view.

I'm looking to select someone quickly to work with, so please respond with at least one sample of Access 2007 code that you have developed, preferable code rather than macros.

Skills: Microsoft Access

See more: access 2007 programming, programming access 2007, access 2007 form programming, form programming access 2007, with communities, up programming, the future of programming, s programming, school 2007, programming schools, programming macros, programming in access database, programming in access, programming expert, programming error, programming developer, programming database, programming community, programming change, programming access database, microsoft access programming, microsoft access expert help, microsoft access database developer, macros expert, looking for access developer

About the Employer:
( 4 reviews ) Boston, United States

Project ID: #815664

Awarded to:


Please check PM

$30 USD in 1 day
(17 Reviews)

18 freelancers are bidding on average $62 for this job


Please check PM!

$99 USD in 3 days
(49 Reviews)

Professional software developer with over 10 years experience. Please see PM

$50 USD in 1 day
(30 Reviews)

Hi, I have long experience with Access. Plz check PM Regards, Hussien Sharaf

$120 USD in 3 days
(21 Reviews)

Can do it quickly and perfectly. Great experience in this area. Samples will be sent over PM at first opportunity tomorrow. Regards, Al

$49 USD in 1 day
(33 Reviews)

Hello Ready to start right now. Please see your PMB for details. Thanks

$30 USD in 1 day
(25 Reviews)

I just completed one MS Access 2007 program. You can check my review for that project. I don’t need to tell you more about my capabilities just check all my reviews.

$80 USD in 1 day
(6 Reviews)

Please see PMB

$50 USD in 1 day
(0 Reviews)

Please see pmb for more details

$75 USD in 3 days
(0 Reviews)

I am interested in this project.

$30 USD in 3 days
(0 Reviews)

Please check PM. Thanks

$55 USD in 0 days
(0 Reviews)

Sir, I am an IT Professional Having 8 years of working experience in Data Operations Management & Systems Implementations by using Databases, Applications and Web Based Tools. Currently Deployed as Asst Manage More

$55 USD in 10 days
(0 Reviews)

I have worked on 85 MS access database projects with extensive visual basic coding in them and happy customers.

$75 USD in 2 days
(0 Reviews)

please check PM

$50 USD in 1 day
(0 Reviews)

I am ready to start immediately.

$50 USD in 3 days
(0 Reviews)

Please See PM

$75 USD in 0 days
(0 Reviews)

Hi there, I am an ms access database guru and can easily do the job. I can start asap. Regards

$110 USD in 1 day
(0 Reviews)

hi, i can do your [url removed, login to view] start work...

$30 USD in 1 day
(0 Reviews)