Search results

Thanks very much Pat, trouble was that the 2010, although able to open the 2002 version, but did not display some forms with subforms correctly and my custom menu bars and switchboards were all messed up, I guess I'll just have to resort to VM then. Thanks again. Bobak.

Hello, A few years ago I converted a POS DB to Access 2002 from Access 97, Now I've purchased Access 2010 and trying to learn it but it's conflicting with Access 2002 in that every time you open any of them they have to go thru a installation process, and I can't have this as it needs to be...

That's super, you have an amazing site, Going to spend some quality reading time there ;)

Gina, God Bless, I really don't know how to thank you, I'm not all that good, and the Master table designs you've made for me has confused AND enlightened me quiet a bit on table design, if you don't mind giving me 2 or 3 days to wrap my head around the structure and understand them and come up...

Thanks so much Gina, fingers crossed, have a good sleep ;)

Only Shoes, there'll be hundreds and hundreds of different models, colors and sizes, but all the same tree structure as above, I jotted down many different table designs but none of them made sense :(

I had a look at NetSupport program... http://www.netsupportmanager.com/overview.asp But since I'm going to be paying monthly for my website, I might as well do as you suggested and put my BE DB on my site and have all my FE's linking their tables to that, am I thinking right? Thanks again.

Thank you so much gentleman for your kind infos, I had a look at all the links again and I'm still scratching my head, This one had a little bit of similarities but I still could not design my table structure for my shoe store...

Hello and thanks in advance for your time, I've been looking EVERYWHERE for a simple free DB sample so that I can study how people design a DB for a RETAIL store which needs a MATRIX tables such as shoe stores where you have this kind of product tree: The Shoe Name > which will have different...

Yes, I've already bought a hosting site for my future website and left it as is so I can learn all this stuff and then make my website, it's here... http://www.amirashoes.com/ That sounds like a great idea, I'll have my main Back end DB hosted on my site and then all the front ends can link...

Thanks again Pat, sorry for the long delay, in order not to waste your time any further, I'll just summarize and finalize. 1- That is exactly my plan for the future, an up to date stock table to support the website. 2- Thanks for stopping me from purchasing that book, I was REALLY not up to...

Thank you so much Pat for your answer, English is not my first language, so forgive me for any blunders beforehand. So the Gist of what I'm understanding from you is: 1- That separate DB's with all separate tables is a bad idea and a Centralized back end with all the stores connected to it is...

Hello and thanks in advance to all you wonderful people providing your time to help others. I developed an Access DB around 10 years ago for my 3 shoe stores and it's been working great so far, however none of them are connected to each other, they are all separate machines running separate...

Yes, that was a much more elegant way of doing it, at first I did not quiet understand what you were doing, but upon reading up on some of the function you used, I incorporated those methods instead, now it's much more cleaner. Well that's it for me, I'm putting away my vba punching bags for now...

Well I worked on it all day, read hundreds of posts, tried so many different way's and got soooo confused that had a complete brain freeze. I got it working perfectly now just the way I want it but in the most inelegant way possible. I will describe it here, not for experts obviously, but for...

Oh by the way I've attached the DB with the report and subrepots in case I did not make myself clear again.

Yes I know what you mean, it's better this way. :o OK, the code works perfectly, now the final problem I have is that this report has two subreports based on the same query which just separates the CASH sales from The RETURNED and Credit Card sales. When I opened the main form, it was fine...

Thanks again vbaInet.

THAT'S IT !!!! we are done :D :D :D I was so anxious to see weather you replied or not, I checked the post on the bus this morning and when I saw your kind reply and saw the code, I just knew it would work this time. I was very very eager. I did mention in my post number 11 that I am using...

I spent the last 10 hours straight trying to make this work, believe me I've tried to understand the CASE function but I'm still confused, there was no way I was going to post a question again as I know I've reached the end of my shelf life, but then again I thought, vbaInet spent his time...