Recent content by twilbour

I have created an application (my very first). It has a split front end and back end. I plan to distribute the runtime version. I have used code throughout that "hides" the microsoft access shell for popup (modal) windows. In every form & report I have a function to show or hide the access...

I'm pretty much a novice. I've built a couple of databases that I use for reporting, and they gather data from some of our internal systems via passthru queries. I also import some excel data. (All of which I've figured out on my own with the help of this forum!) I've set up a few macros to...

Thanks for the reply. I admit I'm very new at this, and I'm sure my design is not even close to efficient, but it seems to be working for my purposes for now. I'm totally open to other ideas. Actually - you've got the concept. I have closed orders in a seperate table because my database...

I've been trying to solve this for a while, and I know the answer is easy - but I just can't seem to get it to go. I'm creating a macro that runs when data is input in a form box. The first step is to check the data (its an order number) to see if it has been used before. It has to look in a...