Long ago, I found a cool solution for listing tables and fields. It creates a TABLE of tables and fields, that can be sorted and printed. It consists of a...

Firstly can somebody please tell me if it is possible to do a database design change on a separate copy of my database and then bring it on to update the one I...

Dear All, Newbie Access .mdb I am trying to create a database (Table1) with Access 2003 Professional on my XP PC. The Table1 includes 80 fields and one row....

Hi all, I posted the same question in access.gettingstarted forum but no answer, I think I may have posted in the wrong place so I am trying this forum. I...

Sorry, I was assuming you knew how to write Access code. You will need to create a VB function to perform this task. I don't have much time now as I have to go...

I have a database that was fairly simple but as time went on, I had to normalize the table into several others. I did this with Access but now one of the...

It sounds like both Employee and Training are one to many with Completed Training However since you might want to tracj scheduled training (not yet complete)...

It's not good database design to have hidden data in a column e.g. the year 'hidden' in a primary key. Stick with the autonumber primary key and put the year...

I've been wrestling with this design for a while and would appreciate some input. This is a database that handles audits of determinations made by remote...

Write a query to do an insert into that column for each row... Update MyTable Set = "2009-10" Where IS NULL; By the way, I strongly advise against using...

I not sure how to setup the following fields in my table and also when I create the form for the users to input the necessary information: Employment (check...

I'm fairly new to Access, I need to setup a mult-select list box (or whatever box that would best meet my need). I have a table that list User Name, Address,...

I am attempting to make a filter by form search for a issues/comment database that I created. I copied a form and VB template, switching out the names...

How do I change the titles for the Datasheet view in Access? It doesn't give me the opportunity to go into table design. But the titles ended up being ones I...

I am in the process of setting up a database to manage subscribers to a newspaper. I have a field for subscription start and another for subscription...

I am creating a database which tracks Newspaper subscribers, carriers and areas delivered. I have 3 tables: Subscriber Data, Carriers & Areas. The Carrier...

I want to dynamiccally change table structure in Access 2000 code. that is dynamiccally add table structure field. when a table's records have changed, the...

I want to start a database with a switchboard showing various users and have them click their name to go to their own switchboard. I know how to set the...

I have a table with 10,000 addresses. EAch address is in one field: 123 W Maple. I am able to convert this address into two fields: Field 1 is 123 and Field...

The community group I am involved with wants to convert an EXCEL worksheet into a database that could be used as a mailing list. The EXCEL worksheet contains...