Search results

Thanks for your reply Galaxiom. So where does that leave me? I appreciate your point, but I'm not quite sure how this helps me further, since the table is what it is...? I think changing it, would not make things easier for me, I've been using it for a while you see. Maybe if I could accept this...

I'm a hobbyist with only basic understanding of SQL and Ms Access, so please bear with me while I try to explain my question. I'm trying to do something that obviously is way :eek: out of my league... I did a lot of searching and trying, but I guess I just don't really know what I'm looking for...

Soooo... No responses, does this mean it's not possible?

Hello guru's, I was wondering if you could help this n00b. I have been Googling and reading this and other fora, but found no solution to my problem. I'm working on a wine database (for ages now...). I'm currently struggling getting the following to work. I have a form in which one can select...

YES! I got it working! I used the On Current Form Event to trigger the VBA code in which I call the function you wrote for me. So when a new record is loaded, it will calculate the number of stars for each record again. Thanks very much lagbolt. No way I could have done it without your help! :D...

Oh yes, absolutely true. The concept is beautiful. Perfectly demonstrates my lack of experience. In particular I was referring to the sorting mechanism in the query. Couldn't have done that myself. I do understand it when reading it. Sorry for not being too clear straight away. I'll keep you...

Wow, just like that huh? ;) Thanks a million lagbolt. I only had a brief look, but this should help me out I'm sure. Will look into it deeper when I have some time the coming week. It does go a little above my head, so if I have any questions Im sure to report back here. Appreciate the help big...

@jdraw, thank you for the link and the info on variables. I think I'll need to be a bit more specific. A good lesson. @lagbolt, I appreciate it! :) It is too big to upload (30Mb) (I already inputted some data inc. pictures for test purposes). I can't post links, but maybe this works, if you...

Hello again, I tried my best, can't get it to work. I'm just too much of a beginner I'm afraid. Would you please be so kind as to help me get my desired result? Thanks very much! What do I have... I made two tables: I put in the high and low value, cause I couldn't figure out how to query (not...

Wow! Well that should keep me busy for some time! It sounds doable, but I'm not sure whether I fully understand what you're saying just yet, but learning on the job I'm sure to let you know my progress (or questions...) Thank you lagbolt for sharing your ideas with me. It sure is starting to...

Hi all, I saw this brilliant description quite nicely fitting my level of professionalism wrt Access and I quote >> "I am a newbie—self taught years ago, then forgot everything and am now returning to fix some things up." ... sort of... :o I'm self taught in business modelling, SQL, vba etc. I...

Hello World! ;) Maarten here from Delft, The Netherlands. I have some basic experience in writing Query's and playing around with Access. Currently I'm building an Access database to keep track of one of my hobbies... Wine. I know my wishes wrt what I have in mind by far exceed anything I...