|
many to many relationship
hi all.
I need some information regarding relationships.
tables are tblMONTH(monthId,month,...)
tblSITE(SiteId,Site,....)
tblParameter(Parameterid,parameter,....)
here in each month we do samples for different parameters in different
sites.
so each month will have many sites and each site can be in many months.
Similarly each sites have many parameters and each parameter can be
test...
|
5 |
26.07.2006 02:59:01 |
|
|
water bottle
water boddle...
|
1 |
25.07.2006 22:03:02 |
|
|
Totals for Report
Hi
I am new to Access, but experienced in Excel & Business Objects, as such am
having some difficulty working out how to do standard things from those
applications in Access.
OK, i have a Table with 4 bits of information;
Customer ID: an autonumber that doesnt allow duplicates
Customer's Region: North, West, South, East
Customer Type: A or B
Customer Grading: 1, 2, 3, 4, 5
I t...
|
3 |
25.07.2006 19:54:45 |
|
|
Copying and Pasting an Existing Form
Often, I'd like to copy an existing form and paste it back in to the
database with a new name so that I can make revisions without destroying the
form that already works (with the intent of removing the original form after
the new one is working properly). Trouble is it never seems to work right.
I think I've found that the copy continues to use the underlying code from
the original for...
|
4 |
25.07.2006 19:32:02 |
|
|
MERGE TWO TABLES IN ACCESS
I want to simply merge two tables into one. Field headings are the same in
each table....
|
5 |
25.07.2006 19:27:02 |
|
|
MAKING 3 TABLES WORK TOGETHER
I have a tables named Customers, Products and Transactions.
The products table is filled with all sorts of STANDARD cars.
The customers table is filled with customers (obviously).
The transaction table ties a customer to particular products (cars).
What if a customer bought a non-standard car (special like a hot rod or
something), which wasn't in my products table. I have so far create...
|
2 |
25.07.2006 17:23:02 |
|
|
Using sales invoice template
I am using a sales invoice template and am adding parts with out the shown
lines. When I try to add an additional line on the first page it will show a
line. How do I get another line without seeing this line?...
|
2 |
25.07.2006 17:08:02 |
|
|
Access Database Problem
I have a website on a server running Windows 2000 Advanced Server.
When I download the database and run Compact and Repair Database using
Windows XP and Access 2000 if performs corrected. I then reupload the
database and the Queries in my website no longer work. I then download the
database to see why there are problems and the database appears to be
corrupt. I try to run Compact and r...
|
2 |
25.07.2006 17:06:02 |
|
|
Multiple field query
I'm fairly new at using Access. I've got myself stuck on something that I
think should be fairly easy. Here goes my example . . . a form containing
several list boxes--one box has Grocery Store A, Grocery Store B, Grocery
Store C. Another has apples, oranges, milk, bread, etc. I would like to
choose Grocery Store B as well as apples and oranges and have those records
open on click of...
|
5 |
25.07.2006 14:42:01 |
|
|
ADDING A FORMULA TO A CELL
I am trying to add a formula to a cell which looks at a date in the next
field and finds out if that date is < Now(), if so then send email.
If this is at all possible please help!!
Many Thanks
...
|
6 |
25.07.2006 14:33:02 |
|
|
Acess Forms
I am trying to create an Access form where the parent form will have 4
sub forms attached which shall contain the details of a different
person. Each sub form shall have a unique ID which will relate to that
person however if that person is used again on other parent forms sub
form then they will be recognised by their ID number.
The problem I am encountering is that I can get people created ...
|
3 |
25.07.2006 12:17:46 |
|
|
isbn
1. l failed to enter ISBN number in my form. For details;
Field Name; ISBN number
Data type : Number
Field Size;Long Integer
Decimal places: Auto
Note; please tell me what should l do?
2. l'm using short date .when l enter 11/12/2006 it changes to 12- Nov-2006
but if l enter 23/12/2006 it's o.k (23-Dec-2006).l realise that all numbers
below than 12 give me headache for example 4/12/200...
|
4 |
25.07.2006 11:40:18 |
|
|
Check for missing field in edit form
I have a form (RegEditForm) linked to a control source table (HYInReg) In the
table the field Hyperlink1 is set Yes for required. If a user makes a change
and accidently leaves any of the other fields blank I can get a message to
appear using the beforeupdate event procedure as follows.
Private Sub ForwardedTo_BeforeUpdate(Cancel As Integer)
If IsNull(Me.[ForwardedTo]) And Not IsNull(M...
|
9 |
25.07.2006 11:27:41 |
|
|
emailing a report grouped
Sorry, I know this is confusing, but I have to believe I am not asking
for something crazy here. I have a database with 100 rows in it. Of
the 100 rows, most have the same customer, but the rows are different
because they have different products they are selling.
So, what i want to do, is create a single email to a given customer
with all their products on the page (meaning multiple rows in...
|
2 |
25.07.2006 07:26:02 |
|
|
THE Option Button in the toolbox How i can use it?
Hi, is there is such a code to verify is an option button is
selected??
& what is the option group?
& if there is such a code where i wriet it? I mean in which event
thanks for any help
...
|
5 |
25.07.2006 07:26:02 |
|
|
Changing Resolution of screen
Hello
I need a simple code or even few commands to change resolution of screen...
|
14 |
25.07.2006 04:45:13 |
|
|
Add Item to Table with Lookup Box
I am trying to have an Item added to a Table when it is not included in the
Drop Down combo box. Have tried to enter the code in a module as advised on
allenbrowne.com/ser-27.html, but as code is a little strange to me, I do not
understand for eg: dim vfield As Variant 'Name of field to append to.
The Table is a seperate table called "Country of Birth" which is linked to
the main for...
|
14 |
25.07.2006 02:48:02 |
|
|
cant unlock switchboard controls
Hi
I generated a switchboard and I'm trying to add the ability to open a report
and set the recordsource property based on the value the user entered into
the textbox on the switchboard. However I cant type anything into the textbox
i put on the switchboard. Its enabled and unlocked and i can focus on it but
cant enter a value into it. any ideas?
TIA...
|
2 |
24.07.2006 21:31:02 |
|
|
Book or website?
Hi,
Could anyone suggest a book or a website that would tell a beginner
(me!) what all the items in the properties box of my form fields mean, i.e.
"on dirty", "can grow". "enter key behavior"? Thanks!
...
|
3 |
24.07.2006 21:22:49 |
|
|
Query to return records
I have a table that has 2 fields that are either "p" or "r". I'm trying to
create a query that will retieve records that are true to the following
condition:
field #1 is R and field #2 is R
field #1 is R and field #2 is not
field #1 is Not and field #2 is R
Can anyone help?
...
|
7 |
24.07.2006 21:13:01 |
|
|
Starting a new project
I'm getting the message Object variable or With block variable not set when
trying to create a New Project (New Data). I'm using Access 2002 - anyone
got any ideas why the wizard grinds to a halt there?
Cheers,
Guy...
|
3 |
24.07.2006 20:16:02 |
|
|
Print Preview in duplicate!
Hi there.. Thanks in advance
I'm building a form. I have the form header and some fields in the body of
the form. All of a sudden, when I check the print preview, I'm seeing the
body of the form in duplicate... one beneath the other... separated by a line.
Oh, it also prints out that way...
Help!...
|
9 |
24.07.2006 19:54:02 |
|
|
Afterupdate to populate form
I have 1 form which i want to use for viewing (and adding) employee details.
I have a combo box in the header of the form, cboSchemeID. Basically i want
to choose the scheme from the dropdown list cboSchemeID and then have it only
show employees from that scheme, sounds simple!
All of the other controls on the form are populated by a query
QryCompanyFormDetails. The records display fine ...
|
27 |
24.07.2006 19:24:03 |
|
|
Where's the "font list" on formatting toolbar in design view? v200
Where's the "font list" on formatting toolbar in design view? I am using
version 2002, and the book "Step by Step" (a microsoft publication)
references it, but doesn't say where it is. Thank you...
|
2 |
24.07.2006 16:18:15 |
|
|
Why don't I have access in office 2003?
I downloaded Office 2003 and thought I gt all the programs but Access is not
in my folder. Does anyone know why not, and ifI am suppose to have it, how
can I get it back?...
|
3 |
24.07.2006 15:44:58 |