pswilliams0
Registered User.
- Local time
- Today, 02:05
- Joined
- Apr 19, 2012
- Messages
- 20
Hi All,
I'm a bit of a novice with Access, however this forum has typically had an answer when I'm completely befuddled...
So, here's a description of my DB:
I have a database that has a form used as a command bar. On that command bar is a text box. The value of that text box is used as a search field with a button. The searchable field has no duplicates, so the VBA code is written to match the number from the text box to a specific field on the form it opens. Like this:
Private Sub Command40_Click()
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = "[EN Number] ='" & Me.Text41.Value & "'"
stDocName = "EventList_Justified"
DoCmd.OpenForm stDocName, acNormal, , stLinkCriteria, , acWindowNormal
DoCmd.MoveSize 0, 0, 12000, 11000
Exit_Command40_Click:
Exit Sub
Err_Command40_Click:
MsgBox Err.Description
Resume Exit_Command40_Click
End Sub
In this case, the text that is entered for the search field is typically a 9-digit number, sometimes with a Letter at the end. Therefore, the text box and form field is classified as "text" instead of "number".
So, the problem is this:
as of this morning, this search function will open the form, but not match the value to and open the form to the correct record. Instead, it opens the form and lists "#Name" in all the fields. The table shows the value exists, and I can access it by navigating through all the form entries (instead of the search filter).
This has been working for many months with no issues. Then this morning it resulted in this. I am the only person able to modify the backend (access restrictions) and have made no modifications. However, this issue has presented itself on all users' frontends.
I am at a complete loss as to where to even start to investigate. Your help is greatly appreciated!
I'm a bit of a novice with Access, however this forum has typically had an answer when I'm completely befuddled...
So, here's a description of my DB:
I have a database that has a form used as a command bar. On that command bar is a text box. The value of that text box is used as a search field with a button. The searchable field has no duplicates, so the VBA code is written to match the number from the text box to a specific field on the form it opens. Like this:
Private Sub Command40_Click()
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = "[EN Number] ='" & Me.Text41.Value & "'"
stDocName = "EventList_Justified"
DoCmd.OpenForm stDocName, acNormal, , stLinkCriteria, , acWindowNormal
DoCmd.MoveSize 0, 0, 12000, 11000
Exit_Command40_Click:
Exit Sub
Err_Command40_Click:
MsgBox Err.Description
Resume Exit_Command40_Click
End Sub
In this case, the text that is entered for the search field is typically a 9-digit number, sometimes with a Letter at the end. Therefore, the text box and form field is classified as "text" instead of "number".
So, the problem is this:
as of this morning, this search function will open the form, but not match the value to and open the form to the correct record. Instead, it opens the form and lists "#Name" in all the fields. The table shows the value exists, and I can access it by navigating through all the form entries (instead of the search filter).
This has been working for many months with no issues. Then this morning it resulted in this. I am the only person able to modify the backend (access restrictions) and have made no modifications. However, this issue has presented itself on all users' frontends.
I am at a complete loss as to where to even start to investigate. Your help is greatly appreciated!