Solved BLANK SUBFORM

[accessonly11]

HI EVERYONE,

My sales order form with order details subform is part of spillted database. It is working well only on 1 user, while on other users subform is showing blank. What could be the possible reason. I checked most of the settings related like,
>db "open in share mode" option enable
>user have full control over network

i am using this code behind form open
DoCmd.OpenForm "SaleOrder", acNormal, , , , acWindowNormal

i also check all my options according to this article

Microsoft Access tips: Why does my form go completely blank?

Explains why no controls show on Microsoft Access forms sometimes, and how to address this issue.

allenbrowne.com

but still not work. any help please

 

[theDBguy]

First question, are all users sharing the same front end, or does everyone have their own copy?

 

[accessonly11]

everyone have their on fe

 

[Uncle Gizmo]

Take a copy directly from the desk where it is working and install that copy on a desk which is not working.

If the problem remains make sure you can see the table which fills the subform. Make sure you can see the records within that table.

If the problem persists, create a new sample form/subform to test.

 

[MajP]

can you post the results from running this code on the subform, so we can see the properties?

Dim rs As dao.Recordset
 Set rs = Me.Recordset
 Debug.Print "Data Entry " & Me.DataEntry
 Debug.Print "Filter On " & Me.FilterOn
 Debug.Print "Filter " & Me.Filter
 Debug.Print "Recordsource " & Me.RecordSource
 Debug.Print "Allow Additions " & Me.AllowAdditions
 Debug.Print "Recordset Type " & rs.Type
 rs.MoveLast
 Debug.Print "Record Count " & rs.RecordCount
 Debug.Print "Updateable " & rs.Updatable

 

[LarryE]

HI EVERYONE,

My sales order form with order details subform is part of spillted database. It is working well only on 1 user, while on other users subform is showing blank. What could be the possible reason. I checked most of the settings related like,
>db "open in share mode" option enable
>user have full control over network

i am using this code behind form open
DoCmd.OpenForm "SaleOrder", acNormal, , , , acWindowNormal

i also check all my options according to this article

Microsoft Access tips: Why does my form go completely blank?

Explains why no controls show on Microsoft Access forms sometimes, and how to address this issue.

allenbrowne.com

but still not work. any help please

It sounds like every PC may not be connected to the back-end file. Open the LinkeTable Manager on each PC and make sure they are connected to the back-end.

 

[arnelgp]

It is working well only on 1 user

and that user is you?

 

[accessonly11]

whenever 1st user close the file, and any otherone user opens his copy then sale form and subform show records (working ok). In short one time one file/user work well.

if 2nd user open db without closing 1st user, he get this error" the expression you entered ..... object that is closed or doesn't exist." and then this code highlited

this code being used to save total of retail, sale, discount etc taking from order detail's subform into order table.
I know this code is not according to rule, and i have to revise soon, but temporarily its working for me.

 

[accessonly11]

what is wrong here, please tell me

 

[arnelgp]

you don't need If...Else...End If.
you can shortcut it to:


Me!DiscountTotal = Nz(Me!tempDiscounttotal, 0)

 

[Pat Hartman]

Is this one of the MS bugs that was fixed a while back? I think my clients were aflicted with it in 2019 but for the life of me I can't remember how it was fixed. I do remember the IT people being very unhappy with the MS solution though.

 

[accessonly11]

can you post the results from running this code on the subform, so we can see the properties?

Dim rs As dao.Recordset
Set rs = Me.Recordset
Debug.Print "Data Entry " & Me.DataEntry
Debug.Print "Filter On " & Me.FilterOn
Debug.Print "Filter " & Me.Filter
Debug.Print "Recordsource " & Me.RecordSource
Debug.Print "Allow Additions " & Me.AllowAdditions
Debug.Print "Recordset Type " & rs.Type
rs.MoveLast
Debug.Print "Record Count " & rs.RecordCount
Debug.Print "Updateable " & rs.Updatable

please tell me where to put this code in subform's vba code window,
in general declaration or under specific event

 

[accessonly11]

It sounds like every PC may not be connected to the back-end file. Open the LinkeTable Manager on each PC and make sure they are connected to the back-end.

i checked its okay, and linked correctly

 

[accessonly11]

Take a copy directly from the desk where it is working and install that copy on a desk which is not working.

If the problem remains make sure you can see the table which fills the subform. Make sure you can see the records within that table.

If the problem persists, create a new sample form/subform to test.

i take copy directly form pc where its working, but failed,
i can see order details subform source table, it is accessible
now going to last step by making new sample form and subform

 

[accessonly11]

still have errors

you don't need If...Else...End If.
you can shortcut it to:


Me!DiscountTotal = Nz(Me!tempDiscounttotal, 0)

 

[accessonly11]

i do many "experiments" during these 2,3 days.
last one

i took copy of my backend from network driver to my local pc,
then connected (table linked) my both front ends with it
now new forms working.

what is the problem, is there any issue in network/sharing or something else.
why i cannot use the old sales form. please guide

 

[accessonly11]

i just received this message while opening old sales order form in second pc

 

[arnelgp]

on access option->client setttings, you should have this:

 

[Kamayo Ako]

HI EVERYONE,

My sales order form with order details subform is part of spillted database. It is working well only on 1 user, while on other users subform is showing blank. What could be the possible reason. I checked most of the settings related like,
>db "open in share mode" option enable
>user have full control over network

i am using this code behind form open
DoCmd.OpenForm "SaleOrder", acNormal, , , , acWindowNormal

i also check all my options according to this article

Microsoft Access tips: Why does my form go completely blank?

Explains why no controls show on Microsoft Access forms sometimes, and how to address this issue.

allenbrowne.com

but still not work. any help please

Since that's splitted database. Share your frontend copy to each user computer and relink to backend. Make sure to save as accde and disable shift after your relink the backend. Maybe you just share the frontend shortcut to the user not the frontend itself.

 

[Kamayo Ako]

i just received this message while opening old sales order form in second pc
View attachment 105745

The reason for this is you i share the single frontend into more than one user. I mean, you share the folder which you can access the frontend shortcut and once one user will open that frontend i will become locked to other users. However if you put a copy of the frontend to each user computer and just relink to the backend which the tables so now you can simultaneously use the system together.