I created a report Group By Project ID.
For each Project we have multiple Milestone Date.
Then we deifined Key Milestone Date as follows:
//Define Key Milestone Date: 14days before currentd...
hello,
I have a DB i just created and it says in brackets that it is an Access 2000 file format.
my DB works fine and will probly be used to eventually convert into an SQL DB so should i c...
I have the following senerio.
I have 2 tables that contain the following info.
Table1
Type Parts
A 1
B 2
X 4
Table2
Type Labor
A 4
B 5
C 6
What I need is to output this.
...
I am about to create 2 separate databases one would handle all issue tracking and would act as a log of events for a particular client on a particular order. The second databse would only capt...
how and what kind of graph can be linked to the different types of accident catagory? hazcom,ppb.slips
how many incidents per month/ per incident?
I have 2 databases in Access 2003 with almost the same data. I've combined the tables into one and now I want to remove all the duplicates. I don't see any wizards or simple way to do this. ...
When designing a query in Access, in the default view of the query design view screen, the tables are placed in the top 20% of the screen, followed the design grid (or the QBE grid), which tak...
Greetings Experts,
I have a small online auction business that deals in only one of inventory items. At the moment I do not have any duplicate products that I have to keep track of the qua...
I recently had to reinstall MS Access, and since then I have been unable to link table to Excel or import data from Excel.
What am I mssing, Do I need to load a different service Pack. I ...
I have a project where there are some very large text fields to enter data (descriptive paragraphs)
The first thing we are having problems with is while typing in one of the text boxes, usi...
I'm starting our company's database over again from scratch and want to institute best practices this time around.
I have a two part question:
1) Is it feasible or recommended to have o...
Hi
I have a table with a subdatasheet. It looks as though I'm going to have to import records into it on an ongoing basis from Excel. I can import into the main part of the table no probl...
Dear Experts:
I have an Access file that automatically run the routine to populate the tables in another database file once I open it. There is one form, two macros and some VBA functio...
I build the sugguested tables. Does the relates fields automatically fill themselves?
I want to set the pagesettings of a report in MS Access 2000. I found out how to change the printer with code in MS Access 2000, but now I need to change the pagesettings as well.
Hello Experts,
I need some ideas for designing a "checkbox" matrix in Access.
Let me start explaining the really easy matrix from an MS-Excel perspective. In Excel, I have a "city/pr...
What I have: ClientsTBL, ContactEventTBL Client will have many events and events will have many clients (like a mailing list), so I have created a linking table between the two - ClientEventX...
I have an Access 2000 database which I have been progressively been developing in our office over a number of years.
The database has long been split into a frontend (forms, queries, modul...
I'm using v11.11 and everyone has a different way of connecting to these servers. We cannot turn on trusted system and so logging is minimal. If I wanted to have the ability to at least go b...
Hi there,
I have a database with a table. I reached the limit of 255 columns. I attached a new table with a one-to-one relationship. If I use this in a form, I get the message: exceeded 255 d...
I have three radio button. 1. sports, 2. clubs & Soc. 3. Others
1. If I select sports radio button, I want to display hidden table (in the hidden table 1 combo box)
2. If I select clubs r...
When I import some data into Access using an import spec and set an autonumber to use as the primary key, Access rearranges some of my data and puts things in the incorrect order. I will be i...
I am a beginner, a REAL beginner here so please be patient with me :)
I am setting up a database to keep track of software licenses for our team. I have created a link table for the source s...
For SOX compliance I have been told that our method of registering prices in our purchasing database is insecure. Here's the current process, handled in Excel. We have about 5 Buyers, two ma...
Hi
I am trying to create a basic database for my colleagues that records several features of training for customers over the course of time. I have a form that records the course details - da...
