Search results

Hello, I am looking for a query to select the second highest value (in this case a date) from a table. For example, if I had the following dates: 9/1/06 9/2/06 9/3/06 9/4/06 I would want the results of my query to be 9/3/06. My table is called tblEquityFunds and the field I'm looking to...

There is a button called Control Wizards on the Toolbox. Make sure it is enabled (appeares depressed).

check out this link: http://www.mvps.org/access/forms/frm0031.htm

Well, the problem with your code is that when you run it, you only have access to the currently selected record. In order to get to all the records, you need to do either an update query, or open the form's recordset.

Yes, like I posted earlier, the easiest way is to use an update query. Just run the query when the user clicks on the "check all" button. Whitesmoke's method above will only modify the current record.

You could do it with an update query. You can use the same criteria that you use for the form's recordset, and have it update the checkbox to either yes or no.

If the name exists in the recordset for combo box, it will do this automatically. If not, I'm not sure how'd you go about it...

Can't you just set the Validation Rule in the control's properties?

There are many ways to do this, but the easiest is probably to normalize your table. You could create a separate table called tblUpdates (or whatever you want). The fields would then be UpdateID, the Primary Key of your other table, UpdateDate, and UpdateText. Then, set up a subform for this...

That should work. Did you get an error message? What happened when you tried it? Are you using an unbound text box? Are the first and last name fields in the data source for your second form?

There are many examples of this both on this site and on others. You can start with this link: http://www.fontstuff.com/access/acctut09.htm If you still need more, I would suggest doing a search on this forum.

Looks like you found a great solution! Glad to have helped.

It looks like the problem is that if the user has a middle name, and the user name with the middle name exists, you'll be stuck in infinite loop. What you need to do is only try the middle name once. The logic should go something like this: Try First Initial + Last. If exists, If Middle name...

Glad to help! What I'm saying is that if you come across a scenario where you have two user names that cannot be made unique with this method, your loop will run forever. For example, if you have a user names in the database of JDoe, JaDoe, and JanDoe (maybe because you have two Janes and a...

Are you getting any error messages when you run this? Another way to do it might be to use an update query as well.

You have an extra space in your code, meaning you are looking up one value ("JDoe") but writing another value (" JDoe"). Change this line: strSqlUpdate = "INSERT into temp_user (id_num, last_name, First_name, Middle_name, UserName) VALUES ( " & rsn!ID_num & ", '" & rsn!Last_Name & " ', '" &...

Try using: Set rstOutGoingMinutes = CurrentDb.Openrecordset(SQL, Mode)

Sounds like you would just need to update the rowsource for your combo box in the after update event of each checkbox. You will need a new SQL statement for each of the permutations you described.

Try doing a search for "Cascading Combo Boxes" or check out this link: http://www.fontstuff.com/access/acctut10.htm

Go into the data properties of your form and set it to Data Entry. Or, if you are opening the form from VBA, set the data mode to acFormAdd.