Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.11 seconds.

  1. Thread: New Record

    by patt
    Replies
    5
    Views
    141

    You can the use the ESC key to fully erase the...

    You can the use the ESC key to fully erase the new record from the subform.
    If that doesn't work then send a zipped copy of the database.
  2. Thread: New Record

    by patt
    Replies
    5
    Views
    141

    Have you tried putting a test in the subform's...

    Have you tried putting a test in the subform's BeforeUpdate event to cancel the write to the database.
  3. Check out what Google has to offer, I came across...

    Check out what Google has to offer, I came across this link:
    http://stackoverflow.com/questions/512143/error-could-not-find-installable-isam
  4. Replies
    5
    Views
    189

    Required help on the below: 1. I am planning to...

    Required help on the below:
    1. I am planning to create a 2 backend tables for Dated & Undated checks, but not sure whether the limitation of Access applies for Table size of 2GB is for back end...
  5. Replies
    3
    Views
    190

    Thanks for the invite, but I have moved to the...

    Thanks for the invite, but I have moved to the Philippines
  6. Replies
    5
    Views
    189

    1. We will import both dated and undated checks...

    1. We will import both dated and undated checks into Database once but can it get moved to 2 different tables automatically?
    You could import them into a table, then use 2 append queries to populate...
  7. Replies
    4
    Views
    327

    In the lastname control, the change event gets...

    In the lastname control, the change event gets called for each character keyed in, the BeforeUpdate event occurs after all changes have been made and the afterUpdate event is called after moving to...
  8. Replies
    4
    Views
    327

    The OnCurrent event occurs when moving from...

    The OnCurrent event occurs when moving from record to record
  9. Replies
    3
    Views
    190

    Firstly you need to work out what input and...

    Firstly you need to work out what input and output functions there are.

    Then you need to determine what tables you need for those functions to work, and the relationships between tables.
    Maybe...
  10. Replies
    38
    Views
    1,006

    -1 in expressions, I didn't put that in there, I...

    -1 in expressions, I didn't put that in there, I presume it means TRUE.
    The format in the date check says format the date as US date style eg mm/dd/yyyy, else it will not compute properly.
    ...
  11. Replies
    3
    Views
    89

    Good you found it. We all do that from time to...

    Good you found it.
    We all do that from time to time.
  12. Replies
    38
    Views
    1,006

    Is your database located in a trusted location?...

    Is your database located in a trusted location? If not any VBA code will not run. That is presuming you have Access 2007 or later.
    How do you start the reports, by the buttons on the form, or by...
  13. Replies
    3
    Views
    89

    Has that particular classmate died? It's a bit...

    Has that particular classmate died?
    It's a bit hard without seeing the database. Can you post a zipped version for us to look at.
  14. Replies
    38
    Views
    1,006

    Mine shows 5 records for Broome, I will send the...

    Mine shows 5 records for Broome, I will send the database again.
  15. You will have to requery the combo box....

    You will have to requery the combo box.
    ComboBoxName.Requery
  16. By the way Kelly, would you post here what you...

    By the way Kelly, would you post here what you used for a WHERE clause, and let us see what you tried.
  17. Replies
    38
    Views
    1,006

    I have been testing with a date range of 1/1/14...

    I have been testing with a date range of 1/1/14 to 1/1/14, and the totals seem ok to me. Which totals in particular are wrong?
  18. RG's zWhere may need to be changed, especially if...

    RG's zWhere may need to be changed, especially if SchoolName is not a number field, and depending on where you live you may have format the dates as well, viz:
    zWhere = "[SchoolName] = " & Chr(34) &...
  19. Replies
    38
    Views
    1,006

    I have made a few changes. Here is the latest DB.

    I have made a few changes. Here is the latest DB.
  20. Replies
    38
    Views
    1,006

    The Tally report displays incorrect counts for...

    The Tally report displays incorrect counts for the counties but your input for the phone calls breakdown divided into 4 segments works fine.
    PT: Is that report called Detail Report? if so, which...
  21. Replies
    38
    Views
    1,006

    Have you changed anything in the database I sent,...

    Have you changed anything in the database I sent, if so, would you send your database again
  22. Replies
    38
    Views
    1,006

    you wrote: Figured out your frm Detail and...

    you wrote:
    Figured out your frm Detail and noticed that it correctly counts the number of calls within each time segment . But all the other calls in the other sections it displays a total of all...
  23. Replies
    38
    Views
    1,006

    All your Dcount counts will also require the...

    All your Dcount counts will also require the start and end date check.

    How you do this depends on you, if you use the query name it doesn't work due to a #Error problem, for these sorts of reports...
  24. Replies
    38
    Views
    1,006

    Any chance of sending the relevant objects with...

    Any chance of sending the relevant objects with test data in a zipped database.
  25. Replies
    38
    Views
    1,006

    Glad you found it.

    Glad you found it.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4