I am trying to create a manufacturing database. I want to use the database for quoting purposes. I have created a master table, assembly table and a BOM...

I currently have a one to many relationship between two tables. I would like to concatinate all the records from the many table into one record. Is there a...

I developed an Issue Tracking system using Access 2003 while my operating system was Windows 2000. My hard drive crashed and I was upgraded to Windows XP. I...

I have a database which has linked tables to two other databases and before I call a function to make changes to those linked tables, I would like to test for...

I want to create an MDE file but the Tools|Database Utilities|Make MDE File is grayed out. Do I need an Add-on? I'm running Access2002 SP-2. Thanks for any...

I'm trying to set up a database with customer info, product info and order info. I have a customer table with PK of customer # (autonumber), linked to order...

I am not able to see the modules in the action pane. Also I am not ableto see the task pane.I went to tools and it appears in the show viw as check marked. Is...

I am running office xp on my new machine and i cannot seem to create a database table for my invoice template like i used to do on office 2000 by running a...

I just started to use mysql as the back end and I was just wondering how it is different from using access as a backend. Some of the querys that I wrote in...

I have a number of parent - child tables for which I need to establish referential integrity. Here is an example: Parent table: UC Requirement Key fields: UC...

When I open Access, the Tools menu does not show 'Startup' or 'Options'. I'm trying to change the start up method and I am unable to do so because...

I need to open another program (non-executable) from within MS Access. The SHELL and RunApp commands seem to be reserved for *.exe programs. How do I open...

I am using Access 2000 SP3. Everything worked fine last time I used Access, but that was a while ago. Not sure what has changed. Now, when I look at a table...

Hello Group! I have this code and I need add message boxes: That say: 1- "You must enter only numbers" 2- "The value must be different from zero" 3-...

Our fiscal year starts 7/1. Currently it is fiscal year 2005, but on 7/1 it will be fiscal year 2006. I am trying to write a simple function that will figure...

I am using Access 2000 SP3. Everything worked fine last time I used Access, but that was a while ago. Not sure what has changed. Now, when I look at a table...

Whenever I add a record to a Subform I have a Requery on the Subform so that the calculated control shows the new amount, except when I requery every record...

I have a 3 record per page report that has a table as the record source but when I look through the report all the records are not in the same order as they...

I was wondering how to add a auto number field to a make table query? Thanks for your help

How do you set the value in a table? I have a Subform that has a record in it. It contains a value that is placed there from a popup form. It has the...