Search results

I need some help with handling options in a form for searching and I can't figure out how to do it. Depending on which option the user selects I want to enable (or disable) different textboxes in the form where the user can put criteria for searching the database. How to accomplish this? By...

Finally my first little project is ready to go live, but I am stuck in the handling of linked tables as I have split the database. My problem is that the links to the table in the FE part points to the location where I did the development. And this means that the links doesn't work when I...

I am finally seeing the end of my first "real" Access project and it's time to distribute it. I have split the database, and I will use the Access Developer kit to create an install package. I guess both the back end and the front end files must be selected? How do I handle future changes? I...

As I am trying to learn more VBA I been reading a couple of web page to get the idea of how to trap and handle errors. However, I have a couple of things that I don't get and I guess there are a lot of experience in the forum that might help me... Reading tips would also be appreciated. My...

So far I have coded VBA for specific events only in Access and now I wonder how I can write a function that can be called from anywhere in my application. Where do I put the code?

I have three tables in my database that I use for renting out products. The products in "tblProducts", the orders in "tblOrders" and a junction table "tblBookinglist" that saves ProductNo (from tblProducts), OrderNo (from tblOrders), and OutDate and Indate. To be able to produce a list of...

I have a piece of code that takes the values from a couple of fields in an unbound form and insert them in a table using SQL. It works fine. However, I need to do a some controls before I insert the values, and I can't figure out how to do it. This is what I need: 1) A check if the value...

I am having problems with a system for lending products. I have created two tables, one for a new order containing customer name, order no. and booking date. In the other tables I have the products. Now, my problem is this: Each order can contain several products, but each product can also...