Search results

  1. C

    Need some help if possible

    Hello there I have a table that contains a UPC and I have a folder on our network with the images saved by UPC. What I would like to happen is the table is updated whenever a new image is saved so someone doesn't have to go and manually add it. I would like it to add the UPC and the image to...
  2. C

    Need some help if possible

    Hello there I'm trying to figure out if there is a way to possibly create a macro or code so that when a form is loaded it can be automatically updated. For instance I have an image database saved on our network with images. I would like to have the item and image automatically saved to the...
  3. C

    Macro or VB Code to link to image

    Hello Max I am trying to access the link and I am at work. It is blocking it so I cannot get into the site.
  4. C

    Macro or VB Code to link to image

    Check our AccessImagine component - automatically does all the work for organizing network image storage. No need to write the line of code here. I am having trouble accessing this. Could you possibly provide more information on this? Thank you for your help!! Carrie
  5. C

    Macro or VB Code to link to image

    Hello there I'm having troubles trying to find exactly what it is that I need. I'm trying to create a product database that will link to images that we have saved on our network. I don't want to embed the images because it might slow it down. What I would like to do is possibly create a...
  6. C

    Question Need some help to fix my database design

    Its beautiful and works great!!! Thank you VERY much again!! You have helped me very much! Quick question; the way this is setup I'm thinking I don't need the append query. Am I wrong in thinking that? Sorry I'm not too good when it comes to the codes. Thank you! Carrie
  7. C

    Question Need some help to fix my database design

    I REALLY appreciate you getting back to me. Sorry to keep bothering you with this. I think what you have done in just a few minutes will help me tremendously!! I am going to give this a try in my database. Thanks again for all of your help! I will let you know if this works out for me. Thank...
  8. C

    Question A little help on a report

    Hello I'm trying to see if there is a way to create a report so that its formatted a little differently then the attached report. I want to show the following: Product WIT Code and then states across top and show the Tax Status below the correct state. Example: Product...
  9. C

    Question Need some help to fix my database design

    Hello there Attached is a very stripped down example of my database. I appreciate your help with all of this! I think once I get this piece figured out I am on a roll. Thanks again! Ok well I thought I was going to be able to send you a copy of database, but I am getting the below error when...
  10. C

    Question Need some help to fix my database design

    So there is no way once a product is added to update all of the states for that product? I am going to have to enter all of the states manually for new products? I'm hoping that there might be something that would work so when new products are added they include all states. I think that if the...
  11. C

    Question Need some help to fix my database design

    Stopher Your suggestion worked great!! Only problem is that I don't see if I add or delete a product it doesn't show up in my junction table. It won't allow me to delete a product and it doesn't show one that I added. Any ideas? Thanks again!! Carrie
  12. C

    Question Need some help to fix my database design

    I didn't get anything at all. No error message at all. I don't know what I am doing wrong. I haven't tried the other way. I guess I will give it a shot. Sorry guys I'm kind of teaching myself as I go. I appreciate your help! Thank you!
  13. C

    Question Need some help to fix my database design

    Thank you very much!! I tried putting that code in and it doesn't work. I tried to name my tables the same as you mention. I'm not sure why the code doesn't work. Below are some of the screenshots of each of my tables. Sorry I'm not so great at the Code stuff. Thanks again!!
  14. C

    Question Need some help to fix my database design

    Hello and Thank you very much for getting back to me so quickly!! That helps a lot and I think I got my three tables setup. Question though; do you know of any way to automatically add all states for each product automatically? I'm not sure if there is any easy way to do that. Each product is...
  15. C

    Question Need some help to fix my database design

    Hello there I'm going a little crazy trying to create this access database. What I am trying to do is to show taxability of all products for each state. Right now all of the information was in one table, but its very ugly (items and states duplicated numerous times) and hard to manage. I'm...
Back
Top Bottom