Search results

  1. K

    Creating a new record from copied form and subform in one step

    We keep a different version of the record to correlate with each different version of the 'book'. The subform/category table lists a combination of different categories to define the 'book' that might be used to search for it - such as hardback, crime, fiction... Each 'book' can have an...
  2. K

    Creating a new record from copied form and subform in one step

    I want to copy it and paste it into a new record in instances where they are two separate 'books' but share the same main information including the categories they have assigned. We already do this, but have to copy the main form/table and sub form/related table entries separately... I just...
  3. K

    Creating a new record from copied form and subform in one step

    Hi Swemebegur Because they may be different formats (hardback, paperback, audio, etc)
  4. K

    Using fields to update others

    X posted. Thanks Plog. I'm being asked to make all sorts of 'improvements' by people who want to save precious seconds, some of who aren't very technical but have looked on the internet and told me it can be done.... doesn't mean it should be...
  5. K

    Using fields to update others

    I work for a team that keep a record of evidence documents. These are stored on a central filing system on a shared server in a folder named as the case number. We have a database is to record the evidence documents, where they are stored, version history, file type, size, owner and a...
  6. K

    Using fields to update others

    Field A is a file location which I want to be able to link to from the database so the file opens - for example C:\Users\KLouise\Documents\document1.doc This came up after the database had already been in use for a while so I created a hyperlink field (field B) so that users could just click...
  7. K

    Using fields to update others

    Field B would be a hyperlink of the first field... I may be overcomplicating it Field C would use the last part of field A to determine the file type
  8. K

    Using fields to update others

    I want to update fields B and C in a table based upon another field (A) in the same table but I want: Field B to update when the original field A is changed in the table (I have managed to get this working in the form but I am trying to get the fields in the table to do the same as sometimes we...
  9. K

    Creating a new record from copied form and subform in one step

    I am trying to copy and paste a record into a new record in form view including the subform at the same time. (I'm going to use an example of a database of books as an example so I don't disclose anything I shouldn't) The main form has all the details about a book for example, such as title...
  10. K

    Hi :)

    Hi :) I'm a newbie. I have worked with Access on and off for a few years and have mostly taught myself what I need to know with the help of a couple of short courses including VBA, but I am completely new to Access 2007. I built a simple database for my company a few years ago and now I'm...
Back
Top Bottom