Search results

  1. alastair69

    Help with a form and cross tab query

    if you can post an example i will have a look for you.
  2. alastair69

    And all dates before....

    You could try >#01/10/2004# in your query this will find greater then this date or <#01/10/2004# less then this date. Just a thought
  3. alastair69

    Search for and remove an asterisk?

    Sorry for myt stupidity but what does chr(42) mean
  4. alastair69

    MS Office 2007 Beta2

    Have a look at this site http://www.phazeddl.com/search.php?q=Office+2007
  5. alastair69

    Need quick help on vba date controls..

    Have you tried http://www.access-programmers.co.uk/forums/showthread.php?t=103747
  6. alastair69

    Word Mail Merge Bookmark Problem IF Problem

    Do you have a copy of Service_Plan_Schedule.dot file so i can have a look for you.
  7. alastair69

    2 Questions about search boxes on a form

    can you post your db and i will have a look for you!
  8. alastair69

    Compact and Repair

    yes you would need to setup a scheduled task on windows
  9. alastair69

    Access having problems opening Excel remotely

    can you attach a copy of both your Database and the AER Trading.xls and i will have a look for you.
  10. alastair69

    Access having problems opening Excel remotely

    ok so you have checked your spelling and is the same error apearing?
  11. alastair69

    Removing selected text from a string

    Dear All, Thank you for taking the time to look at this Question. I am using a form in which i only need the last sections. example:- G/001 - Ceiling - Tiles - Perforated. this is what i get at the second, but i would like to drop the "G/001 - " and just have "Ceiling - Tiles - Perforated."...
  12. alastair69

    Access having problems opening Excel remotely

    When you say "Excel remotely" do you mean it is on your PC or somebody else PC?
  13. alastair69

    Access having problems opening Excel remotely

    Have you checked your file location is spelt as set out above.
  14. alastair69

    Compact and Repair

    What Compacting does and how it works Dear Lyndseyd, I have read your question carefully and i understand your problem. The compact option will remove all the old forms and data from your database that you have deleted while working on the DB, also it removes any problems with data this can...
  15. alastair69

    Placing Data in another Table

    Thanks Kempes, I will give it ago. Alastair
  16. alastair69

    Placing Data in another Table

    Hello, It has been some time since i have been on the forum. My issue is this, i have a form called "JT History (New)" is need to copy some of the information into another table on close. I have tried to use the following:- me.Clientlookup = [tables].[tbl Scheduler]![CompanyName] This...
  17. alastair69

    world cup football

    Hay, Have you got your shirt yet.
  18. alastair69

    Bound/Unbound forms

    You could try to use a query in the criteria field add the name of your comb box. if you attach your database i will have a look at the options open to you! Alastair
  19. alastair69

    Count different values in text box

    have you tried having the "B" inside of the (): so could look like =Count([strFKBedContractTypeID]="B")
  20. alastair69

    Form for Editing Only

    I take it that there is no data in the form/tables?
Back
Top Bottom