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!

Recent content by mikeba1

  1. mikeba1

    calendar control and after update event

    The code was to check the date with previous data. The problem with the date calendar control is that if you select a date it is moved into the form but you still have to hit return. I will put code elsewhere. Thanks
  2. mikeba1

    calendar control and after update event

    Just had a thought. When you enter the date of course you see it and hit enter. With the calendar control you see it on the form and its only when you go to another control is then updated. It might have to be the next control that executes the code.
  3. mikeba1

    calendar control and after update event

    HI guys ver 2010 I have a form with a date field with the calendar control. The after update event simply uses msg to show the value in the date field. If I select a date from the calendar the msg shows nothing , although the field on the form is correct If I enter the date everything works...
  4. mikeba1

    days in the week

    Thanks chaps. Sorted by loops and datediff functions
  5. mikeba1

    days in the week

    Does anyone have a routine to calculate the number of Thursdays(or any other day) between two dates. thanks
  6. mikeba1

    update query

    The form I was using was copied from another db and the field names were slightly different than used in the sql, only slightly different but enough. My problem was assuming something without proper investigation. You guys sending your sql examples made me look further. Thanks
  7. mikeba1

    update query

    Thanks guys Problem resolved My finger problem and tired grey cells
  8. mikeba1

    update query

    update problem access 10 running as 2007 mdb attached sql view of update query UPDATE DiveRecords SET DiveRecords.Patient1Name = [Forms]![updatechangesdives]![nametouse] WHERE (((DiveRecords.Patient1Name)=[Forms]![updatechangesdives]![orgname])); I am trying to change the field I am...
  9. mikeba1

    simple query

    Thanks chaps Focus was still on date field Solved
  10. mikeba1

    simple query

    Thanks for the reply There is no further query, I just wanted to select data from a form but the date field (epr2) doesn't show although the other two do. It seems to be a problem with the date field. Eventually I wanted to use this data in an append query, I just used the select to test my logic.
  11. mikeba1

    simple query

    I am trying to create a simple select query with data on a form, all ok apart from a date field which is on the form but does not display on the query ??? beaten !!! SELECT [Forms]![frmCreateDayApptsSTARTA]![Therapist] AS Expr1, [Forms]![frmCreateDayApptsSTARTA]![dayinweek] AS Expr3...
  12. mikeba1

    drop down list

    Thanks chaps.
  13. mikeba1

    drop down list

    Hi people I am new to php, attempting to take an access db to the web ??? I seem to be unable to create a drop down list that has two columns 'membershipid,surname'. The first column is what I need to pass to the next procedure. I apologise if I am being stupid but I don't seem to find any...
    • mikeba1
    • Thread
    • Replies: 4
    • Forum: PHP
  14. mikeba1

    blanks in field names

    thanks for reply option 1 works fine
  15. mikeba1

    blanks in field names

    possibly moving access to sql and php first attempt to list table with blanks in field names ok on select but what about the echo !! <html> <head><title>MySQL Table List</title></head><body> <?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "members"; // Create...
    • mikeba1
    • Thread
    • Replies: 2
    • Forum: PHP
See more

Part and Inventory Search

Back
Top