Recent content by Colt45

Thanks guys, and sorry for the late reply. This helped me out.

Hi all, I hope someone can help. I use an ADO function to sort and rank a table which worked fine in my old Access 2003 setup. I now have a new machine and I've upgraded to Access 2007 and I'm finding the function doesn't work. My suspicion is that I'm missing an ADO reference, but don't know...

I've just changed from Access 2003 to 2007. In 2003, I had a quick and dirty way to allow users to update data in a table using the inbuilt switchboard manager. The user goes to a sub-switchboard from the main switchboard then clicks a button which uses a macro to run the open table command...

Hi Bob, I had the same problem as the poster and tried a few different forums Google suggested, none of which helped me. However, as always, your post got me fixed in seconds. Don't know why I didn't just come directly to this forum! Something odd with the other forums that Google suggested was...

Until yesterday I had never had this issue. I've been experimenting with Visual Studio and it suddenly decided to make my XP SP3 machine decide that no MS Office applications were installed. This resulted in the need for a clean install of Office which has now been done. Normality is...

wow! 4 years later and it still works....

wow! 6 years later and it still works. Thanks for posting this - saved me a lot of heartache! Cheers

Thank you sir! I looked it up, tried it and hit runtime error 3027, but someone else had already answered that on this site (Google brought me right back here!). Thanks, this is really cool! Cheers, Colt45

Hi all, this is my first question on these forums, so please forgive any unintentional bloopers or faux pas! I have a database which is really simple - it's actually only a linked table. I use it to change the format of a text field which contains a date. All I do in the database is select the...

Thanks for the encouragement Galaxiom - although I think the limitless possibilities are part of the issue for a newb like me! It's hard to even frame a question in Help to get a meaningful answer to a specific question unless you already understand the full context of how VBA can be used -...

...glad to be on these forums. I've hacked around in Access for years without needing VBA, but it seems there's no escaping it. Having ghosted around and mostly found answers to my questions without needing to post, I've seen this is a good place to come to, so I'm hopeful I'll get over my...

Hi Ashley, unfortunately I am not yet in any way proficient in VBA - but if I could write, the algorithm would work like this: 1. Start with list of top-level finished goods (in my environment they are independently identifiable, so no need to query the BOM to identify them). 2. Use the BOM...

Hi, I'm new to these forums, and to VBA, but I also work in an MRP-related field and have dealt with some of the issues you mention. I don't yet know enough VBA to try and programme the algorithm, but the approach I have taken for multi-level BOM explosion is to start from the absolute top or...