Recent content by ScrmingWhisprs

So unfortunately that did not work. When I ran the query in my test query builder I received an Enter Parameter Prompt with "Tmp.tblListDetails.list_id" above the input box. I can try using 2 queries. I was trying to accomplish this with 1 SQL statement within VBA code, only because my...

Thanks for the input! I will give that a try tonight.

Hi MarkK, Thank you for the response. That makes perfect sense and yes, record_id 44 and 6664 are very likely to exist in tblListDetails under a different list_id. I'm curious if you would have an idea on how I can limit the duplicates to a certain list ID exclusively? I'll explain what...

Hi, I have the following duplicate check query that is returning inaccurate results: SELECT * FROM tblListDetails WHERE (((tblListDetails.record_id) In (SELECT [record_id] FROM [tblListDetails] As Tmp GROUP BY [record_id] HAVING Count(*)>1 )) AND ((tblListDetails.list_id)=24)); Below are the...

So I used sneuberg's suggestion and changed the Tab's fixed width and height to 0.0007" and that fixed my issue, at least on Access 2013! I have to test on 2010 and 2016 tomorrow. You would think having it set to 0" would have taken care of it. Gotta love Microsoft! Thanks again! -Mike

pbaldy, I'm not exactly sure what you mean by that....

Hi pbaldy, I've tested on versions 2010, 2013 and 2016. The problem occurs on all 3 of those versions. I will try to get a sample together. -Mike

Even if they are "hidden"? It doesn't make sense.

Hi all, I've been trying to search for a solution to this problem, but can't even find any posts by others with this problem. On some forms I use a tab control with the Style as None so there are no visible tabs or buttons. This way I can re-purpose the form for several different functions...

Hi Mark, The datatype for the Tabindex field is Long, so I finally got around to adding your suggestion and it now works perfectly!! Thank you so much for all your help! -Mike

Now I get a Type Mismatch error. I'm thinking I need to declare the ROL_TABINDEX value as Long or an Integer? But I'm not sure how to go about that...

Hi Mark, So I have modified my form's Current event to the following: Dim rs As DAO.Recordset Dim strSQL As String Dim lngPar As Long lngPar = Me.PAR_ID 'This is the Parishioner ID number strSQL = "SELECT jtblRoles.ID, tblRoles.ROL_DESCRIPTION, tblRoles.ROL_TABINDEX " & _ "FROM...

I've attached a screenshot of my contact form. The items in the Roles listbox never get "selected" or highlighted on this form. They simply just list the roles assigned to the displayed contact. The list does NOT include all possible roles that are available. There is a hidden column in the...

Hi Mark, The idea behind the listbox is to just simply list the Roles. Users will not be making selections in the listbox. In fact the listbox is "Locked". To add or remove roles, users would double-click the box and be presented with another form to make changes. Once a contact's record is...

Hi Mark, I have a junction table (jtblRoles) to keep track of the many-to-many relationship between the contacts (tblParishioners) and the roles (tblRoles). The listbox on the contacts form shows the description and contains the hidden tabindex field, both fed from tblRoles. That's working...