Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tomlander

    Row Header in a continuous form

    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 ... ... ... ... ...
  2. tomlander

    calling an Access function from Excel VBA

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

    columns to repeat

    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.
  4. tomlander

    columns to repeat

    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...
  5. tomlander

    Date format problem

    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...
  6. tomlander

    Date format problem

    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.
  7. tomlander

    Recordset not updateable

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

    Third-party software for e-mail from Access2000

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

    entering formula

    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...
  10. tomlander

    How to find out which user lock the record?

    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.
  11. tomlander

    entering formula

    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
  12. tomlander

    find out which group a user belongs to.

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

    find out which group a user belongs to

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

    input mask displaying

    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.
  15. tomlander

    Input Mask Displaying

    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.

Part and Inventory Search

Back
Top