Search results

Ok well basicly i want it so that when i select a record in the datasubform it will show all the edits made to that document on the log form, this is to keep the user updated on the document they are looking for. Example: I select a record from the datasubform and that record has a document...

Ok well basicly i want it so that when i select a record in the datasubform it will show all the edits made to that document on the log form, this is to keep the user updated on the document they are looking for. Example: I select a record from the datasubform and that record has a document...

Hi, I have access 97 so your dd didnt work. I dont understand what you mean with the two tables, but i have my database here if you want to take a look. There are still a few problems with the queries and so on that i have to figure out too but yea. Thanks for your time, Leon

Hi again, Ok so here is what happend when i opened the dd you changed. - I went to open 'TheForm' and the OLE hyperlink error came up again. So i removed the hyperlink field from the 'TEST2' query. - This worked and made the datasubform hide any duplicates, but the logsubform shows no records...

Ok thanks :)

Hey, ive sent the database to your msn email, in an attachment.

I have and it runs but the records are still duplicated like there has been no change what so ever.

Yea i have done that but there is nothing to do with memo or OLE anywhere.

yea done that but there is nothing to do with memo or OLE anywhere

can i change it without affecting the records?

I dont know how would i check that?

No i havent tried any of that, didnt think i would need to but this is what it says when i add your code to my query. prb1.jpg Could it be because our our different os's and ac versions?

yes but it didnt work, it said that the OLE for the hyperlink column wont work, so i removed the hyperlink column but it still show duplicate records in datasheet view.

Hi, I have a form that has a list of textboxes linked to table properties, and a subform linked to the same table. I used the command button wizard to create an add record command, but when i click on it it comes up with: You cant go to the specified record You may be at the end of a record...

lol hey what about links to other threads?

This is basicly what i need: Before After

Maybe but how would i do that?

Yea that is the UniqueValue property which i tried, but it says the OLE can be used on hyperlinks and my tables contain hyperlinks. Also when i remove the hyperlink column from the query it still shows duplicate records. Thanks tho

Ok here is the sql data for the 'test' query SELECT DISTINCTROW Log.LOGDEX, Log.[DOCUMENT NUMBER], Log.NAME, Log.DATE, Log.COMMENT, DRAWINGS.DESCRIPTION, DRAWINGS.HYPERLINK, DRAWINGS.[ISSUE DATE], DRAWINGS.[DOCUMENT NUMBER], DRAWINGS.[LAST PRINT DATE], DRAWINGS.REVISION, DRAWINGS.ORIGINATOR...

Hi, Yea i have tried that but it says the OLE doesnt work for hyperlinks, and i hayperlinks. Also the data does need to be editable. The edit log subform is what is causing the problem in the first place becuause im trying to have more than one edit records for only one document record (1 to...