I have Access 2007,I'm trying to learn how to build simple Data bases,so I started one it doesn't look or works the way I wanted,I just want to delete the...

With the help of Allen Brown we've come up with this idea. Here's a simpler suggestion that identifies country, state/province + country, and city +...

I feel like there's a simple answer which eludes me. I'm trying to make it so that a person can only have one preferred...

The company needs me to merge two spreadsheets from two different departments and put them into a database all can use. Both spreadsheets have over...

BACKGROUND The current challenge I have in MS Access in really giving me a headache. I can’t seem to find an answer or indeed think “outside the box�...

I need to (from within Access) 1. Open a document scanning software so that a document can be scanned; and then, after scanning, record the file name of the...

Hello all: I have a quick question. If I make a table that I don't want others to see, I can hide it by going to: Right click...

This is my first post to this group so I would like to first say hello and thanks in advance. My name is Jay. I am designing my first database in Access...

I've been watching this group for a couple of months now and have noticed that most design questions are posed in narrative form. I propose we come up with a...

Hello, I recently reported a problem of Access07 crashing whenever I opened a table or query in design view. I was using the Office07 Trial version. Since...

I have 3 tables, all with the same field names. I need to create a query which, - Pulls 2 field from table 1, but also adds a new field called "Category", and...

Hey Aspiring Writer! ODC Adv I am John, writing this on behalf of Gabriel, the webmaster of the Internet's No.1 Love & Dating Articles Site -...

Hello everyone, I have a junction table that unites events and invitees. Plus other fields like invited, present.. bla bla... Now to save space I could only...

Is there a keyboard shortcut you can use to copy or duplicate all the fields from the last record into the current record? I know you can use Ctrl + ' to...

How can I have the value of a field depend upon which table the value of another field can be found in? e.g. Table 1: Table 2 has a, b, c, Table 3 has c,...

Hi, I've been searching the help directory but to no avail... Is there a way I can easily create a dropdown list in a form that shows the queries I've made in...

I would like to have a Field that you click on for the purpose of adding employee times to a record on a daily basis. For instance there would be a field that...

Hi All I have a database setup for the storage of details for project submissions. I have a table which stores the details of the submissions themselves...

Table with just one column which is an autonumber column - how do I insert records? -- Tim Ward Brett Ward Limited - www.brettward.co.uk

Suppose I have a db of products. Each of these products can select from a number of features. Each of those features can have subfeatures. Etc. So I have a...