Microsoft Access Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Database > Microsoft Access Help
Reload this Page

Linking two columns in a second Table

Discuss Linking two columns in a second Table in the Microsoft Access Help forum on ASP Free.
Linking two columns in a second Table Microsoft Access forum discussing questions and answers for the Access database. MS Access is used to handle small to medium database needs.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old January 7th, 2004, 05:32 AM
The Architect The Architect is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: London
Posts: 9 The Architect User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Linking two columns in a second Table
Help !!!!!!! calling all Guru's

I am trying to link two colomns together from one Table (tblLettersAndNumbers) into two seperate colomns in a second Table (tblLettersAndNumberConnected).
The complication is that the columns in tblLetterAndNumbersConnected need to be drop downs and if you select the Numbers column the Letter column should update atomatically (and Vice-Versa) e.g if you select number 1 letter A will apear.

My database is more complicated than the above example, so I have created the Test.mdb (attached) database to make it easier to explain.
Attached Files
File Type: zip test.zip (11.0 KB, 174 views)
Reply With Quote
  #2  
Old January 7th, 2004, 07:31 AM
TBÁrpi's Avatar
TBÁrpi TBÁrpi is offline
Lazy User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: Hungary, Europe
Posts: 337 TBÁrpi User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 13 h 5 m 5 sec
Reputation Power: 5
Send a message via MSN to TBÁrpi Send a message via Yahoo to TBÁrpi Send a message via Skype to TBÁrpi
This cannot be done in the table itself, but can in a form.

Attached is your database.

Have a look at the code behind the form and you will see how it works.
Attached Files
File Type: zip thearchitectok.zip (18.8 KB, 232 views)
__________________
BRegs,
TBÁrpi
"I can only show you the door. You're the one who has to walk through it."
Reply With Quote
  #3  
Old January 7th, 2004, 07:40 AM
The Architect The Architect is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: London
Posts: 9 The Architect User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Main thanks TBÁrpi.

But I 'm getting an error message (attached) when I select either of the the drop down menu's in the FORM you created ????

Cheers
Chris
Attached Images
File Type: gif error message.gif (45.5 KB, 147 views)
Reply With Quote
  #4  
Old January 7th, 2004, 07:49 AM
TBÁrpi's Avatar
TBÁrpi TBÁrpi is offline
Lazy User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: Hungary, Europe
Posts: 337 TBÁrpi User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 13 h 5 m 5 sec
Reputation Power: 5
Send a message via MSN to TBÁrpi Send a message via Yahoo to TBÁrpi Send a message via Skype to TBÁrpi
Chris,

Check if the necessary libraries are referenced as attached.

To map them, go to Tools -> References... menu path in VB Editor.
Attached Images
File Type: jpg thearchitect_references.jpg (40.0 KB, 126 views)
Reply With Quote
  #5  
Old January 7th, 2004, 08:01 AM
The Architect The Architect is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: London
Posts: 9 The Architect User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Sorry to be a pain......
but I have just checked that my libraries are referenced and they look exactly the same as yours ????????

Chris

As a thank you try this link as the best post christmas game
http://www.7fire.com/flash/TurkeyShooter.swf
Reply With Quote
  #6  
Old January 7th, 2004, 08:09 AM
TBÁrpi's Avatar
TBÁrpi TBÁrpi is offline
Lazy User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: Hungary, Europe
Posts: 337 TBÁrpi User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 13 h 5 m 5 sec
Reputation Power: 5
Send a message via MSN to TBÁrpi Send a message via Yahoo to TBÁrpi Send a message via Skype to TBÁrpi
Hmmm.... however, it works fine for me...

Have you tried to Copress and Repair? Or Compile your project?
Reply With Quote
  #7  
Old January 7th, 2004, 08:21 AM
The Architect The Architect is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: London
Posts: 9 The Architect User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
The error message is appearing in the FORM you created in the TEST.mdb database I sent you, I have just tried the COMPACT & REPAIR option but it didn't fix the problem.
I have reattched the TheArchitect.mdb file, just incase it got corrupted in the transfer ????????

Once again thanks for your help.
Attached Files
File Type: zip thearchitect.zip (17.6 KB, 256 views)
Reply With Quote
  #8  
Old January 7th, 2004, 08:29 AM
TBÁrpi's Avatar
TBÁrpi TBÁrpi is offline
Lazy User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: Hungary, Europe
Posts: 337 TBÁrpi User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 13 h 5 m 5 sec
Reputation Power: 5
Send a message via MSN to TBÁrpi Send a message via Yahoo to TBÁrpi Send a message via Skype to TBÁrpi
Still works fine.

I select a number, and the correspondig letter appears in the other drop-down list and vice versa.

I have to say:

I'll post this to the Moderators' Longue and ask others to have a look at it.
Reply With Quote
  #9  
Old January 7th, 2004, 08:35 AM
The Architect The Architect is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: London
Posts: 9 The Architect User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thank you .......
for trying.

Regards
Chris
Reply With Quote
  #10  
Old January 7th, 2004, 09:18 AM
TBÁrpi's Avatar
TBÁrpi TBÁrpi is offline
Lazy User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: Hungary, Europe
Posts: 337 TBÁrpi User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 13 h 5 m 5 sec
Reputation Power: 5
Send a message via MSN to TBÁrpi Send a message via Yahoo to TBÁrpi Send a message via Skype to TBÁrpi
Below is one of my colleague's suggestion

Quote:
See if this will help him out.

MSDN Suggestion

I would also suggest telling him/her to run a virus scan on the machine...this error was quite common when the MSBlaster virus infected computers.
Reply With Quote
  #11  
Old January 7th, 2004, 09:31 AM
The Architect The Architect is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: London
Posts: 9 The Architect User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Virus Scan
Our system is updated dailey using McAvee VirusScan Enterprise software, we are currently using - Virus Definition 4312 - Engine 4.2.60.
Plus I run the Stinger on all PC's periodically, because I am paranoid, I have just downloaded the lastest Stinger and all is clear.

Cheers
Reply With Quote
  #12  
Old January 11th, 2004, 05:03 PM
TBÁrpi's Avatar
TBÁrpi TBÁrpi is offline
Lazy User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: Hungary, Europe
Posts: 337 TBÁrpi User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 13 h 5 m 5 sec
Reputation Power: 5
Send a message via MSN to TBÁrpi Send a message via Yahoo to TBÁrpi Send a message via Skype to TBÁrpi
Another answer:
Quote:
Re: OLE server or ActiveX control
Sorry it took so long to get back to you. Haven't been checking my private message often enough

I get the same error, and I don't have a reason for it either. However, with that said, he doesn't need the Dlookup to do what he is after. Delete the statements and the reference to the Update event and the form works fine.

I found that as soon as I deleted all code it worked fine. As soon as I added a after update event (with out adding any code, i got that problem too, as if the code was there, it is the actual afterudpate event (timing if event, I think) that is causing the problem. Because there is a lookup in the table design the code isn't neccesary.

S-
Reply With Quote
  #13  
Old January 12th, 2004, 03:37 AM
The Architect The Architect is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Location: London
Posts: 9 The Architect User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Good morning
Thank you TBÁrpi.

You have completely lost me now, I'm not a great one for VBA or code, I'm just a simple architect, is there any chance of sending the DB back with the code deleted as mentioned, so that I can have look and see what needs to be done.

regards chris
Reply With Quote
Reply

Viewing: ASP Free Forums > Database > Microsoft Access Help > Linking two columns in a second Table

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
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
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support |