Recent content by carriepedersen

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

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

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.

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

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

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

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

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

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

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

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

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!

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

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

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