PC Review


Reply
Thread Tools Rate Thread

Data Relations and i`ll even pay someone now to tell me!

 
 
Merlin
Guest
Posts: n/a
 
      2nd Mar 2004
Hey All,

I`ll Pay someone to tell me this now, as its doing my head in, I carn`t see
out on the net and no one seems to know!

I have a form that connects to a Access database, and I have a combo box on
this form (this combo box has a list of Access Levels, a user would be
able to choose one Access Level out of the combo box).

The combo box is serving double duty, as they usually do, it is giving me a
list of all of the Access Levels in a drop down, and it is also returning
the Access Level of the record that I am retrieving from my Access Database.

Everything works perfectly, but. . .

When I navigate through my records, the combo box (Access Level) does not
change with what the Access Level should be for that particular record, it's
almost like it sticks on the same Access Level. The AccessLevelID
(different text box) changes with every record but the combo box doesn't.

I did some troubleshooting. . .

If I put a text box in place of the combo box it works correctly, but this
does not solve the problem of the user being able to select a Access Level,
hence the need for a combo box.


I`ver tryed to explain this before but unforutnatle i don`t think im
explaining properly, i have a example project that I could e-mail if anybody
could offer me some help?

Any links as I don`t mind reading

Please help.

Thanks.
Merlin





 
Reply With Quote
 
 
 
 
Cor
Guest
Posts: n/a
 
      2nd Mar 2004
Hi Merlin,

Because you get no answers, show us some code as sample, not all just to
inform us what you try to archieve. (How do you build the relations by
instance)

Cor


 
Reply With Quote
 
Merlin
Guest
Posts: n/a
 
      2nd Mar 2004
Hey Cor,

Thats what I have trouble in explaining, I cannot imagine me going throught
the whole procedure, and if I give screen shoots and that would make people
unhappy as there big.

My Project is located @ http://www.forecourtsupport.co.uk/App1.zip and can
be download for people to see

Thanks
Merlin

"Cor" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Merlin,
>
> Because you get no answers, show us some code as sample, not all just to
> inform us what you try to archieve. (How do you build the relations by
> instance)
>
> Cor
>
>



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004


 
Reply With Quote
 
Cor
Guest
Posts: n/a
 
      3rd Mar 2004
Hi Merlin,

I have looked at your problem, I saw one thing that is strange in my eyes,
there is a relation in the XSD from your Access Id to the UserID, should
that not be to the AcceslevelID from the user.

And you did not do it in a simple (but I think not a wrong) way. I will not
change your code totaly but take your approach to try to help you.

A problem for me is that you have used all wizards as possible as far as I
can see. When this is not the problem, maybe you can than make a sample mdb
file with 2 accesscodes and 2 users in the way that you made it and add that
to your zipfile.

(It has to be today, tomorrow I have absolute no time for this or else it
will be friday).

Cor


 
Reply With Quote
 
Cor
Guest
Posts: n/a
 
      3rd Mar 2004
Hi Merlin,

I think I found your problem, the answer is in the adonet group.

Cor


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Relations In ASP.net Dave Hagerich Microsoft ASP .NET 0 3rd Oct 2005 06:40 PM
ACCESS relations: table clones doesn't keep relations =?Utf-8?B?U3VwZXJib3k=?= Microsoft Access 1 19th Jul 2005 10:57 PM
data relations Joe Van Meer Microsoft ASP .NET 4 5th May 2004 07:57 PM
Data Relations and Ill pay someone now Merlin Microsoft ADO .NET 8 3rd Mar 2004 03:21 PM
Need help with data relations Pierre Microsoft ADO .NET 0 27th Oct 2003 02:38 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:21 AM.