Search results

  1. W

    Integrity

    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...
  2. W

    Integrity

    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...
  3. W

    Integrity

    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
  4. W

    Integrity

    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
  5. W

    Integrity

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

    Integrity

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

    Integrity

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

    Integrity

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

    Integrity

    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...
  10. W

    Integrity

    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
  11. W

    Question File /Picture

    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...
  12. W

    Question Button

    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
  13. W

    Question Button

    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
  14. W

    Question Button

    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...
  15. W

    Question Button

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

    Question Button

    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
  17. W

    Question Button

    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
  18. W

    Question Button

    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...
  19. W

    Question Button

    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...
  20. W

    Question Button

    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...
Back
Top Bottom