Recent content by downhilljon

Hey Brian, Thanks for the reply. What you suggested wasn't the solution (each customer can purchase more than 1 bike, so that's why I had purchaseID instead), however, your suggestion prompted me to try some more options. Whatever I did, it now works! Thanks a lot, Jon

Hi all, I've got a simple count query I can't make work properly. I'm trying to display the number of bikes purchased from each suburb from my extensive database of sold bikes. I've set up 2 queries (see image1.jpg). The first one works as I'd expect it to - gives me 1758 records (the...

OK David, that did the trick! Thanks again. Also, Thanks gemma-the-husky for the suggestion - I definitely appreciate the simpler approach, and if I had more time I would explore it, but right now I have my solution, so I'm happy! Cheers, Jon

That is fantastic David! Thanks for the quick and thorough reply. I'll give it a go this arvo, and let you know if there are any problems! Cheers, Jon

Hi, Have had a big break from coding, so feeling a little stupid. Hope someone can help! The following method seems to me to be the best solution (with my limited knowledge), but am willing to accept suggestions on better methods. In the big picture, I have a table (tblBrands) with the...

yep, that did the trick!!! Thanks heaps mailman. It's usually something simple!!! Jon

Hi all, Been searching for a solution to my problem on here for a while, with many tantalising tidbits, but nothing seems to be working so far. I have spent a bit of time recently modifying Allen Browne's Audit Trail code to suit my specific situation, and I am now stuck with exporting the...

ptm0412, Thank you so much, you have helped me find where I had gone wrong! The problem was that I had already set the Rowsource value of the listbox to one of the two queries, thinking that the code would simply change it when required. Clearing the rowsource property has solved a major...

Hi there, My apologies to those whoe have already read this post - I originally tacked it onto an existing thread, but just thought I would repost to try to get a solution. My situation is that form A and form B can be used to open form C. However, depending on which form is used to reach form...

Listbox rowsource I am having a similar problem, and this is the closest post I have found to answering my question, but it is not quite there! My situation is that form A and form B can be used to open form C, like MartijnAn. However, depending on which form is used to reach form C, I need to...

Fantastic Paul, thanks very much!

Yep, worked a treat. And much more efficient than my code too! Thanks again.

Hi there, I am having this annoying problem I can't solve, would appreciate some fresh eyes to look over the code for me. When I get to the bold line below, I get run-time error 3464: Data type mismatch in criteria expression. Confusing, as strSerial is a string, and the field "SerialNumber"...

Thanks heaps for the reply Tim. This looks like it will suit my situation exactly. I'll get cracking and let you know how it goes! Cheers, Jon

OK, new problem to solve. I don't know if I am going about this the right way, so please feel free to make suggestions on better ways to acheive an outcome! I have a query "qryBuildsPrinted" which searches a specific table for appropriate records, feeds these selected records into a report...