cpepper5702
Registered User.
- Local time
- Today, 07:08
- Joined
- Jan 16, 2013
- Messages
- 13
Hey everyone,
Okay... I have been stuck on this issue for 2 days now and I am finally subjecting myself to outside help :banghead:. I am creating a large database that tracks computer assets. To help the system admins (SA's), I am trying to create a search form where they can filter by certain criterias. For example, if the user wants to search for servers running MS Server 2008 on the FISHPOND network, then the SA only has to type that information in the text boxes. After they are done with the results of the filter, I need them to clear the filter results. Everytime I click those buttons using my code, it gives me the error
"Run-time error '2580':
The record source 'SELECT * Asset Manager ' specified on this
form or report does not exist."
I'm probably not making a lot of senese on account that my brain is fried and I would rather give this job to our DBA team. I'd rather do it myself.
I can't post any screenshots from the original DB because it is on a different network that doesn't touch the internet. So I made another database that is similar to it to take screenshots of. I appologize again if I am being vague. If anyone needs more clarification please ask. Thanks a lot guys and gals! Below is the code for the "SEARCH" and "CLEAR" button.
Search Button Code: (It's telling me after RecordSource is the issue)
Clear Button Code: (Like the last code, after RecordSource is the issue)
Okay... I have been stuck on this issue for 2 days now and I am finally subjecting myself to outside help :banghead:. I am creating a large database that tracks computer assets. To help the system admins (SA's), I am trying to create a search form where they can filter by certain criterias. For example, if the user wants to search for servers running MS Server 2008 on the FISHPOND network, then the SA only has to type that information in the text boxes. After they are done with the results of the filter, I need them to clear the filter results. Everytime I click those buttons using my code, it gives me the error
"Run-time error '2580':
The record source 'SELECT * Asset Manager ' specified on this
form or report does not exist."
I'm probably not making a lot of senese on account that my brain is fried and I would rather give this job to our DBA team. I'd rather do it myself.
I can't post any screenshots from the original DB because it is on a different network that doesn't touch the internet. So I made another database that is similar to it to take screenshots of. I appologize again if I am being vague. If anyone needs more clarification please ask. Thanks a lot guys and gals! Below is the code for the "SEARCH" and "CLEAR" button.
Search Button Code: (It's telling me after RecordSource is the issue)
Code:
Private Sub Search_Click()
On Error GoTo errr
Me.Asset_Manager_subform.Form.RecordSource = "SELECT * FROM Asset Manager " & BuildFilter
Me.Asset_Manager_subform.Requery
Exit Sub
errr:
MsgBox Err.Description
End Sub
Clear Button Code: (Like the last code, after RecordSource is the issue)
Code:
Private Sub Clear_Click()
Me.Asset_Manager_subform.Form.RecordSource = "SELECT * FROM Asset Manager "
Me.Asset_Manager_subform.Requery
Hostname = ""
Network = ""
OSFamily = ""
OSName = ""
OSVersion = ""
IPAddress = ""
MACAddress = ""
EquipmentClass = ""
Manufacturer = ""
Model = ""
SerialNumber = ""
ServiceTag = ""
Hostname.SetFocus
End Sub