Search results

I have no idea....this is way above my scope and I'm trying to understand it. I know what I need it to do and how, but that's it until I see it in action. I will read up on Select Case.........Thanks for the thought....

ARNELGP Thank you for the actual example also. I was able to decipher the access part, but not the module as my understanding is very limited but it is easier to see and figure out. So, I appreciate the time you take and the example did work in Access as I added more records. The only issue...

Hi. I'm not sure if this is a thing in ACCESS "Facet Query" or it's called something else, but .the same function The concept is to create return data to field called [price_facet]. The data i'm working on will be used in Magento so essentially it needs to end up in a certain format (faceted...

Hi Ninja, thank you for this example. This is the end result I am looking to achieve. I have no idea how to figure out your script yet. What I think I forgot to add is: I'm looking to create a configurable/parent record from items. So your "category" field would be the parent which is...

Well I appreciate everyone's input and feedback. I guess being new creates a challenge. I have read the Allen Browne articles and I need to digest....lol....I came home today and looked at the file/db i'm trying to replicate by figuring things out. You mentioned Amazon and June7 mentioned a...

Hi Gasman, you are seeing what I'm seeing. Yes not consistent on how the person named the fields right! You are thinking along the same line I am. What are your thoughts....This isn't for Amazon, the only thing that gets put on to Amazon is pic URL once it is formated through Cloudinary, but...

Ok, so I appreciate the responses and suggestions. Maybe I am not being specific enough or maybe I just have a tremendous lack of knowledge. Maybe also just overthinking it? Let's say this is my table. Reading my previous posts to get a better understanding of what I'm trying to do might give...

Hi Pat, yeah, i'm just trying to figure out someones end result and trying to format/normalize/map data file in access to achieve the same result and to gain knowledge by going through these steps. So far so good, but now it goes a little deeper. So "category" field is where example I provided...

Thanks, So two are telling me not a good idea. Let me try to provide some more details if I can keep it short. The end result that I'm trying to duplicate is the following: Default Category/Area Rugs/Area Rugs Catalog, Default Category/Area Rugs/Rug Colors/Red Rugs, Default Category/Area...

Hi all, so I'm new to VBA and other scripting, but must say I have learned a lot from those who have helped me. I saved the more complicated tasks that I'm trying to accomplish for last. So I'll do my best to describe what I'm trying to accomplish I'm dealing with a product table/file...

Thanks.

Well I have stated i'm a little slow more than 4 times! Maybe just the wording. Let me figure out how to send you data as I have never been on here.....

Yes, this is what I believe I want to do, but need to see it work.....I'm more of a show me so I can learn. What do you want as I have other tables, qry appends, scripts in the db i'm working out of. Is just the table with a make shift form I wiped together sufficient? I will figure out how...

nice, I'll play with it once I finish reading responses. Been working in between all this...

I see.....I invite your opions, really. I know there are a bunch of different ways of doing the same thing, depending on knowledge level or understanding. I didn't know you could display in Access....I'd like to do whatever is faster.....

Yes I agree and said yes to external app to open images. No putting images in access very bad and will bog functions down. So I would ask if you can explain how we take all the files from picture folder and somehow convert them into a hyperlink where only hyperling/path of file would be in...

Thanks, So Cloudinary isn't in the picture at the moment....so let's table that one. I want anyone to be able to open a form using access for right now. Once form is open there will be fields that are empty and need to be populated with data. A picture will be needed to popluate that data...

What if I started with just the large folder of pictures files and imported them into a table and then created a hyperlink to open those pictures in whatever file the were in??? I could then link the picture table to the table I work out of and the add the hyperlink field that will call up the...

I appreciate everyone responding and I will def read everything and see what I can put together. Let me give you the actual scenario as June7 just realized i'm trying to use Access to open images. Here we go hopefully not to long. I receive a data file of numerous items, I import into an...

I read about that, but I believe the Gohyperlink is a better one ..............thanks for the response