Search results

  1. C

    DateDiff problem

    Thank you so very much Pat. It works great!
  2. C

    DateDiff problem

    I have a datediff problem that I cannot figure out, could someone please help me. I have a query with Date Start and Date End. (along with their first name, last name and ss) What I need from this report is a list of what employee is still open. (not passed the Date End) I hope that I...
  3. C

    Textbox Question

    I would like to have a text box that counts how many times we have added a client in a form. ( EX: I just keyed in a textbox Bob's Place. In the next text box will be a number 3 which shows that we have this client in the database 3 times with information.) Is there a way that this can be...
  4. C

    populated number on another form

    I have a form that asks for a SS number. On the form there is a comand button to open another form with the SS data on it. But the SS number does not populated it. Is a way that the SS number can be populated? Is so can anyone please tell me how.
  5. C

    Regarding a post on Required field in table-

    Thank you so very much--what you wrote works great--Thank again
  6. C

    Regarding a post on Required field in table-

    I found a post on required fields in a table that was posted and answered on 4-4-02. My problem is that I tried it and it does not keep the form open. If IsNull(Me![Text20])Then MsgBox("You must fill out SS Number") Cancel=True Else DoCmd.Close I recieve an error on the Cancel part. If I take...
  7. C

    Date question

    It works great Thank you so very much. One other question on it tho, On the pop up it is asking for the billdate, is there a way it could ask for todays date and it would pull up everything that is 30 days past due? I have tried several different ways and cannot figure it out. Thanks again for...
  8. C

    Date question

    I asked a question earlier but now I have another. I have a query where where I need to know if a client is 30-60-90 days past due. For example, I entered a bill date of 2-4-02, I would like a column for 30 days past due (3-4-02) date. I know it has something to due with the date, any help...
  9. C

    DateDiff

    Thank you so very much for your help.
  10. C

    DateDiff

    I have brain fog this morning, I have this query where I need to know if a Billed Date is 30 days old. I know that I have to do datediff but I have running to problems. Can someone please help me. Thank you so very much.
Back
Top Bottom