Unable to remove master -> child subform links in microsoft access 2003

Posted by Doug on Stack Overflow See other posts from Stack Overflow or by Doug
Published on 2010-04-16T16:40:02Z Indexed on 2010/04/16 16:43 UTC
Read the original article Hit count: 463

Filed under:

msaccess

|

ms-access-2007

|

ms-access

|

access-vba

Hi,

I am having an issue removing the master -> child link fields in an access subreport data form. I have tried every avenue to remove them, using the properties window of the subreport as well as the link wizard. I have also deleted the subreport from the database and then gone as far as re-importing the existing objects into a new access instance. As soon as I re-added the subform back in and name it the same name the link fields show back up. Something is apparently corrupt, but I have run out of ideas at this point on how to clear them.

Any Ideas would be appreciated.

Thanks Doug

© Stack Overflow or respective owner

Related posts about msaccess

Starting a VC++ .exe from MSAccess

as seen on Stack Overflow - Search for 'Stack Overflow'
For a complex calculating problem we use an VC++ module (.exe). For the users we have build an ms Access application as userinterface. After input dthe calculating module should start and do its job. The result is again imported in Ms Access. However we work wit dBase files (.dbf) as datafiles. The… >>> More
Exception in MSAccess when adding datas with ' character

as seen on Stack Overflow - Search for 'Stack Overflow'
i am using windows forms application with MSAccess.... i got data from database table successfully but when i am trying to add data with (') character i got the exception that "OLEDB Exception: Syntax error(Missing Operator)inquery expression" ... Now how can i solve this problem? Plz tell me the… >>> More
Rebol MSAccess ODBC: works with DNS connection but not with DNSLess Connection

as seen on Stack Overflow - Search for 'Stack Overflow'
I have tested the new free Rebol ODBC with MS Access after reading the doc here http://www.rebol.com/docs/database.html It works with ODBC DNS connection but when I tested with this DNSLess connection (MSAccess2003 file with MSAccess2007 installed): connect-name: open [ scheme: 'odbc target:… >>> More
MSAccess: select N records from each category

as seen on Stack Overflow - Search for 'Stack Overflow'
I can't solve this on MS Access SQL. I have a foo table with this fields: id, title, category, date I need to show 6 records showing the 2 most recent items from each category For example, I have: ID TITLE CAT DATE ------------------------ 1 aaa cat1 12/03/12 2 sdfs cat2… >>> More
Max Value for MSAccess Date/Time

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the latest date that can be represented in Microsoft Access? >>> More

Related posts about ms-access-2007

remove autoexec macro from MS Access 2007

as seen on Stack Overflow - Search for 'Stack Overflow'
I have created an autoexec macro in MS Access 2007 and cannot find it! I know its there because it runs, but I cannot find it to delete or modify. I can see other macros that I have created just not the autoexec one. Can someone please point me in the right direction to find where it is located… >>> More
How to connect to MS Access 2007, from Java on a mac

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking for a way to connect to a MS Access 2007 database from Java. I don't believe the ODBC way is available to me as I'm writing on a mac and will be pushing this product to Linux. The HXTT drivers also do not work with 2007. Is there a way, a tutorial, an example, etc that accomplishes this… >>> More
Can't change data type on MS Access 2007

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I have a huge database (800MB) which consists of a field called 'Date Last Modified' at the moment this field is entered as a text data type but need to change it to a Date/Time field to carry out some queries. I have another exact same database but with only 35MB of data inside it and when… >>> More
Help with Ms Access 2007 Combo boxes

as seen on Super User - Search for 'Super User'
What's the most efficient way to "chain" combo/boxes in an Access 2007 form, so that the result of the first affected the contents of the second? I already know how to associate a combo box on a form with a query. Here's a example of my scenario: cmbCarMake Behavior: User starts typing, and list… >>> More
MS-Access 2007 Time Online Report

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following data in my database: MemberID | DateTime ------------------------------------- 1 | 31/03/2010 3:45:49 PM 2 | 31/03/2010 3:55:29 PM 1 | 31/03/2010 4:45:49 PM Every time a user is authenticated or un-authenticated this log appears in the database… >>> More