help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have tried posting this question in othe forums but had no reply

on form1 i have a command button that represents a card 1 of 12
click the button and it opens a form viewdetail this form has veveral text
boxes and comboboxes one is to select the cable pair connected to that card 1
to 12
(pair 1 is not necessarily connected to card 1) i have a table pairs 1 to 12
which is used in this combobox when selected pair 1 it appears in form 1 text
box pairs
my problem is that if pair 1 is used (this record only) i do not want when
card 2 is selected and the user selects which pair they want to connect to be
able to select pair 1 again ie only 2 to 12 is available (each time one is
used it disapears from the combobox) of course moving to the next record all
12 are available again.

it driving me nuts
thanks in advance for any help
 
Arnie,

Your question doesn't have much in the way of punctuation, capitalization,
grammer, or sentence structure. It's one long run-on sentence and about
impossible to understand. No wonder that you haven't received any response.
Please spend some time re-writing it so that we can better understand. If you
are not a native English speaker, there are newsgroups devoted to other
languages.
 
i have form called form1 i have a command button that represents a card 1 of
12 command buttons.

when this button is depressed it opens a form called viewdetail Card 1.

on this form is a combo box called Pairs.

it gets its Data from a table called Pairs.

The Data is a list 1 to 12 representing cable pairs in a 12 pair cable.

If I select Pair 1 for that Card, then I go to Card 2 viewdetail form to
select a Cable Pair for that Card to be linked to I want Pair 1 not to be
visible in the list from the Pairs Table

in a nutshell how do you prevent an entry being shown in a combobox once it
has been used

I thought this was a forum for techies and programmers not an english lesson
 
i have form called form1 i have a command button that represents a card 1 of
12 command buttons.
Click to expand...

What's a "card"? Access doesn't have cards; I presume this is some sort of
entity within your application. What is the Recordsource view of the form?
when this button is depressed it opens a form called viewdetail Card 1.
Click to expand...

Please post the code.
on this form is a combo box called Pairs.

it gets its Data from a table called Pairs.

The Data is a list 1 to 12 representing cable pairs in a 12 pair cable.
Click to expand...

So the combo box just has twelve rows, integers 1 to 12?
If I select Pair 1 for that Card, then I go to Card 2 viewdetail form to
select a Cable Pair for that Card to be linked to I want Pair 1 not to be
visible in the list from the Pairs Table
Click to expand...
in a nutshell how do you prevent an entry being shown in a combobox once it
has been used
Click to expand...

Base the Combo Box on a "Unmatched Query" wizard query joining a table with
twelve records (1 to 12) with the Pairs table. Use a "Left Outer Join" in the
query, and a criterion of IS NULL on the Pairs table field, to select only
those values NOT in the pairs table.
I thought this was a forum for techies and programmers not an english lesson
Click to expand...

It's a completely volunteer-staffed peer support forum. We answer questions to
help each other... and some of us get testy when questions are unclear, hard
to interpret or ambiguous.

John W. Vinson [MVP]
 
John thanks for your answer. I have taught myself Access and therefore very
inexperienced in this application. When creating the join which one do I use
1 2 or 3 and in the table with 12 records do I make the entries empty?
 
John thanks for your answer. I have taught myself Access and therefore very
inexperienced in this application. When creating the join which one do I use
1 2 or 3 and in the table with 12 records do I make the entries empty?
Click to expand...

I cannot see your database, Arnie. I have no clue what you mean by "1 2 or 3
in the table".

Please post the structure of your table in the format

Tablename
Fieldname Datatype
Fieldname Datatype

and indicate which field is the primary key.

John W. Vinson [MVP]
 
needing help also - very new to using access, just set up a data base wanting
to know if two people are using the same database at one time what to do to
keep all the information current, for example, my boss is working in the
comment section of the database and at the same time, I'd like to be inputing
more contact names/numbers how do we put all of this information together and
not worry about losing data or re-entering data? thanks will take any help I
can get :)

Stephanie
 
needing help also - very new to using access, just set up a data base wanting
to know if two people are using the same database at one time what to do to
keep all the information current, for example, my boss is working in the
comment section of the database and at the same time, I'd like to be inputing
more contact names/numbers how do we put all of this information together and
not worry about losing data or re-entering data? thanks will take any help I
can get :)
Click to expand...

Just so long as you're not editing the same record at the same time, you
should be fine.

I would strongly suggest using a "split" database - a shared "backend"
database containing the tables, and each of you using your own copy of a
"frontend " linked to the tables and containing the forms, reports, etc. See

http://www.granite.ab.ca/access/splitapp.htm

for how and why to set this up.

John W. Vinson [MVP]
 
Back
Top