I have two tables in my Access Database. One labeled Requirements and the other labeled Analysis.
The Analyses table has multiple entries about the requirements used for that analyses (All...
Hi,
I need some help with designing my database.
Tables: UserDetail, Searchable, Message
UserDetail has a detail description of each user. Searchable table is used for the user to bloc...
I would like to setup a criteria in an Access Query with a specific date range. Here's some sample data in the different fields.
C1 C2 C3 C4
1/1/08 Name ...
Hi Experts,
Thanks for your time and knowledge.
I have been asked to take a look at a database at work, I have a bit of experience with Access while no-one else at work does. The databas...
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...
I want to add around 1500 images to my database (they OLE objects that appear on my form as a visual aid). What is the best way to do this? Quality doesn't have to be great.
-Frank
I have done the following
1) Linked in a SQL server table into my Access program
2) created a text import specification.
The problem is my SQL sever table is be overridden (a new Access...
I have a Access db created in Professional 2000. Can it be run in the non pro Access?
I am doing a db and one of the tables we are following patients during in-patient stays and need to document average $/day (both PRE specific treatment and POSTspecific treatment) and same inf...
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...
We have a office device that tracks office equipment usage by user and client. At the end of the month when I need to retrieve it's data it exports a access .mdb file. In that file are 2 tab...
This is my first database, and so I had originally planned on just having all the data in local tables stored on the server, but it was suggested that this is a bad way to do it for updating t...
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...
I have created an access database with many forms and multiple tables. I need an enduser to be able to enter information on the form which will populate into different tables.
I would like to build an array consisting of unique items from a specific field in a table. For example, the table below consists of 12 records, with 3 instances each of the number 6, 7 and 8...
I would like to have a combo box on a form that would have a list of all of possible tables potentially used in a query. When the user picks the table for the list, a second combo box would ap...
I have a form in which the user can enter Currency to be use to breakdown money into $100, $50, $20 etc. I would like to form an array of the notes and coins to be used and pass this array to ...
Running Access 2003 on XP Home.
I have a data base. One of the fields is a date, in the format mm.dd.yyyy. The years are sprinkled around from 1970 to the present.
I have a query which...
I want to be able to build an access file from a text file. This I did. the problem is I can't modify the access table. I'm getting a this property cannot be modified in linked tables....
h...
I am trying to create a relationship between all my tables. The screenshot shows my tables, I already have a relationship going from "Computers" to "Warranty & Support"; this relationship was...
I was asked to help troubleshoot an Access database that is having data integrity problems.
The database is used by many users (~50 - 100) to track risks and issues on a major corporate sof...
I am working to design an Access 2003 DB in which data is entered into an unbound form and then saved into two tables at the press of a button. When I attempt to press the button to runt he s...
The original database is at www.dropio.com/tasksdb but will probably confuse the issue.
From the standpoint of only tables, the following is what I am trying to accomplish.
Note the date...
Hello Experts,
I currently have an Access 2003 FE/BE application that is deployed over our corporate network. ~ 70 users with maybe 15 concurrent. In talking to my IT group they are suggest...
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...
