Access product catalogue website style

[Faoineag]

I wrote dot between limewire and com, but unfortunately the spam message appears again

 

[Edgar_]

I get an object does not support this property or method
productPage.Style.flexWrap = "wrap"

But it appears correct as far as I can tell.
If I comment the line out it works rendering in single column.

Thanks. Please read posts #12, #19 or #20 for context, where I'm writing that you need to enable IE11 emulation.

The library allows it but the browser being used by your legacy browser control does not support that feature. You need to make the browser control emulate IE11 by modifying the registry key to something like 11001, as shown.

I'll see if I can adapt it to not use flexWrap so others don't have to change the registry key, but making that change will make your browser control more capable and compatible.

 

[Edgar_]

I wrote dot between limewire and com, but unfortunately the spam message appears again

Attach a txt file with the link or post a screenshot.

 

[Faoineag]

Attach a txt file with the link or post a screenshot.

Thank you

 

[Edgar_]

Thank youView attachment 117972

This is your link.

Download Prova Catalogo.rar | LimeWire

Download Prova Catalogo.rar on LimeWire

limewire.com

 

[CJ_London]

Are you sure you are using ie11 - needs to be set before you open the form

 

[Edgar_]

I modified the file.

This version does not require registry key changes.

It is using the default browser, which is IE6, I think. That means the only thing we can hover over with CSS are links (but can be done with JS), we also can't scale or animate things (but can be done with JS). We don't have flex-wrap, but we have a simple workaround with blocks and floats.

Sacrifices were made to make it look almost the same, so now it looks like this:

It does the job.

 

[arnelgp]

Sacrifices were made to make it look almost the same, so now it looks like this:

very pleasant to the eyes and very professionally made!
there is similar sample here: https://www.access-programmers.co.u...-control-not-show-images-horizontally.320250/
but lacks events for those image and text.

 

[CarlettoFed]

This could be another kind of solution.
However the database structure has many things that need to be improved:

• Normalizationcorrect
• management of field Properties (Required and Indexed in particular)
• Indexes to prevent creating duplicates
• etc...

 

[arnelgp]

This could be another kind of solution.

i don't see any "web style" on your form.

 

[CarlettoFed]

In fact, if you read, I said it's another kind of solution.

 

[arnelgp]

this is from post #1:

To get a better overview I'd like to create a catalogue view like a website, with the various thumbnail photos and the code underneath which when clicked opens the corresponding product sheet.

 

[Mark_]

Hello everyone, I would need the advice of some of you experts: I run my sporting goods sales business with an Access database, I have thousands of articles, each with its own product sheet, catalogued in categories, subcategories etc. To get a better overview I'd like to create a catalogue view like a website, with the various thumbnail photos and the code underneath which when clicked opens the corresponding product sheet. Do you think this is feasible in Access, and if so could you give me some advice on how to do it? I have no idea how to do it. I thank those who can help me in advance

Are you looking to also have this available as a website?
In the 90's, I made an online catalog where all of the pages were created based on info in a database. Different approach that how they are currently made as I was having a small program make the pages as a static site rather than dynamic.

 

[Edgar_]

very pleasant to the eyes and very professionally made!
there is similar sample here: https://www.access-programmers.co.u...-control-not-show-images-horizontally.320250/
but lacks events for those image and text.

Thank you for the compliment.

I see that you're using the ActiveX browser control in your solution, I believe the same approach can be followed to add events to your sample, just give your tags some id attribute that is unique. For example, images could have the format "image_" & rs!id, ratings "rating_" & rs!id, etc., and then choose what to do when they're the active item on click.

For more control, you could create a class that responds to the events of any element and store all instances of that class in a collection to make them persist. That way you don't have to deal with the filtering of the active element.

Thank youView attachment 117972

It might be my italian but I think your structure needs to be revised. If you can upload a sample database in english for all of us to check, it'd be better.

 

[Faoineag]

@CarlettoFed
Thank you very much, yes it is a possible solution, which perhaps no longer even requires the ‘SchedaProdotto’ form to be opened because the text is visible together with the image. With regard to the structure of the database, I would ask you to tell me in more detail in which elements of the db you find the errors indicated in the first two points of your list (normalisation and management of field properties); with regard to duplicates, however, since many articles belong to many categories, I could not find a better method than using the sub-mask within the ‘SchedaProdotto’ form

 

[Faoineag]

@Edgar_ I have tried to translate as much as I can, I hope it is enough because I would not know how else to do it. Thank you

 

[Faoineag]

Ho modificato il file.

Questa versione non richiede modifiche alla chiave del Registro di sistema.

Sta utilizzando il browser predefinito, che è IE6, credo. Ciò significa che l'unica cosa su cui possiamo passare il mouse con i CSS sono i collegamenti (ma può essere fatto con JS), inoltre non possiamo scalare o animare le cose (ma può essere fatto con JS). Non abbiamo flex-wrap, ma abbiamo una soluzione semplice con blocchi e galleggianti.

Sono stati fatti dei sacrifici per farlo sembrare quasi lo stesso, quindi ora appare così:
View attachment 117978

Fa il suo lavoro.

Questa sarebbe la soluzione perfetta, se solo fossi in grado di aggiungere più filtri, come le caselle combinate nel db che ti ho appena inviato

 

[Edgar_]

I think the link doesn't work.

 

[Faoineag]

I think the link doesn't work.

I try again

 

[Edgar_]

Something's wrong.

I can see the name of the file, but it does not let me download it and that error message shows up. I suggest you use another service, like Google Drive or even Dropbox.