I need someone to point me in the right direction. I have an Access database that I created that is working perfectly. Now, I need to be able to integrate the...

I need to write a program. the basic format is a calendar. 1 month. They click on the day and enter text. The Calendar needs to be the size of the screen. I...

When I import from an Excel into Access 2003 table, in one field (Text field) the project numbers appear in a scientific format with exponents. The data in...

I've been user of Access 2003 for a while and am ok using databases but somehow lack practical knowledge when it comes to redesigning or normalizing existing...

-- Dennis

Looks like the MVPs have been out in force lately. You guys have been so hot on answering questions the last couple of days that there have not been many...

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...

Okay I've finished my training course on Visual Basic, so I now have basic training in Visual Basic, so to speak! My question is this. I have 2 nested...

I'm trying to construct a DB that's essentially a list of lists, with each sublist having an identical structure. Seems straightforward, right? Make a...

I have two tables 1. Members and 2 is Questions. Members table contains demographics of all members. Question table contains 48 questions to be answered. ...

I have a split Access 2000 DB with linked tables. I want to create a standalone copy of this DB on another PC without having to manually link the tables again...

I am designing a database. My parent table has 3 separate fields that make up the primary key, a two digit number, an autonumber, and a 2 letter field. These...

Ref "Why is my text being stored as Numeric" 13-Sep-05 Tina provided final solution to my question/need with this code. SELECT Count(tblPatientV1.ChartNumber)...

Hello, I have a table called Company_Locations. There is a field named Is_Main. For any given COMPANYID, i want that only one Location can have the...

I copied a database that I have used for years. It has always worked on these two computers. I made some minor changes to a form using Access 97 SP2. Everyhing...

I have an exam database that stores many exam questions and testing information. One function of this database is to generate actual exams which we administer...

The HELP documentation gives me the EXACT syntax for how to do this. CREATE and VIEW are even reserved words in the Jet Database. The DROP command even lists...

I think that family tree will be a popular template for access database. I wonder if there is any already designed so I don't need to re-invent the wheels.

I am trying to create a database to show the homework I set for my various classes. I want to be able to enter homework for each class and then see a list of...