Search results

Hi, If you have a front-end / back-end set-up, is there an easy way to share queries between front-ends (other than copying the SQL into a word document and copying into the other Front-end. Background info - the database in question has several people with front-ends but in reality certain...

I have a database that has one table that contains notes and may reference a document. As it is helpful to be able to bring up an electronic version (.pdf, .tiff, .doc, etc.) of the source document, I then 'attach' (or rather link) to the file using a hyperlink field. My questions are: Is...

Hi, I have a table that links to files using hyperlinks but somewhere along the line (possibly after a 'Compact and Repair') some of the links have changed and no longer work. For example: Was - M:\Example Database\Database Attachments\A Test File.pdf Now - ..\Database Attachments\A Test...

I have a database that has data input on one main form that contains various sub-forms for different data types in various tables, all connected via an ID code. On one of the sub-forms, I wanted it to automatically collect a record updated date. I have added the relevant field to the table...

Hi, I wasn't sure whether to put this in the query section or Macro section of the forums, so forgive if not in the right one. I have a macro that runs a delete query, and that works ok, but could be improved if it could automatically answer yes to any confirmation boxes that appear (the...

Hi, I have a database in Access 2003 containing various tables of information all linked together via a common ID code using the relationship manager. Data is viewed by the database users using one main form, which has tabs for various infomation types (e.g. current and past addresses, career...