I'm designing an access 2003 DB for a small Newspaper. It will monitor the deadlines of the newspaper. Each record is a day. There are 5 people that could...

I haven't use the attachement data type before. I set up a field in my BE tables as an attachment data type. I placed this field in my FE form, but when I...

I have to either frequently spend hours preparing an archaic report by hand in excel for change resistant paper people or figure out how to display the data I...

Hi, Hope someone can help. Here's the scenario: I have two MSAccess tables MainTab and SubTab. MainTab has an autonumber 'id' column as primary key. ...

Simple question, hope I can get an answer.... Ok, I have created a table and form for our company to keep track of incoming inventory. Being that we work...

I have made a drop down box, but now want to make when I select a specific word it will change back ground color in whole row. Say I pick UT for Utah in my...

I have a yes/no field that I tag if I want to send a bill to various people. After I have sent the bill I want to clear the field so I can use the field at...

I have a hperlink field that I want users to be able to Add, Open ect on my form. It works until I uncheck the "Allow Full Menu" in the Access Options area....

hope i explain this well. i have a similar setup, as below, but for the "MachineCounter" table i have a finacial period. this period is essentially a...

Hello again :) I should have bookmarked my last thread so I could add to it :P Here goes again ;) Ok this is what I have so far :) How's it look? address...

I am trying to create a membership database for a church. I need to have all members entered into the database, then for the members I need to have their...

I am trying to design a budget database and I want to have consistent categories and expense. I have a table with Category and Expense It looks something like...

I want to allow for default shortcut menu's. But when that is enabled it allows the user to right click on the form and go to design view - which I obviously...

I'm working on a DB for statistics for a small Hockey League. We've been using Excel, but it's getting more and more unwieldy. I've read elsewhere in this...

Hi, i am having some trouble decided how to design this database. I have attached an excel spreadsheet with all the requirements. So far this is what i have...

Hi I am trying to learn how to design a relational database. I have designed one database in access 97 but it was a flat database file since I didn't know how...

I am trying to design a very simple database for tracking attendance of my church's youth group. We meet weekly and for various events and fundraisers. I want...

Win 7, access 2007 , tables: device and ip, relation (device.ipIP, foreign)one-to-one(ip.ID, primary) when I delete an device from device table using form it...

I created 5 Tables: 1)Office with Primary Key as auto number named Office ID 2)Marketer with Primary Key as auto number named Marketer ID 3)Currency with...

Hi, I am learning in Access 2007.... Through John and Jeff Book......Have two tables.... e.g. 1. AllItems 2. ItemsCategories Both has Primary keys .......