Search results

  1. Taff

    Newbie Query!

    Hi Tim, Not sure if this is the sort of thing you are looking for. http://www.acc-technology.com/iowiz.htm Anthony.
  2. Taff

    Another Dlookup Question

    Message now appearing:- I now get the message:- Syntax error (missing operator) in query expression '[creationdate] = 27/10/2004 AND [DatasetName] = 'Learner Dataset' AND [CreationTime] = '14:31:41'.
  3. Taff

    Another Dlookup Question

    Syntax Error (Missing Operator) Hi Electric Ant, Thanks for the relply, think i'm getting closer. I now get the message:- Syntax error (missing operator) in query expression '[creationdate] = 27/10/2004 AND [DatasetName] = Learner Dataset AND [CreationTime] = '14:31:41'. Any Ideas, Ant.
  4. Taff

    Another Dlookup Question

    Hi Adaytay, I have changed the mistakes but unfortunately still nothing happens. Thanks for the reply. Ant.
  5. Taff

    Another Dlookup Question

    Hi all, Have tried searching the forums but to no avail. I have a table the records imports to the database. It records the Name, Time Created, Date Created, Time Imported and Date Imported. When I import the a file to the database the Name, Time Created and Date Created are stored in...
  6. Taff

    IIF expression problem - Pls help

    Create a query with all the fields you require and then try pasting the following as the field in your query:- Expr1: =IIf(([dbo_vwSpotPositionMoveByBranchDealerCurrencyPortfo lio]![Portfolio])="MTDPAL"," ",[dbo_vwSpotPositionMoveByBranchDealerCurrencyPortfo lio]![Portfolio]) Then just...
  7. Taff

    IIF expression problem - Pls help

    Not really, Are you using the IIF statement in a query? Ant.
  8. Taff

    IIF expression problem - Pls help

    Hi gumbira, Should you have a space in the word Portfo lio? Ant.
  9. Taff

    Between Date and Time Query

    I have a database which records vehicles passing through a weighbridge and records the date and time of weighing. What I am trying to do is create a query which shows all vehicles that have been weighed between two dates and times. What I have so far is select blah from blah WHERE...
  10. Taff

    Grouping and Max Query

    Hi Brian, Sorry I haven't replied - been running around like a headless chicken for the past week. It works fine - Just haven't had the time to put in place yet though. Thanks again for your time and effort, much appreciated. Regards, Taff :)
  11. Taff

    Grouping and Max Query

    OOPS!!! Try again. Ant.
  12. Taff

    Grouping and Max Query

    Hi Brian, Thanks for the again for the reply. I tried what you said but I am not sure if i have done it correctly. I have attached what I have done. Regards, Anthony.
  13. Taff

    Grouping and Max Query

    Hi Brian, Thanks for the reply, am a bit unsure how to do that. Could you please give me a bit more info. Many thanks, Ant.
  14. Taff

    Grouping and Max Query

    Hi all, Really unsure how to word this so I have attached a sample of what I am trying to do. I have three tables:- tblStudents - Learn_ID Provi_ID Surname Forename tblSchemes - Learn_ID Provi_ID Lprog_ID Type_LPG ElwaOffi tblQuals - Learn_ID Provi_ID Lprog_ID Lacti_ID StartDte EEnddte...
  15. Taff

    On Timer Event

    One more question, How do you delay events from happening and cause them to be 2 or maybe three seconds apart? Ant.
  16. Taff

    On Timer Event

    Thanks again Mile-O-Phile, Works great. Ant.
  17. Taff

    On Timer Event

    Hi all, I have a form with Five labels on lbl1 to lbl5. What I would like to happen is have all five labels appear one at a time with a one second gap in between. Have tried on the on timer event but I seem to have all labels appear at once. Thanks Ant.
  18. Taff

    Disable Menu Bar

    Hi all, I have a report, and when the report opens I would like to disable the menu's and only allow the user to close the report, prefferable without closing the application. Is this possible? Thanks Ant.
  19. Taff

    Serious Trouble. Please help...

    What was it?
  20. Taff

    Where is todays data?

    Can you post a sample of your application. Ant.
Back
Top Bottom