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...

@DCrake Thanks a million! The code with your comments is great. Suddenly I understand a lot more. On other question... Is there a simple way to get a file browsing dialog where the user can select a path/folder, and then put this in a variable?

I think I found a process to handle it, but I would appreciate some coding assistance. This is what I have in mind: 1) As I put <FE path>/data as default path for the BE in the Installation Wizard, I will start by checking wheter the BE part is there or not. This I guess I could do with...

Thanks, will do. Do you have any info at all in response to my questions above to get me started?

I guess I could, but I would still like to be able to handle it using code for future apps. I am especially interested in if I could set a relative path since that would make life easier. Is there a way to extract the path for the FE part? If so, I could make the install package put the BE...

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...

The discussion is interesting for a newbie like me. Where can the alternatives be found?

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 does this mean that I should just choose "Module" in the "Create" menu and have my general functions in that module?

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?

My bad. There are dates in tblOrders. Sorry. Yes, you are correct. Thanks a million for the solution!

I follow up with another one then... Once we have determined wheter the product exist in the booking list, we need to decide wheter we can book it on the date we need it. I have used DLookup to get the date into a variable: wantedOutDate = DLookup("[OutDate]", "tblTest", "[OrderNo] = '" &...

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...

Thanks again. And a follow-up: I realize it would be a good idea to assign the field values to variables and then use the variables as criteria in DCount. Do I need to handle the variables differently as well in the DCount function depending on datatype?

Thanks, it helped, but one issue remains: How do I get the value of a textbox in the form as criteria for dCount? Currently the code looks like this: countRec = DCount("[OrderNo]", "tblTest", "[OrderNo] = frmMgr![OrderNo]") What I want to do is to use the value in OrderNo in the form frmMgr...

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...

And another question on the design of the usage of junction table: Since this is a system for renting out products, the dates are crucial as I do not want the products to be double booked on the same date. The dates are set in the tblOrders, but should I also link the dateOut and dateIn to the...

Thanks! How is the tblOrderProducts populated? Do I build my forms from all the tables involved?

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...