Search results

Just to reiterate, its not a Primary Key and its not a autonumber, I cannot change to cascade update because it states there is a error, about having records. I cannot and do not wish to use autonumbers, my stock numbers are set at 5 numbers, the first 2 will identify what the product category...

I cannot change the intergrity in the "join" because I get an error, something like "referential integrity enforced and it wont let you change a number because there are related records in another table" It would appear there is a record for every stock number in every order giving some...

I did thank you for your post and also replied to it, saying "it all went above my head" meaning I didnt understand it, sorry

I dont need to know the old stock number if the Order Detail table is changed but I did add a field for the old stock number in the Stock table

Yes, it wont let me change the integrity becasue of that very reason

To show you my level of experience most of this went above my head and I googled some of your abbreviations :)

To be honest I didnt expect replies so quickly :) and didnt check

I have no idea what a surrogate key is but when I have a little time I will investigate, thank you

Ok Guys first of all thank you to everyone who has replied, secondly ……. Let me start again I have one database that I have made from scratch, with little experience of Access, I programmed Lotus Approach in the Nineties and tbh I preferred it but alas is no more. In this database I have many...

Hi, I have a stock database and a order database and they are related by the stock number. I now want to change my stock numbers. If I change the stock number it doesnt change the order form. It wont let me change the integrity of the database :( any ideas would be most welcome thank you Nick

Hi, just to continue my saga, please can anyone help me? Access 2013 - Multi User - On a Network (NAS) - All computers have it mapped to drive R:\ How can I display a image in a record and have a button that when clicked opens the file in windows viewer? What field type does it have to be...

Hi I found the trust center and added all the locations on the network, and checked all the right boxes and saved, closed and re-opened the database, but I am still getting the same trust message. any ideas? kind regards Nick

thanks for the qucik reply Minty, If I copy and paste the file name in explorer it shows me the picture. Not sure how to add a trusted site but I will sort that one out. thankseversomuch for your help Kind regards Nick

I have two types of addresses in the field "File" (WILL RENAME LATER), some records show it as R:\blah blah blah and in others it shows as ..\blah blah when I click the button now it first comes up with a message that shows "A potential security concern has been identified This location may...

Hi thanks for replying I have now tried it with and without the sqaure brackets and it still doesnt work Kind regards Nick

Hi, thank you for replying, the button is called - Open File. The field name is File because that is the information stored there, am I missing something here? Kind regards Nick

I have this as code Sub cmdOpenFileButton_OnCLick() Application.FollowHyperlink Me.[File] End Sub Private Sub Open_File_Click() End Sub where [File] is the field that is storing the file name, including the path when I press the button nothing happens thanks Nick

I think I dont explain things very well, so I wil start again Access 2010, I have a database for a catalogue of 2000 pictures, mainly jpgs but some others aswell. On a form I want to be able to see the picture and then if I need to say edit it or look at it more closely or print then I would...

Hi Minty I think I follow what you are saying, but the full path to the file is stored in the attachment field can I someone associate that when it is looking for a file to open, I have 2000 pictures in the db and wish to make it loads more, i dont fancy typing in the full path each time which...

Hi thanks for the replies on my last query, (even though I didnt manage to solve my problem :( ). Today I was hoping someone could help me to create a button to open a file. I am using Access 2010 and a database for my catalogue, I have a field for an attachment which shows the image fine. I...