Hi all. I started this project with high hopes, but have arrived at a point where I have built waaaaay too many tables, and can't make my reports do what I...

Database required for the above data

sI have created a report from a query. The report has 3 field, i.e. SKU;Product;QntyShipped. In the footer I want to create a TOTAL for the Quantities...

This message is meant for someone in the Access Team at Microsoft. I have made an application using Access 2007. When running the application using 2007...

I have a field that is set to date. I understand =Date() will enter the date when you open the form or table. How do I get it to stay the original date when...

When in Table Design please add a way to alphabetize the fieldname list. It's very tedious to manually move the fields up /down one by one to sort the...

I am working on database normalization and I have a theoretical question. I have a table with 1000 records and two fields. Let's call it tOrders. The first...

Hello: I'm an easygoing librarian, and I haven't implemented fines for overdues in my small library application. But I've had a request from a more ..uh,...

My accountant wants me to add records from the creditors "tblSuppTxns" to the ledger "tblLedgerTxns". My problem is to add only select fields of a record...

The new feature to allow rich text editing of memo fields is great. However does any body have it working were a form has a subform or is a continuous...

Hi all, Would appreciate your help and inputs on my database design. I am desinging an inventory system. Each item is based on unique project and i need to...

question: this on activate event works great, but when it is morning hours, it show "good evening", then in the evening hours it show "good morning", can't...

Hi, I have an external tblStaff which includes contact info, name, etc. I have an internal tblContact which includes contact info, name, etc. I have...

I add 4 check boxes on a new form. These checkboxes are bound to a table that have 4 bit values (linked from SQL Server). When I click on the Field list and...

Hello, I have one field with item number and another for quantity. I want to be able to enter an item and it will display 1 for quantity and after that it...

I have a table that holds internal links to documents on local server. I wanted to fill in default location. So I went into the table design and filled in...

I am new to Access. I would like to be able to track the total number of days an employee has worked and the total number of day the same employee has...

Hello, I discovered a mistake in the design of my database. I have the same data stored in two different tables, which happen to have a parent/child...

I am using Access 2007 and I'm trying to get a combo box to display the artists I have in my database but every time I go to another record or close out the...

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