Hi I am designing a classical music database and am a bit stuck on how to manage the movements of a work. I have a table Work (primary key WorkID and linked...

Hi, I would like to ask advice on updating, rewriting an application database file. I created an application (1 file accde includes tables) that keeps track...

First time I have inherited a db with no documentation and which I am having trouble figuring it out. Which or how is the best way to figure someone else's...

I've searched through these forums and read alot of discussions regarding not using a lookup in a table. Instead, one should put that information in another...

Hi A colleague wants to know if it is possible to put a header and footer in a table in Access 2007, she used to be able to do it in previous versions. I...

I am looking to create a web database for my web site. My web host provides My SQL, can I use a Access database to store the data. Where can I find the steps...

Hi, The goal / Issue: I want to be able to register the student right after the user enters the student name and address. Currently, the user does this by...

I am transitioning from excel to access for the reason of the spreadsheet is only getting igger and harder to use. I am an Insurance agent and I am trying to...

Hi, I need a table which will hold a user's answers to about 27 survey questions. Multiple users will use the database to enter responses for each question....

Hi, and thanks for your help. I am creating a database for creating multiple choice tests. I keep getting stumped because there are several many to many...

Arno R Personal Vendetta Clicically Obsessive Rarely posts help self-appointed forum police

Hi, I have a small business in water refilling station, can anyone give me a link to show samples of database related to this, especially in cash register,...

Because of the complexities of an Excel spreadsheet that I need to import into Access, I have decided to import the whole worksheet into Access then use VBA...

Hi, I am trying to create a table that I importing Excel data into and the first couple of columns I need to come thru a certain way Booking Qtr should look...

Hi there, I've created an online form where people (or rather school classes and youth groups) can register for an event we're organizing. They can indicate...

Hey guys, I have a key number that I need to create a sequential number based on that number. For example: C-202743 and when you enter new record I wanted to...

Hello NG I have a huge access database that is maintained with a rather old application (VB6). The way the data is maintained is by using RecordSet.AddNew...

I'm setting up an inventory movement table to track parts. Within the table are fields for (among others) part number, transaction type and quantity. I need...

Hello All I have a field 'ni_number' in a table which must always be 2 alphas then 6 digits then 1 alpha, and I have the validation for this in place. In...

Correct me if I misunderstood, but I read that one should index fields that are used as criteria in queries. With this in mind, when one does a caculated...