stalker401
New member
- Local time
- Today, 18:33
- Joined
- Oct 4, 2018
- Messages
- 3
I created a form for GL Class codes. The relationships work as such:
the original data was put into a GLClassCodes table.
I than created a smfGLClassCodes form related to the table, and lastly created a GL Class Codes form with a sub form attached with the source record of smfGLClassCodes.On the GL Class Codes Form there's a keyword search box and button that is supposed to search each of the following columns:
ISO CGL
ISO Description
Notes
Contemplated Operatsions
The keyword search seems to work for all columns but ISO CGL (the main one I'll use). There's like a wierd portion in the middle that won't pull if I search for a specific code. So it'll so any of the first 500 results, and most of the last 300ish results, but right in the middle it won't search. I did this by creating an event on the "Search" button:
Dim SQL As String
SQL = " SELECT GLClassCodes.[ISO CGL], GLClassCodes.[ISO Description], GLClassCodes.Notes, GLClassCodes.[Contemplated Operations], GLClassCodes.Basis, GLClassCodes.[ISO Attachments] " _
& " FROM GLClassCodes " _
& " WHERE [ISO Description] LIKE '*" & Me.txtKeywords & "*' " _
& " OR Notes LIKE '*" & Me.txtKeywords & "*' " _
& " OR [Contemplated Operations] LIKE '*" & Me.txtKeywords & "*' " _
& " ORDER BY GLClassCodes.[ISO CGL] "
Me.subGLClassCodes.Form.RecordSource = SQL
Me.subGLClassCodes.Form.Requery
This same thing seems to work on every other form, and it just randomnly (to my knowledge) stopped working on this one. I looked and I don't see any filters or anything on that column in the table, smfGLCLassCodes Form, or GL Class Codes Form. Any thoughts on why this is happening? Or am I just better off deleting the 2 forms and remaking them?
the original data was put into a GLClassCodes table.
I than created a smfGLClassCodes form related to the table, and lastly created a GL Class Codes form with a sub form attached with the source record of smfGLClassCodes.On the GL Class Codes Form there's a keyword search box and button that is supposed to search each of the following columns:
ISO CGL
ISO Description
Notes
Contemplated Operatsions
The keyword search seems to work for all columns but ISO CGL (the main one I'll use). There's like a wierd portion in the middle that won't pull if I search for a specific code. So it'll so any of the first 500 results, and most of the last 300ish results, but right in the middle it won't search. I did this by creating an event on the "Search" button:
Dim SQL As String
SQL = " SELECT GLClassCodes.[ISO CGL], GLClassCodes.[ISO Description], GLClassCodes.Notes, GLClassCodes.[Contemplated Operations], GLClassCodes.Basis, GLClassCodes.[ISO Attachments] " _
& " FROM GLClassCodes " _
& " WHERE [ISO Description] LIKE '*" & Me.txtKeywords & "*' " _
& " OR Notes LIKE '*" & Me.txtKeywords & "*' " _
& " OR [Contemplated Operations] LIKE '*" & Me.txtKeywords & "*' " _
& " ORDER BY GLClassCodes.[ISO CGL] "
Me.subGLClassCodes.Form.RecordSource = SQL
Me.subGLClassCodes.Form.Requery
This same thing seems to work on every other form, and it just randomnly (to my knowledge) stopped working on this one. I looked and I don't see any filters or anything on that column in the table, smfGLCLassCodes Form, or GL Class Codes Form. Any thoughts on why this is happening? Or am I just better off deleting the 2 forms and remaking them?
