|
automatic entry of previous record
My data base is a record of bank deposits by date. I update the table using a
form and I would like to automatically enter the next date by adding one day
to the previous record upon new record creation. Is ther an easy way to do
this ??...
|
3 |
11/4/2008 9:29:01 PM |
|
|
Opening with Form
Does anyone know how I can open a database file and have a form menu open up
automatically as a front end and hide the back tables and queries? I know you
use to be able to do it in the older versions of Access but not sure with
Access 2007
Also does anyone know if I can refresh a query by opening a form or do you
have to refresh each query individually?
thanks...
|
2 |
11/4/2008 4:51:52 PM |
|
|
Project Tracking Database
I need assistance designing a database that will allow me to track/edit
projects for the states that I support. I work in contruction and review
design documents for three types of projects. Each Project Type is reviewed
at 30%, 60% and 90% design stage and are tracked in order to report activity
(i.e. when completed, amount of time taken for review). Each project has an
engineer(1 of 6 ...
|
3 |
11/4/2008 2:58:01 PM |
|
|
question about table placement in split database
Hi,
I'm using Access 2000 on Windows 2000 professional to create a simple
reporting application. I split the database so I could put the mde
file on a couple users' computers.
Over the last year, I added more table to meet added requirements. But
I didn't add them to the _be file. Now I have some linked tables to
the _be file and some tables residing in the mdb file.
How might this im...
|
3 |
11/3/2008 6:54:35 PM |
|
|
Change of address
I am a self-taught novice (the worst kind!) so am hoping I can get a nice
simple answer to my question. First the history:
I want to re-build a database I've been using for a couple of years. It
records patients and test results for specific infections. One patient can
have many tests at the same time which each have a unique number. Currently
the patient name, DOB, GP, 1st line of ...
|
8 |
11/3/2008 12:59:00 PM |
|
|
How do you build a Document Library (Database)?
My organization would like to build a database or library of pdf documents.
The goal is for users to do a query search, come up with a list of PDF
document links based on their query, and click onto a link which will open
the PDF document they prefer.
Is Access the right tool for this, or is Sharepoint better?
Also, are there any existing Access templates or free software that alread...
|
2 |
11/3/2008 12:35:02 PM |
|
|
how to create staff rota from access database
can you help on setting a database telling who is working which day, what
time and how many hours they are working each shift...
|
9 |
11/3/2008 10:57:32 AM |
|
|
Design help for community group database
I am trying to set up a database to track Girl Guide leaders in my Region
along with their training and awards history. Each leader has another leader
as a Guiding Partner (or mentor) and this has to be reflected in their
training history. Each leader's qualifications need to be "appraised" every 3
years and I need to be able to track when that is due. I also need to be able
to get repor...
|
10 |
11/3/2008 7:31:36 AM |
|
|
Using Autonumber as PK, cascade update doesn't work?
Greetings all,
I've been searching and searching and trying different things and I finally
need to ask.
Is it possible to use an Autonumber PK to cascade update new records?
For example, I have three tables, let's call them Main, Sub1 and Sub2:
In Main I have an Autonumber PK field named MainID.
In Sub1 I have an Autonumber PK field named Sub1ID, and a Number field MainID.
In Sub2 ...
|
18 |
11/3/2008 12:23:26 AM |
|
|
Change the starting value of an AutoNumber field
Hello
when I appended some data into my main table, the autonumber jumped from
around 544 to 26300.
There are only 276 rows in the table.
The most rows I've deleted from the table would be maybe 200, when I was
designing and testing the table, certainly not 25000.
All I could find in Help was "Change the starting value of an AutoNumber
field". I followed the instructions but that didn...
|
4 |
11/2/2008 5:16:36 PM |
|
|
i want to open my web browse in ease
i want to open my website for my organisation and my company...
|
2 |
11/2/2008 4:00:28 PM |
|
|
set up tables with proper relationship
New to access 2003. Have been reading my access 2003 bible and lessons on
line and now am attempting to make my first relational database using proper
technique but I'm struggling and would like direction. I have two tables. I
would like to set up the database so that I can combine the two tables by
using a query and then set up a form based on the results of that query.
I am doing ...
|
2 |
11/2/2008 7:55:25 AM |
|
|
Age Limit Validation Rule
We are trying to limit the age when imputting the data on forms.
We have the customers DOB in format (dd/mm/yyyy)and are trying to limit the
age to 18.
Are there any validation rules to help us achieve this...?...
|
4 |
11/1/2008 3:08:48 AM |
|
|
combobox style
How do I go about changing the style of a combobox in Access 2000 from the
default to a simple combobox (i.e. show records in list at all times instead
only showing records when arrow is clicked?)? I've seen articles on the 3
styles available, but none with an explanation on how to actually set it to
the simple style....
|
13 |
11/1/2008 12:07:08 AM |
|
|
Holiday Dates
I am having trouble in getting my head round dates specifically employee
holiday dates where an employee has holidays booked for the year which are
added to and deleted from.
1. I need to allocate an allowance for existing and when sombody joins
calculated on the number of months left in the holiday year would i have a
seperate table tblHolidayEntitlement with(EmployeeID,Year,DaysEntitl...
|
2 |
10/31/2008 3:58:06 PM |
|
|
Help needed with constructing a referral tracker
I am constructing a data base for tracking referrals with in my department
and have hit a little bit of a wall.
Here's what i have to work with.
There are 2 areas operations and phones. Our operations area processes
applications received by phone and from other areas. They use an access db to
track account opening progress and reporting.
I am making a new db for the phone area to t...
|
4 |
10/31/2008 11:47:00 AM |
|
|
Related records depend on other related records
I'm not getting my brain around this one. The general situation is that
machine parts are processed according to a Process Plan. A Process Plan may
be for one part or several. Also, a part may be processed according to one
of several Process Plans. These are the tables for this set-up:
tblPlan
PlanID (PK)
InternalNumber
tblPart
PartID (PK)
PartNumber
PartDe...
|
3 |
10/31/2008 11:46:10 AM |
|
|
Attachment field does not appear
I want a field to contain a jpg image. Help says to use the Attachment filed
when adding a new field (column.) All I get are the standard
Text/Memo/Number... choices. I'm using MS Office 2007 Pro. All suggestions
will be greatly appreciated.
Thanks
--
Charles E Lingo...
|
4 |
10/31/2008 1:51:53 AM |
|
|
Keeping a List of Sub Categories in Access
I need to keep records in an Access 2007 database that belong to one main
category and any number (in practice between 1 and 12 usually) of sub
categories. Currently I keep the main category as an integer and the sub
categories as a string which is a csv list, e.g. 1,3,5,7,9,11.
The database is driven by a front end written in C# so converting the csv
list to a List<int> and bac...
|
3 |
10/30/2008 11:27:41 PM |
|
|
Textbox dependent on Listbox values
Can someone help me write a code that basically says this:
If [MyTxtbox] does not equal any value in [MyLstBox] Then
Msgbox "That value does not exist. Please try another value."
I need to have both the Listbox and the Textbox on my form, but I can't
figure out a code that will check the new value of the textbox if it's been
changed after the first msgbox....
|
6 |
10/30/2008 6:05:02 PM |
|
|
Lookup field from linked tables - can it be done?
Ok, in my Access 2003 database I now have 4 key skills tables;
tblEQUIPMENT - listing equipment iinformation (approx 250+ pieces)
tblMETHODS - listing analytical methods to use in conjunction with the
equipment from the EQUIPMENT table (approx 105 methods)
tblTRAINING - listing all training courses (currently 250+ courses and more
added all the time)
tblSOFTSKILLS - random stuff that is ...
|
3 |
10/30/2008 4:50:44 PM |
|
|
MS Access Template: Service Call Management Database
I wanted to see if I could get some assistance/recommendations regarding this
template. Our customers are states and we track dollars spent or contributed.
Would anyone be able to give guidance on how this template is structured or
anyone who has modified this template? I greatly appreciate it.
http://office.microsoft.com/en-us/templates/TC010184671033.aspx?pid=CT101426031033...
|
8 |
10/30/2008 1:06:01 PM |
|
|
Forecast Table
I would like to receive your feedback about my table design for forecast. The
forecast is set at product customer level.
What do you think about the following table layout in Access 2003?
ProductID
CustomeID
January
February
....
....
....
November
December
Year
Thanks...
|
10 |
10/29/2008 11:26:00 PM |
|
|
Establish relationship between tables using TWO fields
I have a ChildID table and a ClinicVisits table. I want to ensure that the
user cannot create a ClinicVisits record that does not have matching values
for ClinicID and ChildID in the ChildID table.
When I try to establish a relationship in the relationships table, it will
only allow me to set up a link for one field between the two tables. How do
I establish a two-field relationship b...
|
9 |
10/29/2008 8:45:47 PM |
|
|
Msgbox error message/recheck field value
Hello,
I've been searching for the answer to this all week, and I haven't been able
to find it. I'm new to building Access databases, but I've managed to do
pretty well with what I'm working on so far. The one problem that is holding
me up from being done with this is that I have an error check in place to
prevent users from entering numbers that are already in use, but once the
code ...
|
3 |
10/29/2008 8:27:03 PM |