Search results for query: *

Is there a way to make row hearder in a continuous form? I have a continuous form like below (first line is the form head): ID Name Jan99 Feb99 Mar99 Apr99 ... 1 John 10 11 20 5 ... 2 Sam 1 111 26 4 ... ... ... ... ...

Is there a way to call an Access function from a Excel VBA codes? Thanks.

Hi, wemeier: Thanks for the reply. Actually, I am trying to see if there is any way to set it up like the page header, so it will show up on every page. Thanks.

I have a report that will expand to two pages wide, the first column is the "Name" field, I would like to make the "Name" field also appear on the second page. In Excel I can just do this in the print page setup, set the first column to repeat, how can I do this in Access...

Hi, lameid: thanks for your responds. I have set the regional settings to "dd/mm/yy", but Access still changes the date format to "mm/dd/yy". The reason I am trying to set the date format is that seems when doing dates comparison, the format will affect the result. In...

In my code, I am trying to assign a date value to "thisDate", when I put in thisDate = #July 01, 2002# or thisDate = #1/7/2002# Access keeps changing it to thisDate = #7/1/2002#. how can I prevent Access from changing the date format? Thanks for any help.

Try changing your subforms' "Recordset Type" to "Dynaset (Inconsistent Updates)".

Hi, lynnvictoria: Would you please email me a copy of the form too? my email t_lander@hotmail.com. thanks.

Hi, Jeff: Thanks for your response. I think I havn't made my question clearly. What I would like to do is to enter the formula directly into the field, the formula is not fixed, it will change, like this time it's 4+5, next time may change to 2+2. And after it accept the formula, it will...

When I tried to update a field, it has a "Could not update; currently locked" error, how can I find out which user lock the record? Thanks for any help.

Is it possible enter a formula into a field? I have a form, which has a number field accepting only numbers. I am trying make it accepting formula (ex. =4+5) into the field, like in Excel, can this be done? Thanks for any help

In VBA, can I find out what group/groups a user belongs to? Thanks.

In VBA, can I find out what group/groups a user belongs to? Thanks.

On a form, there is a field with the input mask "99/99/00", placeholder of "_", when a user clicks in the field, it will show "__/__/__". Is it possible to make it show "dd/mm/yy"? Thanks for any help.

I have a date field with the input mask "99/99/00", with a placeholder "_". when user click in this field, it will display as "__/__/__", is it possible to let it show "mm/dd/yy" ? Thanks for any help.