I'm trying to design a database to track life insurance elections. Employees have the option of electing insurance for themselves, their spouse and or...

Hi, I would like to edit a form and a report that currently are ordered by entry date in chronological order to reverse chronological order so that the user...

I need to build a db where I will get information from about twenty different access and excel sources on a network. These sources are updated at various...

Hi everyone, I am trying to manage the holidays of the employees in access and I wondered if there was an easy way to do it, like a multiple-selection...

I have a form (with two sub forms) that users enter details of a new record into. It all works fine except that I want the option to hit 'Cancel' and have...

Hi, I have switched over from Microsoft works database and simply want to sum several fields in a record to a "total" . This was quite easy in works I can...

Hey Guys, I am really desperate to resolve this issue. Below, you will detail information about the problem. I have the calculation working upto calculating...

I calculated downtime using a query and now I need to change negative numbers (not downtime) to zeros. Please let me know how I can do that. Thank you

I have not worked with Access for a while and am stumped. I have a value list for a field in a table. When I develop a form off that table, the entire...

Hi, I am trying to create a database in Access 2003 to get rid of my excel spreadsheets and enhance reporting. I work for a non-profit and have to track...

Hello all, I have Access 2003, but I want to be able to make systems for people who don't have Access. I have the Access2000 run-time programme. Can I make...

I need to be able to convert negative numbers ro zero in query. How do I do that? Thank you

I searched through the database to find out how to do this, but couldn't really find a satisfactory answer (then again, I'm not the brightest bulb in the box!...

I want some form fields to automatically populate with data once another field on the form is filled in. Specifically, I want a city and state to fill in...

Hey Guys, I created a form that have 2 check boxes, one for Pass and the other for Fail. I have both boxes unchecked, however I would like the user to have to...

My users all want their auto-numbers to start with the year....07...and that's going to last for the next two years. I have a text field that I am trying to...

dear sir , i would like to know the code that can exit from the sub form on exit its lost field and return to main form tab 0 field and save the records ...

i'm looking for a way to produce a phone book like template which means i can type in the information i am looking for and it will come up. Similar to how...

i'm relatively new to access and appreciate any help you can give... what i THOUGHT i wanted to do was set up dependent fields, but then read that "In the...

I am trying to build a special data base to track attendence in study groups. ?Sometimes people attend different groups than what they've commmitted to, but...