Recent content by BrotherBook

I have an access front end for a SQL database and I have created a Call Records Table and a Call Attendees table. On the Call Records table I have two unbound Listboxes, "AvailableAttendess" and "CurrentAttendees". Available Attendees is a not inlist query to the Call Attendees table so that...

I figured it out. Once the ListIndex has been set, i set the ListBox = 0

The multi select property is set to Simple and I still get this issue. Any other ideas?

I'm trying to create some VBA that will loop through my listbox, de-select all of the items, and then return to the top of the list without selecting the first item. Below is the code I am using based on what i was able to find through google, but the top item still remains selected...

Pat - You mentioned that there is a way to do this using a subform without any code. Do you have any example code or DB I could look at. I've been able to write the code for the multiple selection listbox to write down to a new table, but I've started to realize how difficult the code is to...

That worked. Thanks!

After the user has selected the "Attendees" there is a button to add the attendees. The first line in this code i added DoCmd.Save before it loops through the selections and writes them down, but i still get a blank. Below is the code in it's entirety. Private Sub AddAttendees_Click() 'Save...

Hi- I have a form called "Record Call" when a user can input the calls that they have made or are scheduled. This form is based on the table "CallRecords". I have created a new table called "CallAttendees" and added a listbox to my form for users to select who attended/participated in the...

Hi- I've created a front end application using Access with a SQL back end. I have a shortcut to my application on each user's desktop, which references the application stored in their My Documents folder. I am trying to find a way to limit the users to only having one instance of the...

You should just be able to put a "Not" in front of it. Try Me.CommandButtonName.Enabled = Not Me.YourCheckBox

The attached should address your request for a button to launch and closing the search window after launching the record. I'm not sure why you would be getting an error with the code. Let me know if you still have an issue. You'll need to create a button to return to the search screen.

It looks like you didn't have the code to re-query implemented correctly. This is the implementation I had in mind, but not sure if its what you had in mind. If you don't want to show all the data in the listbox, you could also use a DLookup function to check for the filters, and just have one...

MG101- It sounds like you'll want to create a new form with three text boxes for the user to enter filters and a ListBox based on a query which contains these three fields and any other information you want to show the user to find the right record. 1) Create the query containing the...

Thanks for the reply. Several of my filters had requeries in the OnExit properties which seemed to be causing the problem. I changed these to fire on AfterUpdate, and I also pass a new RowSource when they click my "Close" button which removes all the filters. This fixed the problem. Thanks...

Hi- I have a form which contains a listbox sourced from a query and several text boxes where the user can enter filters for the query. The query has references back to the form for the criteria, i.e. the filter for "Company Name" is handled in the query criteria as Like "*" &...