IT inventory

[aaronbrowne]

Hi Guys,

Hope you are all keeping well.

Please help me I am lossing the head with this. I have done this type of thing before but will not work this time around. I was upload the MDB with the post.

It's just a small Database for computer,latops and server specifications and the like. Please.please help me. Take Care.

Regards

Aaron

 

[KenHigg]

Zip it first.

kh

 

[aaronbrowne]

Cannot upload the file

 

[aaronbrowne]

Zip file also convert to access97 from 2003

here it is! Thanks in advanced.

Regards

Aaron

 

[KenHigg]

And the problem is?

 

[aaronbrowne]

The Problem

Hi Sorry,

The problem is trying to link the search form the the actul computer spesifications to the show full details. Access used to be easy when linking tables I have been pulling my hair out because I have done this before.

Thanks for your replies do far.

Regards

Aaron

 

[KenHigg]

Straight from a button wizard:

Private Sub Command34_Click()
On Error GoTo Err_Command34_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "frmSpecs"
    
    stLinkCriteria = "[SysID]=" & Me![SysID]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command34_Click:
    Exit Sub

Err_Command34_Click:
    MsgBox Err.Description
    Resume Exit_Command34_Click
    
End Sub

kh

 

[aaronbrowne]

Thanks for the help but it did not work for me. Added the code
Private Sub Command34_Click()
On Error GoTo Err_Command34_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmSpecs"

stLinkCriteria = "[SysID]=" & Me![SysID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command34_Click:
Exit Sub

Err_Command34_Click:
MsgBox Err.Description
Resume Exit_Command34_Click

End Sub

Also renamed the command button to match the above code. But the frmSpecs opens with ablank record. Please help.

Regards

Aaron

 

[KenHigg]

Maybe:

stLinkCriteria = "[SysID]='" & Me![SysID] & "'"

???
kh

 

[aaronbrowne]

Hi I say we nearly have it. I am getting an error saying OPenForm action cancelled. What do you think.

Aaron

 

[KenHigg]

Hum.... Not sure. Are you trying it with every thing closed, then just open the main form and try it...

kh

 

[aaronbrowne]

Thats it the main form when ran on its own fails also but if you run the Qsystem query that the form is based upon then it tries to find sysid from frmspecs which is wrong. The prolem was the query critiera [Forms]![frmspecs]![SysID] which should of been [Forms]![frmSystemSearch]![SysID].

And the concludes the tread yes yes yes.....

Thanks you for your help man.

Regards

Aaron

 

[KenHigg]

Cool.

kh