Search:

Type: Posts; User: robinr; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    443

    Re: Linking to an Excel Spreadsheet (2003)

    Hans is there any work around or patch for doing the linking and updating?
  2. Replies
    3
    Views
    459

    Re: Change field to autonumber (2002)

    I don't think that would work. I have another idea but don't know how to do it. The field I want to increment the number in is in a subform. Instead of have an autonumber can I have it take the...
  3. Replies
    3
    Views
    459

    Change field to autonumber (2002)

    How can I change a number field to autonumber? I want the new autonumber field to keep the same number as the current number field.
    Thank you in advance.
  4. Replies
    4
    Views
    1,244

    Re: Clear Combo Box (Access 2003)

    Thank you so much - got it working
  5. Replies
    4
    Views
    1,244

    Re: Clear Combo Box (Access 2003)

    Thanks Hans - got it working
  6. Replies
    4
    Views
    1,244

    Clear Combo Box (Access 2003)

    How do I get a combo box to show nothing when the form is opened. Now if I select something in the combo box - the next time I open the form the combo box still shows the same selection.
    Thanks.
  7. Replies
    8
    Views
    549

    Re: Macro (Excel 2003)

    Hans as usual you are wonderful. Thank you so much it works great.
  8. Replies
    8
    Views
    549

    Re: Macro (Excel 2003)

    If I do a filter on Elec in col H (Discipline) I get 22 but on the Totals col. in col F I get 16. Can I send this to you again?
  9. Replies
    8
    Views
    549

    Re: Macro (Excel 2003)

    Hans it still didn't work - What are the green parts of the VB Macro?
    Thanks
  10. Replies
    8
    Views
    549

    Re: Macro (Excel 2003)

    Hi Hans - again I get asked to fix something - just because I know a little bit about Access & Excel. Thanks for your help. The spreadsheet is supposed to Count the Disciplines when you click the...
  11. Replies
    8
    Views
    549

    Macro (Excel 2003)

    I was wondering if someone could help me with a macro in Excel - it isn't counting the Disciplines like it is supposed to. Thank you in advance.
  12. Replies
    1
    Views
    583

    Format Date (Access 2003)

    Could someone help me with the way to format the date in an unbound field. The field is: ="Summary for: " & [CN_MAR_DATE] The date displays as ex: 01/01/08 I want it to display as 01 Jan 08...
  13. Replies
    4
    Views
    878

    Re: Dynamic Parameter Query (Access 2003)

    I tried your suggestion - it didn't work - I think I have to put it into all 3 queries to get it to work properly. Sorry I'm not very good at explaining. Thanks for all your help. I think I may...
  14. Replies
    4
    Views
    878

    Re: Dynamic Parameter Query (Access 2003)

    Sorry for the long delay - I was so tired of working on the Database I went to bed. Here goes- I will try to explain it better.
    I have a table of items (over 6,000) that I have 3 queries counting...
  15. Replies
    4
    Views
    878

    Dynamic Parameter Query (Access 2003)

    I think that this is a really difficult solution - at least for me. I need a query / table that will.....update on a constant date.
    EX. March 30, April 30 etc. I need it to give me a count and...
  16. Replies
    1
    Views
    292

    Access Query (Access 2003)

    I have set up a parameter query with a Between Start & End date. That works fine - except I need the end date to become a field in my query. I tried this with the Between, then 2 new fields Start &...
  17. Replies
    4
    Views
    391

    Re: Access Chart (2003)

    I have no idea how to do that. If you have any examples that would help.
    Thanks again
  18. Replies
    4
    Views
    438

    Re: Access Query (2003)

    I have queries that specify different criteria for a table. Each query gives me a different result - I need the record number of the queries to create a chart. Hopefully this makes sense. Thank...
  19. Replies
    4
    Views
    391

    Access Chart (2003)

    Is it possible to take a record count from 4 queries and create a Chart Report?
    Thank you in advance.
  20. Replies
    4
    Views
    438

    Access Query (2003)

    Is it possible to display the record count in a query?
  21. Replies
    5
    Views
    1,116

    Re: Count check Box (Access 2000)

    Morning Hans, got busy so I couldn't get back to you. Attached is the stripped down db. I have the check box in the master table. I want to count it once for each employee. Thank you for looking...
  22. Replies
    5
    Views
    1,116

    Re: Count check Box (Access 2000)

    Thanks Hans - I did try this but it still counts for each time that qualifies. I have the Qualifies field in the Employee table, then the times the employee clocked in are in another table. We have...
  23. Replies
    5
    Views
    1,116

    Count check Box (Access 2000)

    Is there an easy way to count the # of check boxes in a report? I have the Active check box in the 1 table but It keeps coming up with a count of many table check boxes within the group.
  24. Replies
    3
    Views
    375

    Nested if formula (2003)

    Below is a formula that I've tried and not even sure if it should be an if function. Would someone steer me in the right direction for: Anything under 78% = 0, 78% - 80% = 40, 80%-84% =50, 84% -...
  25. Replies
    3
    Views
    624

    Re: Share Access on a Network (Access 2000)

    I think it would be the database. It is being used by 1 user right now. It is going to be placed on a network drive so that 3 people can access it. It is just a regular Access 2000 database...
Results 1 to 25 of 92
Page 1 of 4 1 2 3 4