|
|
question creating multiple front-ends by
Amit
MS Access 2K, Windows XP
========================
I have a database which is to be used by multiple "groups"
of users, and each group may have different...
( 1 2)
|
|
12 |
737 |
|
|
auto populating by
Ryan
Hello,
not sure how to do this but what I need to do is have one
table get info for a field by pulling information from 2-
3 other fields and then use this...
|
|
2 |
311 |
|
|
Cannot join 1:M table into M:M tables by
Tom
I recently posted a question about multipe M:M relationship tables.
In one reply, RPW responded with the following:
*************
Although the following is...
|
May 19th, 2004 10:16 PM
by rpw
|
4 |
1,071 |
|
|
Creating a Survey by
Terri
I have some experience using Access, but I've been asked to tackle a new problem, and I'm lost. My church is creating a survey to assess priorities and...
|
|
1 |
684 |
|
|
Accounting by
Michael Wong
Hi,
For educational purpose, does anyone have some links to sites where I can
get a functional Access database on an Accounting system (inventory...
|
|
2 |
375 |
|
|
|
May 19th, 2004 06:51 PM
by rpw
|
24 |
1,701 |
|
|
Access AutoNumber Feature by
Keith Davis
Is there a way to get the AutoNumber feature in Access to
begin incrementing at a number other than 1? For example,
to begin the numbers assigned to a customer...
|
|
4 |
335 |
|
|
|
|
3 |
654 |
|
|
Copy Data by
John
I have a database that tracks transactions for internal
comany use (intrabank transfers, wire transfers, etc.).
Many of these entries are similar period to...
|
|
1 |
488 |
|
|
Comparing for Duplicate rows by
rsue
My "imported or linked" database has duplicate rows. The
(columns) fields I need to extract only need one row for
each entry in the invoice field. Please tell...
|
|
1 |
430 |
|
|
Validation Rule by
Tom
I am wondering if someone knows how to create a validation rule in a table that would throw an error message in a form.
Here's what I have in a table:
Field1...
|
May 18th, 2004 10:27 PM
by Tom
|
3 |
595 |
|
|
Linked tables #Deleted by
Annette
I am attempting to link a large DB2 table and all the data
shows as #Deleted, when a view is created on DB2 it links
in fine to access with no #Deleted.
Can...
|
|
0 |
582 |
|
|
Separate database for tables? by
Holly Clifton
In Access 2002 Bible, page 86, second paragraph, it says:
"It's also a good idea to create a separate datatbase for
just your tables. By separating your...
|
|
3 |
586 |
|
|
Two Tables need same Data Type by
Allison
I have two different ODBC tables and as a result of a make
table query I'm trying to change the Data Type on both
tables to read "text". One table already...
|
|
0 |
861 |
|
|
Adding File to Import File Spec by
Ken
I put this question out to another group but got no
responses. Thought I would try here.
In Access 97 I can edit an existing file import
specification and...
|
|
5 |
357 |
|
|
Issue with junction table by
Luke P
Hi guys.
I am building a database for my university and need to keep track of students and tutors who are using the carparks. My tables are as...
|
May 18th, 2004 11:31 AM
by LukeP
|
4 |
405 |
|
|
Dates by
mikerz
Is it possible to get number of days between two dates, excluding
weekends and holidays? Please advise.
------------------------------------------------
~~...
|
May 18th, 2004 06:56 AM
by TC
|
1 |
274 |
|
|
Parameter query for parts of date by
Rose
My date field is the traditional mm/d/yy format. I need to
create a parameter query that asks for the month and then
the year. I'm sure DatePart comes into...
|
|
1 |
517 |
|
|
Hyperlinks can't contain pound sign? by
Shifted Insights
I am creating a table with a field defined as a hyperlink. The files that these records will link to contain the pound sign (#) in the name. When I construct...
|
|
1 |
1,238 |
|
|
no relationships at database level by
Tim Zych
What do you all think about not setting up any
relationships at the database level, but instead setting
up relationships in queries "on the fly" as...
|
|
3 |
679 |