Database design - reminders for overdue publications
Thu, 25 Sep 2008 02:57:01 -0700
Hi, this is a bit complicated but I'm hoping someone out there has an idea of
whether it can be done or not.
I am designing a database to track all publications that are received at the
scientific labs where I work. On this database, the following information is
the most vital aspects;
1. Date of public ...
|
Does Compact on close wprk for the Back End?
Wed, 24 Sep 2008 20:57:01 -0700
Hello,
I see that the BE database keep bigger in size. My question is if we setup
the option to be " Compact on Close" on each Front End of the users, does it
work to compact the backend?. How can it be while the other users is closing,
while the others are still using, how will it disturb the current BE wh ...
|
place a overdue display in header
Wed, 24 Sep 2008 14:08:11 -0700
I would like to place an overdue display in the header of the
frmUniformOrders, something like the one for possible duplicate in the
Contacts db.
I think I would have to place a date ordered text box in the form and
another text box in the header that would remain invisible until the set time
between the ...
|
many to many self join
Wed, 24 Sep 2008 11:46:01 -0700
I'm faced with a unique problem.
many-to-many self join
I have a list of drawings. some drawings include subdrawings and those
subdrawings can have more subdrawings. However, the subdrawings can be main
drawings for a project by themselves.
It looks like this:
I have projects. I put them into tbl_project ...
|
Displaying a date range in my report
Wed, 24 Sep 2008 11:22:01 -0700
I have a report run where I select the records based on the date a service
was performed. My query asks for a range with a start and end date on this
field. How can I show this range on my report?
--
Anne ...
|
Linking DataBases
Wed, 24 Sep 2008 09:16:16 -0700
Hi!
I have 4 spreadsheets that are filled by 4 different users.
I am not an expert in Access but I created a Database and linked all of
these 4 spreadsheets into table section. (I Have: CA1, CA2, CA3 and CA4)
Now I am trying unsuccessfully to merge these 4 tables in order to create
only one form.
Can anybody ...
|
Register one record for each date or one record from and to date?
Wed, 24 Sep 2008 02:54:20 -0700 (PDT)
What is best practice? Either to
1) Register one record for each date or
2) Register one record with from and to date?
Let's look at an example. If I register vacation for several persons,
whould it then be enough to
register Personid, From- and ToDate?
Later I will want to use those data in a report tha ...
|
|
|
your advice on tables
Wed, 24 Sep 2008 02:42:01 -0700
At the moment i have three tables with the following columns:
Supplier table:
Vendor number (primary key)
Name
Address 1
Address 2
Town
Postcode
Phone
Fax
Group
Description
Iso Table
Vendor number
Name
iso 1
iso2
iso3
iso4
reach
Comments table
Vendor number
name
vendor non conformities ...
|
save record
Tue, 23 Sep 2008 23:33:01 -0700
What is the difference between the command
docmd.save
and
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
both commands seem to save the record.
(access 2003, vista)
10x
--
Alu_GK ...
|
Splitting and networking database
Tue, 23 Sep 2008 15:20:01 -0700
I have an Access 2003 database to split into a front and back end. I expect
to use the wizard to accomplish that task. The database is on one computer on
my clientâ??s network (no server; just networked computers).
This is my plan so if my steps are not correct, please let me know. (Iâ??m
going to make a co ...
|
