Search results

  1. C

    Form Textbox count where date is between 2 dates

    Seems thats the solution i was after, it is indeed providing the correct count for all records. However i cannot get the Request Type to work with it, just shows all records still instead of speciying where [Request Type] = PLA(New). Am sure its just a syntax error on my part...
  2. C

    Form Textbox count where date is between 2 dates

    maybe something i should have mentioned at the start lol. im using Access 97
  3. C

    Form Textbox count where date is between 2 dates

    appreacciate you both taking a look, but still isnt right and im sure its getting annoying now for you magic lol. I want Carried in to show as 5 (take place within the week prior to today) I want Recieved to show as 2 (the remaining 2) Having used your amended lines, it shows to me as 0 for...
  4. C

    Form Textbox count where date is between 2 dates

    Its a fresh build with test values created specifically to find the root of the problem, so should be ok.
  5. C

    Form Textbox count where date is between 2 dates

    gah, still no luck!! Would it be possible to send you the test database, ive been using to work this problem, out in a PM? Maybe you may have some luck assisting when you have it as this seems to be baffling :x
  6. C

    Form Textbox count where date is between 2 dates

    i was in the bleief that you knew this hence why we trield the decimalisation of the date.
  7. C

    Form Textbox count where date is between 2 dates

    looks like it could be something with DateAdd as ive just tried using =DCount("[Request Type]","Sheet2","[Request Type] = 'PLA (New)'" & " AND [Date Received] >= #" & DateAdd("d",-7,Date()) and it changes to =DCount("[Request Type]","Sheet2","[Request Type] = 'PLA (New)'" & " AND [Date...
  8. C

    Form Textbox count where date is between 2 dates

    Seems the expression for Received is incorrect also. I created a new table of 5 dates, only 1 being in the past week, the rest being several months back, and used the expression suggested before: =DCount("[Request Type]","Sheet2","[Request Type] = 'PLA (New)'" & " AND [Date Received] >= #" &...
  9. C

    Form Textbox count where date is between 2 dates

    Result from changing to number/double: (only 5 values, deleted the oldest of the 6 to try something, bottom newest/top oldest) Date Received 39,680.00 39,681.00 39,681.00 39,682.00 39,687.00
  10. C

    Form Textbox count where date is between 2 dates

    ive just used a sample of data from my database to check this, im sure theres a problem somewhere cause the numbers are wrong. On running the expression but using it as greater than todays date (of which there should be nothing), it returns as 6. =DCount("[Request Type]","Sheet1","[Request...
  11. C

    Form Textbox count where date is between 2 dates

    Well the first line works great :D, the second seems like it should all values are being returned as 0, even one i created specifically to test so think the date maybe wrong.
  12. C

    Form Textbox count where date is between 2 dates

    I have 2 form fields, one that works out jobs that have come in upto this time last week, the second works out the jobs that have come in since then (for this week)
  13. C

    Form Textbox count where date is between 2 dates

    That worked a treat, damn extra comma!! While on it, is there a way to count between Received Date and Current Date minus a week, without creating a new column in the original database?
  14. C

    Form Textbox count where date is between 2 dates

    the Received Date on my database is in standrad Date/Time format (short length)> im digging away at the syntax but cant put anything together to give a result. Date() definately matches my database's date so thinking its because of the relation to the New Business count.
  15. C

    Form Textbox count where date is between 2 dates

    After reading that current dates in VB are Now, Date, and Time i tried as you suggested. =DCount("[Request Type]","Sheet1","[Request Type] = 'New Business'" & "' AND [Date Received] < #" & Date() & "#") But this gives a #Error? error, guessing that its returning thr wrong value, not the...
  16. C

    Form Textbox count where date is between 2 dates

    Hi, In a form i have a cell that counts the number of new business that belong to a request type, which i have done by including within the cell: =DCount("[Request Type]","Sheet1","[Request Type] = 'New Business'") However i would like it to count the number of new business that has...
  17. C

    Me.AllowEdits = False doesnt work second time

    That seems to have solved it :) Can you explain what the Me.Dirty does? cannot find any true explanations, just examples.
  18. C

    Form REFNO / Autonumber problem

    So if i was to cut this down to a simple 2 column table (name and autonumber) and create a form to add a second name, it would still generate an error? >_<
  19. C

    Form REFNO / Autonumber problem

    I appreciate the comments though i would like to know any opinions of the error generated when left as an autonumber and not using the code
  20. C

    Me.AllowEdits = False doesnt work second time

    Sorry, another question ^^; I have a form that locks all records on opening (Me.AllowEdits = False on form_load) and use Me.AllowEdits = True when an update or add record button is clicked. However, when i then use a button to complete edits reruns Me.AllowEdits = False it doesnt lock all the...
View older results
Back
Top Bottom