Search results

  1. R

    Database efficiency with generating tables.

    Hi all, I have been working on product database since the start of the year. I had never used MS Access before, and I have leant a great deal. But this is where I begin to doubt my abilities, as I have taught myself mostly everything I know. I am just wondering will I the end user see...
  2. R

    Feeding multiple tables from a single form.

    Hi all, I currently have a form which creates a parts list for products and it works great. It is basically a inputs one to many into a table between products and raw materials. I now wish to include on the same form (for simplisity) the ability to add patterns for each product similarly to...
  3. R

    Linking URL's to image boxes on a form.

    Hi All, So after all my previous posts regarding images in databases (which were very helpful and I got working awesome), I have now realised through management that the database will be used internationally and therefore the way I have been referencing images to the database won't work, (I've...
  4. R

    Using right click delete to delete records from a form.

    Hi all, This is an unusual question. Currently on most of the forms in my database I allow the user to delete records by selecting records in a list box on the form and pressing a delete button, I have also allowed them to use the key "Delete" to achieve this. However, now my manager has...
  5. R

    Poor picture quality issue when printing..

    Hi All, I've had a look around, and have not found a lot on this issue. So i'm wondering if it may be a printer problem rather than an access problem. I am currently attaching images to tables by storing their file path locations in text boxes and then linking them to image boxes when...
  6. R

    Question Attaching images to a database.

    Hi All, I am just wondering what is the best way to attach images to a database? I more asking for people's opinions and experiences. I have looked around and have not being able to come to a definitive conclusion. I am weighing between emedding images, which I fear could become an issue...
  7. R

    Viewing picture attachments in a list box

    Hi All, This question seems like it should be a rather easy and obvious one, but I'm yet to find a solution. How do enable a list box to display picture attachments? I want the user to be able to view a list of products and in one field see a picture of that product. Thank you in advance...
  8. R

    Referential integrity with composite primary keys?

    Hi all, I'm creating a database and I'm having trouble with composite primary keys. I've read on a few forums that good databases should use composite primary keys over say an autonumber. And it does neaten up the database a bit, i.e. if a record is deleted there is no messy skipped numbers in...
  9. R

    Best way to contruct a many-many table/form

    Hi All, My question is more to get a second opinion (or two or three..). I'm constructing a complete database for my company. I have developed forms and tables for collecting products and constructing product codes. So basically i have a table of all the products and a table of all the...
Back
Top Bottom