New Laptop Dilemma

  • Thread starter Thread starter Tee See
  • Start date Start date
T

Tee See

Purchased a new laptop. Had my database copied to a server as backup. Copied
it back to the new machine and herein lies the problem.
The main function is to look up a specfic item in one form and double click
on the desired item. Another form/subform then appeared but doesn't since
it was copied to the new machine. ALL the individual forms function
properly. The required code under the DoubleClick seems to be intact.

Does anyone have any suggestions about settings or anything? Frustrated!
Thanks
 
I hope this is still an ACCESS issue ... but here goes

After the lookup and the DblClk, the main form opens as a result of the
following simple code.

Private Sub SISItemCode_DblClick(Cancel As Integer)

DoCmd.OpenForm "frmMaterialMasterMain", , ,
"SISItemCode=forms![frmMainList]![sfrmItemsList]![SISItemCode]"

End Sub

As said on last post FrmMaterialMasterMain does open but is blank.
Today I stumbled across the fact that once open it had the "Apply Filter"
icon depressed at the top of the screen. Once I clicked on that icon the
frmMaterialMasterMain form filled in but at the first record in the database
and not on the item that I had double clicked on. The question now becomes
"What is causing the "apply filter" to apply?

Again Thanks
 
You are filtering by SISItemCode. The syntax is slightly off too:

forms![frmMainList]![sfrmItemsList]![SISItemCode]

should read:

forms![frmMainList]![sfrmItemsList].Form![SISItemCode]
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Tee See said:
I hope this is still an ACCESS issue ... but here goes

After the lookup and the DblClk, the main form opens as a result of the
following simple code.

Private Sub SISItemCode_DblClick(Cancel As Integer)

DoCmd.OpenForm "frmMaterialMasterMain", , ,
"SISItemCode=forms![frmMainList]![sfrmItemsList]![SISItemCode]"

End Sub

As said on last post FrmMaterialMasterMain does open but is blank.
Today I stumbled across the fact that once open it had the "Apply Filter"
icon depressed at the top of the screen. Once I clicked on that icon the
frmMaterialMasterMain form filled in but at the first record in the database
and not on the item that I had double clicked on. The question now becomes
"What is causing the "apply filter" to apply?

Again Thanks

Arvin Meyer said:
Try posting the code.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
Click to expand...
Click to expand...
 
Thank you! That slight change has done the trick. Much appreciated.
Best Regards

Arvin Meyer said:
You are filtering by SISItemCode. The syntax is slightly off too:

forms![frmMainList]![sfrmItemsList]![SISItemCode]

should read:

forms![frmMainList]![sfrmItemsList].Form![SISItemCode]
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Tee See said:
I hope this is still an ACCESS issue ... but here goes

After the lookup and the DblClk, the main form opens as a result of the
following simple code.

Private Sub SISItemCode_DblClick(Cancel As Integer)

DoCmd.OpenForm "frmMaterialMasterMain", , ,
"SISItemCode=forms![frmMainList]![sfrmItemsList]![SISItemCode]"

End Sub

As said on last post FrmMaterialMasterMain does open but is blank.
Today I stumbled across the fact that once open it had the "Apply Filter"
icon depressed at the top of the screen. Once I clicked on that icon the
frmMaterialMasterMain form filled in but at the first record in the database
and not on the item that I had double clicked on. The question now
becomes
"What is causing the "apply filter" to apply?

Again Thanks

Arvin Meyer said:
Try posting the code.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Purchased a new laptop. Had my database copied to a server as backup.
Copied
it back to the new machine and herein lies the problem.
The main function is to look up a specfic item in one form and double
click
on the desired item. Another form/subform then appeared but doesn't
since
it was copied to the new machine. ALL the individual forms function
properly. The required code under the DoubleClick seems to be intact.

Does anyone have any suggestions about settings or anything? Frustrated!
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Tee See said:
Thank you! That slight change has done the trick. Much appreciated.
Best Regards

Arvin Meyer said:
You are filtering by SISItemCode. The syntax is slightly off too:

forms![frmMainList]![sfrmItemsList]![SISItemCode]

should read:

forms![frmMainList]![sfrmItemsList].Form![SISItemCode]
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Tee See said:
I hope this is still an ACCESS issue ... but here goes

After the lookup and the DblClk, the main form opens as a result of the
following simple code.

Private Sub SISItemCode_DblClick(Cancel As Integer)

DoCmd.OpenForm "frmMaterialMasterMain", , ,
"SISItemCode=forms![frmMainList]![sfrmItemsList]![SISItemCode]"

End Sub

As said on last post FrmMaterialMasterMain does open but is blank.
Today I stumbled across the fact that once open it had the "Apply Filter"
icon depressed at the top of the screen. Once I clicked on that icon the
frmMaterialMasterMain form filled in but at the first record in the database
and not on the item that I had double clicked on. The question now
becomes
"What is causing the "apply filter" to apply?

Again Thanks

Try posting the code.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Purchased a new laptop. Had my database copied to a server as backup.
Copied
it back to the new machine and herein lies the problem.
The main function is to look up a specfic item in one form and double
click
on the desired item. Another form/subform then appeared but doesn't
since
it was copied to the new machine. ALL the individual forms function
properly. The required code under the DoubleClick seems to be intact.

Does anyone have any suggestions about settings or anything? Frustrated!
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top