Search results

  1. N

    Parameter Query problem

    No its not simple to do, not crazy difficult neither if you know how. What you want is a search form and/or a cascading combobox... have a look around and see how far you get with that come back with any and all questions you have.
  2. N

    Single Index or Multiple Column Index

    no difference that you will notice. thus go for the best solution and split the columns.
  3. N

    How Best to Structure Imports and Queries

    docmd.transfertext is your friend both for import and export.
  4. N

    Automatically update date field everyday

    Thanks for resurecting a thread over 4 years old, anyways as the thread suggests, current date should not be stored at all. To compute the days you can run a simple query and calculate: DaysSinceRegistration: Date() - RegDate Or put a simular calculation in a form.
  5. N

    Passing Invoice number

    There is never a need to store information twice, unless you go into complex things like performance and/or datawarehouse issues.
  6. N

    Multiple Date Fields based on Criteria on the same Report Row

    something like: IIF(equipment1 <Date()+60, equipment1, null) as Forktruk Or if you are using the designer: Forktruk: IIF(equipment1 <Date()+60, equipment1, null) ??
  7. N

    Autofill Form from Same Table

    Research a subject called "Normalization" a database works a lot different from a spreadsheet. Try to forget anything you think you know about excel and stop applying it to a database. Come back with any questions.
  8. N

    Solved Open folder form

    Spaces in filenames.... is it compiling the path properly? Otherwize try adding "" around the entire path.
  9. N

    Solved Combobox Options

    Private Sub Cbodeladdress_AfterUpdate() On Error GoTo Cbodeladdress_AfterUpdate_Error If me.Cbodeladdress = "Yard" Then Me.Txtaddress = Me.Cbodeladdress.Column(1) Me.Txttown = Me.Cbodeladdress.Column(2) Me.Txtcounty = Me.Cbodeladdress.Column(3)...
  10. N

    Multiple Date Fields based on Criteria on the same Report Row

    what is it based on ?
  11. N

    Multiple Date Fields based on Criteria on the same Report Row

    Please do consider these words as well as those from @Pat Hartman ...
  12. N

    Multiple Date Fields based on Criteria on the same Report Row

    My bad, to much used to using Oracle or SQL Server, IIF(equipment1 <Date()+60, equipment1, null) as Equipment1 Or if you are using the designer: Equipment1: IIF(equipment1 <Date()+60, equipment1, null)
  13. N

    Passing Invoice number

    There is a difference between what you want and what you should do, going against my advice and that of @Pat Hartman, this will come back to bite your rear end. You want to solve this in a query not by storing it in your table.
  14. N

    Export query results by segments

    what version of office are you using? Docmd.transerspreadsheet or Docmd.transfertext (into a .csv file) will export your table just fine I think
  15. N

    Export query results by segments

    How do you mean? Access doesnt have any limits, excel now a days is 1 mio records, doubt you will hit that. So what is your exact requirement?
  16. N

    Passing Invoice number

    Plus you shouldnt be using Invoice number as a value in both tables, invoice number has a meaning in the day to day business . As such it has no business meaning anything in your database other than beeing an attribute.
  17. N

    Passing Invoice number

    the question that needs asking is WHY? You can link the subform and main form to do this for you. Or if need be apply the invoice number into the sql of the form to achieve the same. Storing search information is rarely a good thing :(
  18. N

    Help with DateAdd("d",-1,Date() feature or similar

    Dmax ... really? Noooo !
  19. N

    Multiple Date Fields based on Criteria on the same Report Row

    Might be that the semicolumn needs replacing by a comma
  20. N

    Import txt file

    You will have to create your own import for this. Or atleast manipulate your file from code... Check out FileSystemObject (FSO) here: https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/filesystemobject-object See if you can figure it from there, if not come back...
Back
Top Bottom