Search results

  1. L

    Data Range on a Form~!~

    CORRECT Umm If what you meant is when the end date is empty I want for it show all records beggining with the start date until the last record it can find. and if the start date is empty I want for it to provide me with all the records up to the end date (making sure records on that date...
  2. L

    Data Range on a Form~!~

    Hey vBaInet guess what!!! My boss came back with some other issues. What you gave me up till now works perefectly but I get a syntax error when I don't input a date. We need to be able to do the following: Search on any field without dates Search on start date Search on end date Search on...
  3. L

    Data Range on a Form~!~

    YEY!!!! I had to change a few things but it worked. thanks you are amazing as usual ;)
  4. L

    Data Range on a Form~!~

    CORRECT is a search button
  5. L

    Data Range on a Form~!~

    hey did you forget about me? :-)
  6. L

    Data Range on a Form~!~

    No I don't, you lost me after you started to ask me all these questions lol I'm assuming you are reffering to this code: Where do you want me to add this?
  7. L

    Data Range on a Form~!~

    haha :D Good!~!~ So what do I do now?
  8. L

    Data Range on a Form~!~

    Yes thanks Brian, you came out of nowhere lol @vbaInet: I'm glad to get the all the help I need. I'll change whatever you want me to so it won't give me a headache later on, you ask haha. If I would have done this on my own it would had been easier because at least I'll know where to look...
  9. L

    Data Range on a Form~!~

    Sorry is early on a Friday, I'm a little bit out of it today. Two things: 1. Just noticed the person who created the database has two different dates on the report. One for when it was created and the second I'm assuming is for when the last update was made (taken from a different table)...
  10. L

    Data Range on a Form~!~

    I thought field was what you call the name on a table/query. Control is the one on the form?
  11. L

    Data Range on a Form~!~

    Sure. You want me to change it on the report?
  12. L

    Data Range on a Form~!~

    The table just mantains data related to calls we get
  13. L

    Data Range on a Form~!~

    sorry I just thought it wasn't neccesary:p the name is "CSR Call Database"
  14. L

    Data Range on a Form~!~

    I believe the form was created by a query. The values from it come from the main database table. It's the same table from the other issue you helped me on.
  15. L

    Data Range on a Form~!~

    No I renamed the report's date field to this because before it was just "Date" On the form this is called "myDate"
  16. L

    Data Range on a Form~!~

    Not really I took it out of "report" lol couldn't come up with anything else. Why?
  17. L

    Data Range on a Form~!~

    LOL how about repDATE
  18. L

    Data Range on a Form~!~

    I know I learned it from last time lol the problem is that I wasn't the one who made it so I've constantly have to change things around. I renamed it to: txtDATE, Houw you feel about that?
  19. L

    Data Range on a Form~!~

    Ok on the report is called: date
  20. L

    Data Range on a Form~!~

    DoCmd.OpenReport "SearchCallDat", acViewPreview,, "[myDate] BETWEEN #" & Me.txtBegDate & "# AND #" & Me.txtEndDate & "#" I'm assuming you meant by this the name of the data field on the form?
Back
Top Bottom