I have 2 calulated controls on a form with Dsums in them how do I add them together when one is null some times control A is null, some times contol B is...

When the user opens a form, the cursor is positioned in a Combo Box. When the user makes a selection and presses Enter, the cursor moves to another field...

Has anyone created a database, etc. in Access that would allow one to create a simple timeline schedule for ships, rigs and have them display on a simple...

Hello. I have an Access 2007 database that is currently used by three to five people. I have an unbound entry form that is used to enter data, and on this...

I have a memo field that is tracking the history of action items. I want to create a field called "Last Update". I want to be able to enter information in...

I'd like to run this 'design' of mine past the readers of this sub-group's... Here's the "BIG PICTURE" - a bunch of patients (ID) had Magnetic Reasonance...

I have enforced referential integrity in my relationships. However, it seems to cause a problem if I want to leave a field blank! One of my tables is...

I have searched in vain for hints on how to store date information about repeating events: birthdays, anniversaries, meetings held on the second tues. of...

I have a fairly simply database. Vendors have Sites and Sites have Site Visits My user wants me to give her a form so she can take a set of Sites that are...

Hello, Can you give me a plain description of the difference between Composite Keys and Primary and Secondary keys? I thank you for taking time to help...

all I get is the following: Object or class does not support the set of events. There are "apparent" no missing references. Each time I open the...

Hello All, I am using Allen Browne's example database sample "Human" http://allenbrowne.com/AppHuman.html as a starting point for a database that I am...

I use this to test my databases on a copy of the backend, then use the linked table manager to change them back to the real back end. All I can find is how...

I am an administrator and I have designed a small database which will be used by my colleagues at work. It's nothing brilliant but I'm confident it more or...

I am moving my backend to a server with SBS 2003. What is the best way to configure the database on the server and on each client? I need remote access to...

I have 6 tables. All 6 tables have the arrow and asterisk at the bottom, meaning they are editable and you can add records. I have autonumber primary keys...

I'm a database newb, so please forgive the following, potential stupid, question. We have research trips that we participate in, collecting data every few...

I am a bit confused by my relationships and keys. Perhaps someone could help! My database contains information about sites. The sites will contain houses. I...

Hi I have run out of fields in my main table, there is to much data to use the Access table splitter. It just keeps crashing with error message not enough...

Hi, I've gotten user and management requests to accommodate new data in a quote system I've developed. I imagine that I need to take historical data from the...