Databases

Recent Answers

2013-06-18 Using MS Access - Access 2010:

First, I'm going to say I'm not a big fan of the Split Form. I have used it on some rare occasions where it fit, but I've found its not much of an advantage.    Looking at your screen shots, I don't quite

2013-06-17 Using MS Access - Lending Library - Multiple Checkouts:

You can use an Update query to update all records for that library. You can add a button on your form to generate and run the Update query. it would look like this:    Dim strSQL As String    strSQL =

2013-06-17 Using MS Access - Lending Library - Multiple Checkouts:

Depends on how you identify IDs. I would assume your IDs table also lists the location where they can be used. If so, then you could check out all IDs for a specific location. Without knowing more about

2013-06-17 Using MS Access - how to select records where a field have a certain number of duplicate records:

First, I do not recommend using such a key. In fact it violates normalization rules.     Access includes an Autonumber datatype which is perfect for a unique identifier and performs better than a text

2013-06-11 Using MS Access - Access Forms Default values:

First, I did answer question 2. I said, you can use the Switchboard Manager to run a macro. You can make a simple OpenForm macro that will have the View property set to Datasheet. To explain further, the