|
How to use a many-to-many table to retrieve (query) data for a for
Hello, I saw an earlier posting that related to this question but the
response didn't quite answer my question. I created the following Access
tables and fields.
tblWriter
WriterID - Autonumber
WriterName - text
tblProject
ProjectID - Autonumber
ProjectName - text
tblWriter_Projects - (many-to-many joining table)
WriterID - number
ProjectID - number
If I want to display, in a...
|
2 |
23.09.2006 13:59:01 |
|
|
where do i locate the font various sizes?
I need to make LARGE very LARGE letters for the cover of a book. HOW do I
do this ?...
|
2 |
23.09.2006 02:53:16 |
|
|
how export access table to excel
The access table has 50K rows, but I can't export all rows to excel....
|
2 |
23.09.2006 01:01:14 |
|
|
how down load access file to excel
The table has over 50K rows, but I can't export all the rows into excel....
|
7 |
22.09.2006 23:48:59 |
|
|
3.5 disk
How to erase just one folder from a 3.5 disk, without erasing the entire disk?...
|
3 |
22.09.2006 21:38:20 |
|
|
Junction tables and data entry
I was told some time back that my project needed a couple of junction tables.
Specifically, I'm working on a legal case database, and I need to collect
data about the parties involved in every case. The primary tables for the
project, tblCase and tblParty, have a "many-to-many" relationship, hence the
need for the junction tables.
What I don't know is how the junction tables get popul...
|
5 |
22.09.2006 19:50:02 |
|
|
How do I get a text field to automatically copy itself elsewhere?
I don't want to enter the same data repeatedly (such as name, street address,
etc)....
|
4 |
22.09.2006 19:18:01 |
|
|
followhyperlink
I would like to open a specific Word document based upon what is selected in
a combo box on my form. I figured out how to open a document by clicking on
a control box so now I'm ready for the next step. Here's what I have.
Application.FollowHyperlink "F:\Public\mechanisms database\1A1457-LBW1A" &
".doc"...
|
1 |
22.09.2006 18:30:02 |
|
|
Action query - help please
Hi all.
I have a database with two tables:
T_Clients
T_Tasks
T_Clients has two fields:
ClientID = autonumber, primary key
ClientName = text, indexed, no duplicates
T_Tasks has three fields:
TaskID = autonumber, primary key
ClientID = number
Date = date/time
There is a one(T_Clients)-to-many(T_Tasks) relationship between ClientID
fields with enforced referencial integrity.
I w...
|
11 |
22.09.2006 18:22:08 |
|
|
plan for job presintation
i need something to present to customers. not sure how to do it excactly, i
want something to put in a folder to take with me when im out, that shows
what i do, how much i do it for and what ever else that should go with it.
please let me know if anone can help.
Jason...
|
2 |
22.09.2006 14:36:27 |
|
|
Is there a better way
Just trying to find out if I am writing my code in the correct way. The Block
should be self explanitory but is there a better way to write it?
Public Function util_GetNewContractNo(a As Long) As Long
'*****************************************************************=**********************
' Name: util_GetNewContractNo :- Utility Number 2
' Purpose: Store and incre...
|
4 |
22.09.2006 13:51:34 |
|
|
One-to-one relationships
When creating a one-to-one relationship between two tables, does it ever
make a difference which table you drag across to the other? If it does,
could someone please in layman's terms briefly explain the significance?
Thanks
--
Return email address is not as DEEP as it appears
...
|
4 |
22.09.2006 13:04:39 |
|
|
Have date automatically go into another form
Hellllllllllllllllllllllllp!! Okay I literally know nothing about
programming or access - but I did manage to create tables and forms.
My question is this: I have two forms one form is an application for a
discount card that the company I work for sells - the second form is the
invoice receipt - so basically is has most of the same information as the
first form
Can I get the informatio...
|
4 |
22.09.2006 13:03:02 |
|
|
how to import from excel
I am trying to import data from excel into access and the problem i have is
that access has the fields going across the page in the datasheet view of a
table layout whereas in my spreadsheet the data that i want to use is laid
out in such a way that the fields would be down the page. I have tried the
option of the first row contains column headings but that doesn't do me any
good. Have i...
|
4 |
22.09.2006 12:03:32 |
|
|
How do I reregister my microsoft?
Upon registering my free trial version of Microsoft 2002 it brought me to an
external link on the internet in which I started to complete then I became
unsure of myself and exited the window. When I tried to see if Microsoft was
working it was locked. I tried reentering the activation code or "Trial Key"
but it wouldn't work....
|
2 |
22.09.2006 11:17:57 |
|
|
How do i set up command buttons on a form
Hi,
I have created a form and want to put two buttons on it to a) find a record
and b) add a new record. Can anyone tell me if this is relatively straight
forward?
Thanks
Jamie...
|
3 |
22.09.2006 10:55:01 |
|
|
To: Albert D. Kallal
Today you've addressed two of my mysteries with some degree of depth. Would
you mind looking "Repost: Yet another problem with 'No current record'", in
Access.formscoding, dated August 26? I was just about to take a vacation day
to go to my local Access Users Group for their clinic, to see if anyone
there could solve it.
tia
las
...
|
5 |
22.09.2006 08:01:43 |
|
|
how do i add follow up calls in access so they pop up on the date.
How do I make access more intuitive and able to record relevant information
in a sales scenario.I'd like to have my future call dates simply pop up on my
computer when I open access to remind me of the calls I need to make....
|
2 |
22.09.2006 04:34:33 |
|
|
Help With Query
I have a query that is returning results and records from various tables and
I need to set up some type of conditional expression or something that will
provide the results I need. The fields I am working with contain:
BrTp - this field contains records like B, F, A
BOD - this field contains records like RU, RV, N1
LT - this field contains numbers - 1,2,3,4,etc...
Inv - this field also ...
|
2 |
22.09.2006 04:14:04 |
|
|
Error Handling Code Library
Does anyone know a good source of error handler code library that I can
just copy and paste into my module and is ready to use? Thanks in
advance.
- 009
...
|
9 |
22.09.2006 03:55:59 |
|
|
Chart Control
I have software(Chartrunner) that automatically pulls data from my database
and creates a chart. I would like to have the chart appear on my database
form. How can I have my form call out the file name of the chart I want
displayed?...
|
2 |
22.09.2006 03:34:21 |
|
|
How do I merge data from 2 identical databases?
I have three databases, structures are all identical. There is supposed
to be only one database, but users have been entering data in all 3, so
all of them have different data. Is there a way to union the data in
the existing tables of all three into one master database?
I know next to nothing about MS Access.
Thanks!
...
|
3 |
21.09.2006 21:23:11 |
|
|
After checking on an update - stop user proceeding on a condition
John kindly gave me a way to check on the existence of a file
that the user is inputing - if the test fails - the file does
NOT exist - I want to stop the user proceeding with the add and
maybe clear the form ?
Any ideas on this would be great.
Thanks...
|
4 |
21.09.2006 19:34:57 |
|
|
When to default Number fields to 0?
I have just been looking at a database where all number fields are set to
default to 0 at table level. I know this is the default setting but I
previously I have either always set number fields to default to null or a
quantity/primary key value if applicable. Is there any advantage in setting
number fields to default to 0? I can imagine it being used when a quantity
is genuinely 0 e.g...
|
3 |
21.09.2006 16:41:01 |
|
|
how do I set up a data base report with drop down menu's?
...
|
4 |
21.09.2006 15:33:37 |