Runtime 2010 issues

[mafhobb]

Hi everyone.

I have a db that I am getting reaty to deploy in a network environment. My users will be setup with Access Runtime 2010.

Everything has been tested to work well with the full Access 2010 version and now I ma doing final checks with the runtime.

Two things are happening:

1- This is minor, but on a subform, right on top of a field with an automatic date insertion, a small calendar icon keep showing up. The user can click ion this icon and a calendar shows up, however clicking on any date does not change the value of the field, which is entered programatically. This is fine, but how can I prevent that calendar icon from showing up?

2- This is more serious. One form with two subforms. The first subform is setup as a continuous type while the second has a single text box. Using the full Access 2010 version, the user clicks on a record in the first form and the textbox automatically shows info for that record. With Runtime 2010, the user needs to click on the textbox for it to show that info. Why is this happening?

Anybody has any ideas?

Thanks

mafhobb

 

[Jeanette Cunningham]

The usual way to hide the calendar icon is to set the 'Show date picker' property for the textbox (on its property sheet) to Never. You can do the same thing for the same field in the table.
Are you suggesting that you have already done this and that the runtime is still showing the calendar icon?

What code are you using to automatically show the value in the textbox on the single form after user clicks on a record in the first subform?

 

[mafhobb]

Oddly enough...when I changing the date picker property to never seems to have changed the behavior of the textbox.

It is now showing up automatically although sometimes it take a second or two.

I need to do a few tests.

mafhobb

 

[flyinghippo99]

The usual way to hide the calendar icon is to set the 'Show date picker' property for the textbox (on its property sheet) to Never. You can do the same thing for the same field in the table.
Are you suggesting that you have already done this and that the runtime is still showing the calendar icon?

What code are you using to automatically show the value in the textbox on the single form after user clicks on a record in the first subform?

Jeanette et al,

This is very handy! Didn't know one could do this. Cool. My question is there a way to turn off the calendar icon programmatically in VBA? Since these tables are created on the fly...

thnx!

flyinghippo99

 

[Jeanette Cunningham]

I assume that when you create tables on the fly, you can use DDL queries to change the properties of particular fields. I have never needed to create tables on the fly - so haven't tried it. Search for posts on using DDL to modify tables or tabledefs.
I believe you can also store an empty table, set with the properties you desire, and use it as a template by copying it to a new database.