Search results

  1. V

    Entering notes in subform - entering new one at the top

    I have searched the forums on several terms, like descending, notes, dates, sort, subform, continuous... but am not finding the answer I am looking for. Any help would be greatly appreciated. I am trying to enter notes in a continuous subform where the notes are entered with a date field...
  2. V

    Auto-filled field data capture to table??

    Bob: Yes. That's right. But, how do I make that happen after autopopulating the form field? THANKS! Tom
  3. V

    Auto-filled field data capture to table??

    I have a table of salesreps with region and email addresses. On my form, when the salesrep is entered, the region and email autopopulate. However, I want to capture the region into my main record so that if the rep changes regions, all the previously entered records will reflect the previous...
  4. V

    Need combination chart axis help

    I have built a Gantt chart in excel that allows the entry of start and end dates for tasks (up to 18) and a percent completion. I want to be able to autoscale the time axis based on the minimum and maximum dates of the tasks. Can the scale min and max be calculated from a cell, so that it does...
  5. V

    Counting the number of changes to a record

    Works great. Thanks Again.
  6. V

    Counting the number of changes to a record

    Great! Hey.... that's MUCH better than what I was going to do. I'll try that right now! THANKS!!!
  7. V

    Counting the number of changes to a record

    Solved Never mind, all. I bound a form "counter" field to the record's table, defaulted to 0, and set a button with an OnClick event that reads "Me.Counter = Me.Counter + 1" . That seems to have done it. I'll just have them indicate their changes manually by clicking the button.
  8. V

    Counting the number of changes to a record

    Hello all. Is it possible to count the number of times data is edited in a specific record after the original is created? I have discussed this issue with the area that has this need, and all seem accepting of the thought that they may have to make it a habit of clicking a button rather than...
  9. V

    All Menus & Toolbars missing in Access

    OK... I hope someone sees this. I have a user with the same problem as above, but there is no "Menu Bar" entry on the list. So, when I tried to go in and create one called "Menu Bar", I got a message saying it already exists. But, NO MENU BAR exists in Access, even with no db open... and...
  10. V

    Extracting values from a list based on a count

    Thanks guys, but I don't want my users to have to refresh their pivottable every time the data changes. I want this to be an automatic operation, perhaps using a maro. Thanks for the help.
  11. V

    Extracting values from a list based on a count

    I have an output area that will require some kind of action that would filter the list for the events for those that have occurred only once, and copied and pasted those events into another area. I can't use autofilter, because the users will not see this operational section of the sheet.
  12. V

    Extracting values from a list based on a count

    I have event values (let's say A-Z) in column A, and counts of times which each event has occurred in column B. I want to create a table output of all the values of A-Z that have occurred exactly once... and will have a "1" beside them in column B. I have wracked my brain on this and cannot...
  13. V

    Default value for a Combo box.

    If you're new to Access, the easiest way would be to simply source your combo box list from a table and include the value you want as your default as a record in the table. Then, go to the Default property of the combo box control and set it to that value. I know that is not the "best" way of...
  14. V

    Converting 1000s of spreadsheets to one access file

    Doc Man: WOW. Thanks. I didn't expect all that... but it certainly is appreciated. I will review those items you indicate and then follow your instructions carefully. Doc Man and Dreamweaver: Thanks for the tips on the searches, and the link. Sometimes, the biggest trouble is knowing what...
  15. V

    Converting 1000s of spreadsheets to one access file

    A group in my company has, for quite a while now, used a spreadsheet template to capture information needed for customer hard output. Someone built a page, with the less-than-a-dozen required cells in the appropriate places and a set print area, for printing the information. After they enter...
  16. V

    Please help me!!

    A search on this gives dozens of threads.
  17. V

    Please help

    What does "k ty m8" mean???
  18. V

    Selection - do I need all this code?

    First chance I've had to get back to this. Thanks for the input. I will look this over, and learn the logic. On first pass, it seems straightforward enough. Thanks!!
  19. V

    Selection - do I need all this code?

    I have a selection box with 13 choices. Each one makes visible a different legend. All legends are invisible otherwise. I am providing the code for the first 3 here, and wondering "Is there a better way of doing this?" Any help is appreciated. Tom -------- Private Sub...
  20. V

    Email each name from a query result (separately)

    Thanks... It looks like I've got some homework to do, as I have NO idea how to interpret much of this code. Thanks again. Hope it works.
Back
Top Bottom