Search results

  1. A

    Insert Excel object in the form

    Yes that is quite helpful already; but as I am using Access 2007 and that I can put attachments inside the database, is there a way to avoid the external attachement? Ideally, as I have already 450 records in my database, I would like to avoid ending up with 450 excel files in my folder... and I...
  2. A

    Insert Excel object in the form

    Hi, I am the user! I need this spreadsheet to attach comments specific to the record, in the form of figures (ie, financial information, ratios, other specific to the record). I do not need a framework, ie the data input in the cell will change from record to record, following different models...
  3. A

    Insert Excel object in the form

    Hi, My forms are composed in tabs; I would like to insert a third one on which I want to input and Excel object. I already managed to insert an Excel object but I do not know the difference between linked / unbound object and, once inserted, either I can't edit it (under form view) or if I can...
  4. A

    Relationships between tables

    Noted, thank you. So that means my default value needs to be in my row source too I guess? I was thinking of calling something like "Please select..." but to put this in my industry table looks weird..? Thanks for your help.
  5. A

    Relationships between tables

    I used your first method (the second one seemed a bit complicate?) and it works! Thanks a lot - I also like your grouping stuff on your first field which allows you to gather all the data in only one table, so I don't know now whether I really need two tables... I will figure it out early...
  6. A

    Relationships between tables

    Hi, I started using access on my own last November and I have received already some very useful tips through this forum, so I hope to repeat this experience with something which seems to me now a lot more sophisticated than last time. I have now 3 tables, one containing my main records which I...
  7. A

    How to create an automated field

    Waouh it works. thanks so much !!!!!!!! Thanks to all other answers.
  8. A

    How to create an automated field

    Hi, I am new on Access, never been taught anything about it so please pardon my vocabulary. I am creating a certain number of fields on a form, like 6, and each of them is configured to receive an integer between 1 and 5. Now I want to create a 7th which should be an average of the 6 previous...
Back
Top Bottom