MS Access Solutions Houston TX

Looking to build an accdb to keep track of equipment in multiple places including all granular details about information pertaining to the individual asset. Would like to include a column for “Connectivity” and be able to generate a graphical network diagram for my bosses who don’t get IT and just want to see pictures and colors. I also want this graphic to be in a form for my colleagues who are lazy to interact with as it will be easier for them to understand. Is Access a good solution to my problem or should I steer in another direction?

Looking to build an accdb to keep track of equipment in multiple places including all granular details about information pertaining to the individual asset. Would like to include a column for “Connectivity” and be able to generate a graphical network diagram for my bosses who don’t get IT and just want to see pictures and colors. I also want this graphic to be in a form for my colleagues who are lazy to interact with as it will be easier for them to understand. Is Access a good solution to my problem or should I steer in another direction?

Are there any online courses that one can take for Access? Not just videos, but actual courses that include instructors (pre-recorded or not), assignments, etc.? Kind of like codeacademy.

I have a main report with sub-reports. Within one of the subreports is a block for signatures. The number of signatures will vary so I am attempting to hide the signature lines where they are not necessary.

I have set the OnLoad to:

Dim strTrustee2, strTrustee3, strTrustee4 As String

strTrustee2 = DLookup(“Trustee2”, “tblHardshipAmendment”)

strTrustee3 = DLookup(“Trustee3”, “tblHardshipAmendment”)

strTrustee4 = DLookup(“Trustee4”, “tblHardshipAmendment”)

If (IsNull(strTrustee2) = False) Then Line209.Visible = True

If (IsNull(strTrustee3) = False) Then Line212.Visible = True

If (IsNull(strTrustee4) = False) Then Line215.Visible = True

When viewing the report by itself this code works. However, when it is combined as a subreport the code breaks. I cannot, for the life of me, figure out how to fix this. Lines cannot be set to controls.

Any help? Thanks!

I have a form and I would like to do a check when I enter a data into the field and once I press enter into the field it will check whether is duplicate or not.

I found this script on another forum:

Private Sub txtNewData_BeforeUpdate(Cancel As Integer)

Dim rs As Recordset

Set rs = CurrentDb.OpenRecordset(“MyDataTable”, dbOpenSnapshot)

rs.FindFirst “txtDataField = “”” & Me![txtNewData] & “”””

If Not rs.NoMatch Then

 Cancel = True MsgBox "Duplicate Value" 

End If

End Sub

The guy who posted it said to substitute the words in parenthesis with my own, but I’m not sure what words to use there. He also said “DAO reference required” and I’m not sure what that means or how to do it. And do I just put this script in ‘create new query > sql view’? Thanks for the help

Has anyone used the Access SQL Editor? If so, how do you like it?

I’m thinking of using it to replace the atrocious native MS Access SQL View when writing SQL statements.

I have a form and I would like to do a check when I enter a data into the field and once I press enter into the field it will check whether is duplicate or not.

I found this script on another forum:

Private Sub txtNewData_BeforeUpdate(Cancel As Integer)

Dim rs As Recordset

Set rs = CurrentDb.OpenRecordset(“MyDataTable”, dbOpenSnapshot)

rs.FindFirst “txtDataField = “”” & Me![txtNewData] & “”””

If Not rs.NoMatch Then

 Cancel = True MsgBox "Duplicate Value" 

End If

End Sub

The guy who posted it said to substitute the words in parenthesis with my own, but I’m not sure what words to use there. He also said “DAO reference required” and I’m not sure what that means or how to do it. And do I just put this script in ‘create new query > sql view’? Thanks for the help

Is there a way to prompt the user for a drop-down menu based on a table rather than a text field when running a query? So far the only way I have found to achieve this is to create a form that opens to a query, but was hoping for a simpler solution.