Recent content by UncleBulgaria

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

Thanks for that, works perfectly now. I hadn't thought about the looping! Robert.

Thanks for the info, works perfectly! Robert

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

I hadn't even thought of that as I had assumed it must be something in either the main form or sub-form's properties. Sometimes you miss the simplest of things. Thanks for your help! Robert.

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