Search results

  1. Y

    input mask for general date

    Not sure if this is your question but the input mask should be: (dd/mm/yy HH:NN:SS) N=Minutes M=Month
  2. Y

    error 2024

    Try this from Microsoft.
  3. Y

    Form is invisible when losing focus

    Sorry, don't have time to look at why it does this at the moment. But try moving your Next and Previous buttons and the Company Name Text Box to the Form Header.
  4. Y

    creating custom help

    I think this is what you want, for XP?
  5. Y

    Filter a report by date range

    You could amend the previous to read: Between iif(isnull([Forms]![YourFormName]![YourDateFromField]), Min([Date]),[Forms]![YourFormName]![YourDateFromField]) And iif(isnull([Forms]![YourFormName]![YourDateToField]),max([Date]),[Forms]![YourFormName]![YourDateToField]) This should work as if...
  6. Y

    Preview, then Print

    Not sure if this will work but try Ctrl P...
  7. Y

    Combine Iif & DCount?

    The reason you're getting that error is because you're missing () around the IsNull Statement. Change it to: =IIf (IsNull([facility]), DCount("[ID]","master","IsNull[facility]"), DCount("[ID]","master","[facility] = [txtFacility]"))
  8. Y

    Filter a report by date range

    In your query on the date field put this in the criteria field: [Forms]![YourFormName]![YourDateFromField] And [Forms]![YourFormName]![YourDateToField]
  9. Y

    Auto Number

    See this Should help you out..
  10. Y

    Macro to set Field Value

    Why do you want to be able to do this? Why can't the values be set in the design of the table?
  11. Y

    How do I index tables

    I may not understand your question correctly but if you need to add an index to your table...Design your table and add an index to the field to be indexed. I am presuming this is what you mean, unless you are creating your tables at run time, in which case you may then need to add an index?
  12. Y

    Export from Crosstab query

    If you want to do this using a macro. Create a new macro. Select TransferText. Change the type to Export Delimited and leave the Specification Name blank. Fill in the remaining details as required and it will export the query...
  13. Y

    Latest Date in a Field

    Create a new query: Paste this into the SQL View: SELECT YourTableNameHere.Ref_No, Max(YourTableNameHere.Ref_Date) AS MaxOfRef_Date FROM YourTableNameHere GROUP BY YourTableNameHere.Ref_No; Hope that helps...
  14. Y

    Date & Time Fixed Width Export

    Thankyou for your reply. I was trying to avoid doing what you have suggested. I really wanted to know why Access decides to ignore what I have told it to do and do it's own thing.
  15. Y

    Date & Time Fixed Width Export

    I have a TEXT field in a table which stores todays date. 30-OCT-2002. It is 11 characters in width. Please can someone tell me why when I export it as a fixed width file does Access try to add the time, produce an Export Errors table saying the field has been truncated AND change my TEXT...
  16. Y

    if statement

    Presuming you just want to display this in the report and not store the data.... In the Check Box Recordsoure put: =IIf([due date] >date() or [Invoice Date]+30 >=Date(),True,False) Hope this helps...
  17. Y

    Need help on report for school

    You need a query based on your table. In the criteria of the [Date To Be Removed] field put >Date() This should give you all records where the [Date To Be Removed] field is greater than todays date. Then base your report on this query. Hope this helps.
  18. Y

    Count the number of Months Between two dates

    Datediff("m",FirstDate,SecondDate) The "m" means you want to know thenumber of months between the two dates. Others are: yyyy Year q Quarter m Month y Day of year d Day w Weekday ww Week h Hour n Minute s Second
  19. Y

    DoCmd .Save

    Yeah, don't ask the same question in 3 different (or more) posts, making me type a reply when it's already been answered somewhere else.
  20. Y

    Finding alpha characters in list of numbers

    IsNumeric may be able to help you. This will return a True or False value. For example: IsNumeric("12345") Would return true IsNumeric("12 345") Would return false.
Back
Top Bottom