New to Access and using version 2007. I am building a database covering the membership of a boating club. Looking at tables that would include: * Primary...

I have a new Windows Vista Premium 64 Bit, and my Microsoft Picture it! 2002 does not work on it, as it is no longer available and my question is what is out...

Hi, I'm trying to create a engineering database whereby there will be hyperlinks to engineering documents. I'm trying to create a query whereby I can search...

I have set up 5 different queries to calculate one specific total each. I have also set up 5 accompaning forms. They work great. When I try to produce a...

I want to create a combo box where, if the user enters the zip code, the city and state will be automatically filled in (with the option to change it, where...

I WOULD LIKE TO ACCESS A TEMPLATE THAT WOULD HAVE DAYS ON THE ROWS AND MONTHS IN THE COLUMNS. DOES ODDICE 2002 HAVE SUCH A TEMPLATE, IF NOT WHERE CAN I FIND A...

I am new to Access, and very little knowledge about SQL. I read allot about normalization, need to know if I went to far with it with my Family table. Here...

I append the record of one table to another table and I want to add the same text to one of the appended fields. "This comes from ConcernID #" and then have...

i have a field which is data type - number field size - decimal format - standard precision - 8 decimal places - 2 however, whn in...

I need to set the format property of a text field so that it formats using Titlecase...I want the first letter of every word to be capitalized. I've already...

I’m looking to create, in my view, a complex database in Access 2007 and would like your advice and views on my design plan. First I will explain what the...

I have an invoice table and an invoice details table and i need to have the design accept duplicate invoice numbers since we receive same invoices from...

Ok i'm going to try to explain this as simply as possible. database purpose: I sell italian charms and makeup on ebay and other auction sites. I am making a...

Hi Everybody! Does anyone know if it is possible to link a WSS 3.0 Picture Library to Access 2007? Since it is possible to link a Document Library I thought...

I'm using the default value Now() for a Date/Time field in a table. It has been working fine for over a year. All of a sudden I'm getting the above message. ...

I posted a question yesterday (see below). Ken Snell referred me to the following article, http://www.mvps.org/access/forms/frm0058.htm, which I was able to...

Isn't there an input mask so that a phone number has to be entered as (111)111-1111? In a table of names and addresses, is there a way (in Access) to have...

I have 3 tables, all with the same field names. I need to create a query which, - Pulls 2 field from table 1, but also adds a new field called "Category", and...

I split my database recently and now I am experience terrible performance when designing my forms. It can take 10 seconds just to select a field and delete it....

Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...