I have a table with an autonumber that I need to start with the number 20801. Access help says to change the New Values property. I don't see that property...

Hello, Not sure how to approach this: We have an inventory database that has a variety of item types. Workstations and printers have quite a difference...

This is more of a design question about how data should be stored in a table. While importing information from Excel, some records in the same field have...

I have been reading all about the evils of lookups in tables, however could someone please explain how you avoid using them - is the answer to have many tiny...

Hi Karl, You’ve answered a bulk of my questions so a special thanks to you. I sure appreciate all the contributions you make. You’re always helping...

Hi, I am looking for a way to convert a column on my table in Access that is Raw HTML to Rich Text. Thanks!

What is input into the label boxes to all count those fields within a grouping that a blank. The Category is RSVPDate -- Rose

I have PMs that are due - sometimes within 1 day and sometimes within 3 days. I record the date done and have a query extract the next due date. When that...

on just a PART of a field? Here's the structure so far: Access 2000, 3 tables (Furniture, Titles, Descriptions), no joins. Here's the design & some sample...

I am building an employee production db at work. The problem I am having is with the relationships and maybe my table design. I have one table for employee,...

Does anyone have a good petty cash template? -- Lady Chalkley

I am working with an access database that I did not create and I am looking for pointers that will help me analyze and understand what is happening with the...

I am currently designing a database that will be used on a LAN and a number of remote laptops that may or may not have access to the internet. I would like to...

Ok after reading some of the feedback, I went back and redesigned my tables. In addition, here is an overview of what I want this database to do. 1. Tel me...

Table one contains fields with information on stocks. Example, field one is StockSymbol, field two is StockName, field three is Exchange, etc. Overall there...

I am trying to create something of a survey database. I have seen the sample database "At Your Survey", but I am not sure how to tweak it to what I need. I...

hi may i know what the fields Entry Title and Entry number in the account transaction templates of microsoft does. i have downloaded it but am confuse to...

I am splitting 10 existing tables statewise. Each such split table will have a distinct name. Eg: In case of Family table, it will have the name of the...