Access for IT equipment

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?

submitted by /u/vaneeladrop
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

Struggling to create an unique label for a box with multiple items inside

Struggling to create an unique label for a box with multiple items inside

Database has been in place for years and works great but now trying to add more features. Right now I am trying to create a label for each box and list what is packed in that box on the label along with a unique barcode for that box.

tblOrder has our overall order data customer info. tblOrderDetail has what product is shipped. In BoxNumber the user is manually entering what box that item is inserted into.

Any help is appreciated.

https://i.redd.it/srrcnrvdani31.png

submitted by /u/SSSlippy
[link] [comments]

Posted on

Access for IT equipment

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?

submitted by /u/vaneeladrop
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

Hide a LINE within Access Sub-report conditionally

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!

submitted by /u/slobdogg
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

How to check duplicate records

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

submitted by /u/Alterex
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

How to check duplicate records

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

submitted by /u/Alterex
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on