Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Access 2007 error..


(!)

Daisie's Avatar
Daisie Daisie is offline
Member with 9 posts.
THREAD STARTER
 
Join Date: Apr 2012
Experience: Intermediate
24-Apr-2012, 10:24 AM #1
Access 2007 error..
When trying to select a choice from a drop-down in a new form; the info line shows this..
"Cannot add record(s); primary key for table 'dbo_Asset_Type' not in recordset.".. almost like it is expecting the record to already be there?
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 49,936 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
Experience: Intermediate
24-Apr-2012, 10:41 AM #2
moved to business applications forum
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,441 posts.
 
Join Date: Mar 2005
Location: UK
24-Apr-2012, 11:00 AM #3
What is the Control Source of the Drop Down list.
Daisie's Avatar
Daisie Daisie is offline
Member with 9 posts.
THREAD STARTER
 
Join Date: Apr 2012
Experience: Intermediate
24-Apr-2012, 11:02 AM #4
Asset_Type_dbo_Asset_Type is the control source and SELECT dbo_Asset_Type.Asset_Type FROM dbo_Asset_Type; is the row source
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,441 posts.
 
Join Date: Mar 2005
Location: UK
24-Apr-2012, 11:07 AM #5
It is a bit difficult from that description to tell if the drop down row source is coming from a different table to the Control source.
Daisie's Avatar
Daisie Daisie is offline
Member with 9 posts.
THREAD STARTER
 
Join Date: Apr 2012
Experience: Intermediate
24-Apr-2012, 11:11 AM #6
Ok, tell me how to get you a copy of the property sheet.. I have a copy of it in Excel.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,441 posts.
 
Join Date: Mar 2005
Location: UK
24-Apr-2012, 11:15 AM #7
That will do, you can post it on here as an attachment using the "Go Advanced" and Manage Attachment buttons.
A copy of the table relationships would be helpful as well.
Daisie's Avatar
Daisie Daisie is offline
Member with 9 posts.
THREAD STARTER
 
Join Date: Apr 2012
Experience: Intermediate
24-Apr-2012, 11:21 AM #8
At this point I don't have any relationships.. could that be the problem?
Attached Files
File Type: xlsx error.xlsx (194.0 KB, 19 views)
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,441 posts.
 
Join Date: Mar 2005
Location: UK
24-Apr-2012, 11:22 AM #9
It shouldn't be the relationships, can you save the Excel sheet in Excel 2003 and re-post it please?
Daisie's Avatar
Daisie Daisie is offline
Member with 9 posts.
THREAD STARTER
 
Join Date: Apr 2012
Experience: Intermediate
24-Apr-2012, 11:49 AM #10
Here you go.
Daisie's Avatar
Daisie Daisie is offline
Member with 9 posts.
THREAD STARTER
 
Join Date: Apr 2012
Experience: Intermediate
24-Apr-2012, 11:50 AM #11
Had to zip it.
Attached Files
File Type: zip error.zip (181.4 KB, 1 views)
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,441 posts.
 
Join Date: Mar 2005
Location: UK
24-Apr-2012, 11:55 AM #12
What field type is the Asset_Type_dbo_Asset_Type in it's table?
What field type is the Asset_Type in the dbo_Asset_Type table?
Daisie's Avatar
Daisie Daisie is offline
Member with 9 posts.
THREAD STARTER
 
Join Date: Apr 2012
Experience: Intermediate
24-Apr-2012, 12:02 PM #13
Asset_Type is an integer that feeds to the Asset_Inventory table (feeding the ID) and Asset_Type has the ID (int) and Type (nchar) columns.
Daisie's Avatar
Daisie Daisie is offline
Member with 9 posts.
THREAD STARTER
 
Join Date: Apr 2012
Experience: Intermediate
24-Apr-2012, 12:02 PM #14
At least that's what I want it to do.. I want the drop-down to show the type but feed the id to the other table.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,441 posts.
 
Join Date: Mar 2005
Location: UK
24-Apr-2012, 12:09 PM #15
That is what should happen, but only the ID should be stored. The first column in the Drop down should be the ID and set to 0cm width to hide it and should be the Bound column. The second column should then display the Asset_Type.
If this was Access 2003 I could take a look for you, but I can't work with Access 2007/10.
__________________
OBP
I do not give up easily
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑