Hi all I'm having an extremely difficult time trying to design a database for a Childcare centre. There seems to be a lot of variables, but the...

I am trying to enforce referential integrity on tables where a compound key is implemented. I want to enforce integrity on the DETAIL table so that it can...

Is it possible using the input mask to format all data displayed in a field to Title Case? I've seen that you can use: All characters that...

OK... I have taken your advice and have change my way of thinking and switched from Excel thoughts to Access thoughts. With respect for my scenario of a...

Can anyone assist me in my design? Real world: I am a manufacturer of goods sold to a national retail chain. I have 10 different items in 1800 stores. Every...

If I create my database, can it be shared amoungst users. In other words, we do have a workgroup set up between all of our office personel, with a main...

I want to create an access database. Now from a query that I will be doing every month from MySQL i will be importing an excel sheet. Now on this sheet there...

How do I format a textbox in Access to only take addresses in formats - streets only St., Place only Pl., Avenue only Ave., etc. ? If I am suppose to use the...

Hello, I'm setting up a database that I would like to capture information from multiple spreadsheets. The spreadsheets will contain similar fields, but will...

I work for a therapist. He would like an Access Form that patients can fill out on a touchpad that is essentially a series of about 100 organized check boxes....

I would like to have a form randomly select pictures from say 20 images as one moves from one entry to the next.

For a genealogy/family tree database some dates are approximate. For example: my birthday is exact (January 1, 1970) and my ancestor's is not (just 1760)....

I need to create a table that includes a field that has to have 13 characters (numbers) in it. If the user only enters 9 digits (or 11), it needs to insert...

I have created a table to capture the system date but it will not work. It says there is a "in table-level expression" error. For the date capture, I used...

How do you set a form to spell check a "record" only, without continuing to check the entire database? I want to create a function that checks spelling after a...

How do I go about allowing a user to delete a record from a table. Here is my situation. I have a main menu with command buttons. One of the button reads...

How do I go about allowing a user to delete a record from a table. Here is my situation. I have a main menu with command buttons. One of the button reads...

Is there a way to restrict entry of data to a field on one table depending on what is in a column from another table.. So, my tables...

Hello again. I received notification that there was a response to my earlier question but when I clicked on the link the page was blank. I need to be able to...

why do they have such a complicated method of changing a starting value in an autoincrement field type. Every other normal program allows you to enter...