Search results

  1. mhartman

    Financial (Fiscal) Year Field

    Hello: Your welcome and good luck with this.
  2. mhartman

    What is the future of developing using access?

    Hello: On those kind of people, its really a sour grapes type of thing. Amen to what Bob said above. Regards Mark
  3. mhartman

    Financial (Fiscal) Year Field

    Here you go: http://support.microsoft.com/kb/210249/en-us Regards
  4. mhartman

    Access Security Open Exclusive

    Hello: It is my understanding that it has to be Exclusive or Shared, not both. Otherwise what would be point of the option? Regards Mark
  5. mhartman

    Access Security Open Exclusive

    Hello: It's a "permissions" thing: Types of permissions (MDB) Show All Hide All Note The information in this topic applies only to a Microsoft Access database (.mdb). The following table summarizes the permissions (permissions: A set of attributes that specifies what kind of access a user...
  6. mhartman

    Is there a way to calculate and display the percentage of checked checkboxes on a rep

    Hello: Yes. On your form or report count your total records and then count the records "checked". Then divide your records checked by the total records. That will give you a percentage. Regards Mark
  7. mhartman

    General Understanding of Text Boxes, Numeric Fields

    Hello: I have enclosed an example of one way this is done. Regards Mark
  8. mhartman

    Count of records

    Hello: If your query was the recordsource for a form you could use an unbound text box and utilize the Count or Dcount functions. In a query, you can utilized the Domain Aggregate built in function Count. Regards Mark
  9. mhartman

    modify date field

    Hello: Your are right in your assumption: Place the code under the OnClick event. Regards Mark
  10. mhartman

    Query Help

    Hello "Value Lists" are good from small unchanging data. Use the Table/Query option for more dynamic data types. In any case the solution would be the same. Bob above is a good example to study. Regards Mark
  11. mhartman

    How do I link a text box to a column on a table?

    Hello: The below article shows how to create a "Look-Up" table. http://support.microsoft.com/kb/311173/en-us Regards Mark
  12. mhartman

    Query Help

    Hello: Copy that: Please see my enclosed example database. Open the database and select a state such as CO, or CA, then press the query button. Notice that the query returns only those records Regards Mark
  13. mhartman

    Query Help

    Hello: Basically.... In the Criteria section of your accidents query for the Field of Name or whatever your calling it, put: Forms![YourFormName]![YourComboBoxName] Then save the query and open your form, select a name and run your query. Regards Mark
  14. mhartman

    Combo box default value

    Hello: Store your string in the TAG property of the combo box. Regards Mark
  15. mhartman

    spacing between numbers in a cell

    Hello: Your welcome. Mark
  16. mhartman

    Problems with selecting data from one form and inserting into sub-form

    Hello: What you want to do is make a lookup table: http://support.microsoft.com/kb/304463/en-us Regards Mark
  17. mhartman

    Combo box default value

    Hello: The syntax in code would be: YourComboBoxName.DefaultValue=TechID or Try YourComboxName = TechID Regards Mark
  18. mhartman

    Open a website in access

    Hello: One way would be to put your URL in the HyperLink Address property of a command button. Another way would be to store the URL's in a table. Regards Mark
  19. mhartman

    spacing between numbers in a cell

    Hello: The Format mask would be the following: 000 0000 0000 Regards Mark
  20. mhartman

    spacing between numbers in a cell

    Hello: In your cell select Format, Cells, Custom from the menu. This allows you to construct a custom view for your data. There are some made already that can be modified. Regards Mark
Back
Top Bottom