I have a database set up with an Employee table which is extremly cumbersome. We run a child care org. with 19 centres and 150 current employees. It contains...

I've got a new project that I am just now starting. This database is going to be a lot more complicated than my last. I'm attempting to build a...

I have Access running on a Windows 2003 network. Developers create databases and share them on the network. The problem I am currently having is that one of...

is there a limit to the number of iif statements i can have in one field?

Hello I have a lookup table joining two tables together, Group and SubGroup. Each Group has a set of corresponding SubGroups. e.g. Group: primary key =...

Hi, I have built a database with details of all the wines we supply in one place. I have one table with the text information, one for bottleshots (all jpg's...

I just upgraded Office to 2003 from 97 and need to convert a couple of databases designed for Office 97. Can someone share your experience with me especially...

I have a split database that will be used by a variety of different clients. Ideally I would like to have their company logo displayed on all forms and...

Thanks to this forum, I have learned the evils of using the "lookup" data type in tables. Thanks, guys! I now have a combobox on a form to lookup values from...

When I go to Tool/Options/Database Utilities/Make MDE File I get a message saying Microsoft Access was unable to make an MDE file? What could be the problem? ...

I am trying to figure out a way to "randomly" generate a number, between 1 & 6; however, the caveat is that I also have percentages that each number should...

I am having problems with a database that I have designed. When I enter data in to a form and want to add a new record the form freezes. The only solution is...

Dear Master Designers, 1. I want to create a control that will not allow data input unless a Yes/No field has been set to yes. Similar to checking "I agree"...

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 am tring to design a small Point Of Sale database for a small bar. I have 3 tables called 01Genre, 02Categories and 03Items. Table 01Genre has a Primary Key...

I have a form called Assembly It has a subform called Kits The Assembly form shows my product and the Kits form is where I assign child parts for the products...

Lynn, Thank you so much for your help. Unfortunatelly, your instrucitons are beyond my level. I only got the 4th item to work. If I describe step by step...

I recently split our database using the Utility. Not sure if it went the way it was supposed to? The be and fe are still on the server and occasionally one of...

I sure could use some help on this one. I created a payroll program years ago in Office 97 which used Access as a front-end for data entry and display, (among...

I have two tables in a database designed to store exam questions. One table has the text of the question and answer choices, along with other textual fields...