Blank forms with 2007

[Zigzag]

Hey All

I have a problem that I hope someone can help me with.

I visited a client today who is running my database (Access 2003 .mde) in a multi user environment (around 15 users). Each PC has their own FE and runs on Access 2003 runtime on XP machines. All is good.

They have just added 3 additional machine XP SP3 with Microsoft Office Professional Plus 2007 Version No 12.0.6425.1000. Each time they switch between using my DB(2003) and other DBs(2007) the usual installation switch occurs. Today I changed the shotcut target from

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Program Files\MSTS\MSTS.mde" /runtime


To

"C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE" "C:\Program Files\MSTS\MSTS.mde" /runtime

To run the software under 2007 instead of 2003 and avoid the installation switch.

The problem that I have is that one PC works fine without issues, however the other two work apart from certain forms display blank without any errors.

I have done some searching and have a couple of things to try but due to the customer being 2.5Hrs drive away I would like to throw it out to you guys to ask for help before I visit again.

I managed to try the following on site today with the same results.
Running .mdb version
Trusted Certificate Path in several locations.
Reg edit key change from 3 to 2 for the sandbox mode.
Installed office SP2

I can’t understand why its good on 1 PC but not on the other 2.

Thanx for any help.

Additional:

One of the reasons that I am asking for help is that I test my DB on a Win7 machine with A2007 and am failing to reproduce the results that I have seen at the customers.

 

[SOS]

So you made sure to add a trusted location (where the frontend is) for each of the new PC's? Each one has to have the trusted location set as it is a per computer setting and not per database setting.

 

[Zigzag]

Yep....Thats where I first started checking when I had problems.

I will try to strip my db down tomorrow to post on here to see if anyone would be kind enough to test it with Access 2007 and let me know if what results they get.

Thanx for posting so quick, did you see the Additional on the original post?

 

[SOS]

Yeah, perhaps getting a copy we can try it. I can do it using XP SP3, so that might help.

 

[Zigzag]

I really appreciate your help.

Garry

 

[missinglinq]

By "forms display blank" do you mean that the textboxes and other controls don't appear on the forms?

If a form is bound to a record source and the record source is empty and new records cannot be added no controls will show on the form.

If this the case here, my guess would be that this is a network problem and the errant machines don't have read/write privileges to the shared folder where the back end resides, and hence there is no data available to them nor can new records be added.

 

[Zigzag]

Hi Missingling

By "forms display blank" do you mean that the textboxes and other controls don't appear on the forms?

The forms are completely empty, no text boxes, labels etc
Just for info the forms are designed without headers or footers.

If a form is bound to a record source and the record source is empty and new records cannot be added no controls will show on the form.

Absolutely!... I didn't check the record source but it is using the same criteria as the PC that does work. This is on my list of things for the next visit.

If this the case here, my guess would be that this is a network problem and the errant machines don't have read/write privileges to the shared folder where the back end resides, and hence there is no data available to them nor can new records be added.

This was also checked and the user has 'full control' over the BE, besides I was logged on as administrator.

Keep questioning me please!

Thanx

 

[gemma-the-husky]

just to repeat what linq just said

if you have a form with no data, and the form is set to not allow additions (or is based on a non-updateable record set) all the fields in the details section will be blank

maybe your remote locations are just selecting data for a single region?

headers/footers will be Ok - but you say you dont have these.

Note that blank is not the same as NULL - its undefined, and cannot be tested

if nz(anyfield,0) will PRODUCE A RUNTIME ERROR - because anyfield is UNDEFINED - although the error can be trapped, its a really strange error number.

 

[Zigzag]

Dave

Allthought I have not checked it the criteria for the record source is identical to the working machine.
If I switch the shortcut back to Office 11 it works fine, switch it back to office 12 the same form of the same db is blank!!! Dont figure?

 

[Zigzag]

OK I have now stripped it down.(without linked tables

If anyone tests this can they let me know if the 'Local Settings' form opens from the main form or if it is blank.

Garry

 

[SOS]

Okay, a couple of things.

1. When you have parameters you are not using, don't put "" in there, just leave it blank and separate with the comma.

for example - this:
DoCmd.OpenForm "LocalSettingsHide", acNormal, "", "", , acHidden

should be this:
DoCmd.OpenForm "LocalSettingsHide", acNormal, , , , acHidden

2. This code is causing the problem. Don't know which part but if I comment it out, then the form opens fine.

If [Forms]![LocalSettingsHide]![Smooth] = -1 Then
    Call SetTranslucent(Me.hWnd, 0)
    DoEvents
    ReSizeForm Me
    Me.Visible = True
    Call UIProcessFadeIn(Me, 255)
    Call SetTranslucent(Me.hWnd, 255)
Else
    Call SetTranslucent(Me.hWnd, 0)
    DoEvents
    ReSizeForm Me
    Me.Visible = True
    Call UIProcessFadeInQuick(Me, 255)
    Call SetTranslucent(Me.hWnd, 255)
End If

 

[Zigzag]

Hi Smeghead

Thank for looking at this for me.

The "" are just remnants from when the db was being designed, but point taken I will take care with my house keeping.

The code that you pointed out is for fading forms in and out (cosmetic effect), I have this code on most of my forms and they are working in 2007 but that doesnt mean that it cant be removed.

Before comment out the code did the form open blank?

 

[SOS]

Before comment out the code did the form open blank?

Yes, it did open blank for me until I removed that code. Although the form when opened from the Nav Pane, opened fine even with the code in place, but it would not open from the Switchboard with the code in place.

 

[Zigzag]

Brilliant!!!!

With what you have told me I started to check through my DB.
It would appear that all the forms I have Identified as showing blank have the fade in / fade out code in the 'On Open' event whereas the forms that work have the code in the 'On load' event.

If it's not too much trouble could you try moveing the code to the 'On Load' Event.

 

[SOS]

Yep, moving it to the Load event - it then is no longer blank when it opens up.

 

[Zigzag]

Smeghead your a star, Thank you.

I just hope A2007 doesn’t throw up any more anomalies.

 

[SOS]

Glad I could help out.