Search results

  1. J

    date diff plus check box

    Hi i am using datediff in conditional formatting Access 2010 to highlite orders as they become due All works ok but now i need to add a check box called ORDERED ,and once this box is ticked that order ceases to be highlited . I need help with this code. please keep it easy to understand ,this...
  2. J

    conditional formatting with check box

    I am using conditional formatting using datediff I need to add a check box and only have the conditional formatting take place on the deadlines that are ticked in the check box
  3. J

    Printing form as a report

    Thanks for your help
  4. J

    Printing form as a report

    Hi Thanks Im very new to this . How do i turn this single form which is a record from many into a report .I see you are using code .but i dont understand where and when to place this
  5. J

    Printing form as a report

    Hi I have form which contains infomation from diffrent tables I need to print this form and give it to my surveyor so that he can go out and visit people . My question is ,Should i print the form Or turn the form into a report . I know how to print the form but dont know how to turn that form...
  6. J

    Conditional formatting

    Hi big pat .That terrific .Thanks very much
  7. J

    Conditional formatting

    Hi . This is my first attempt at conditional formatting . I have a report With a date for work to be undertaken . AS time gets near i would like to highlight this date with 2 weeks to go and then highlight again diffrent colour 1 wek to go Is this possible
  8. J

    Combo box will not let me update column widths

    Hi have cascading combo box the last box is bound to my order details subform . Everything works ok but i can not alter the widths of the 5 columns displayed . The column widths property is blank but the property widths lower down in the sheet is set at 17 cm . However When i try to alter these...
  9. J

    Navigation form will not retun to nav form

    Answered My own question .I was starting my Macrow with close window . If i leave that out I return to my navigation form m
  10. J

    Navigation form will not retun to nav form

    Hi have my own navigation form Which is simply a form with buttons that with the use of Macrows allows me to open various forms . I have 6 queries i can run all using the same criteria so i have 6 buttons to go into these queries . If i use a button to open another form and then close that form...
  11. J

    changing criteria automatically

    In a quirie is it posible to change the criteria in one field by the use of a combo box or similer
  12. J

    form with check boxes cant querie

    Not shure how to do that. Ill try explain better ,I have a form for surveys .When its waiting for the surveyer .I tick the check box .I can now do a querie for al surveys waiting to be surveyed . When the surveyer has visited i have another check box to tick,so that i can run a querie to sewhat...
  13. J

    form with check boxes cant querie

    Hi i think i may need to rethink what i am doing all ideas welcome. I have a form with checkbox options for .Waiting visit .visited complete closed. It works ok untill i try to run a querie, then i may have all boxes ticked and it all gets mesed up . Is there a way to say if this box ticked then...
  14. J

    combo will not show clear

    I have a simple form not related to other forms It sits in my new orders form , It has a combo box which can display names from its own table and place in a field on its own form .However when i use a new record from my new orders form the combo always displays the last name used .I would like...
  15. J

    Default entry reqd

    Hi If i say yes to the default entry reqd . And when not entering in a field I get the massage entry reqd ,but when clicking ok it repeats the message box and does not let me make an entry ,and eventually says access can not save this and needs to close . Is there a better wy of doing this ,So...
  16. J

    fk id not apearing

    Hi sorted my problem . It may be of interest to other newbees In my orders form I use a Combo box to select the customer from customer details record. I Was Storing the surname in the surname field of my form .I did this becouse i wanted to see the surnames in my orders form . I now realise that...
  17. J

    fk id not apearing

    H pat Before i start doing what you suggest .can you answer this question If I open the customers table and click on he +far left ide of record I would expect to see the related child records but instead it shows every customer record
  18. J

    fk id not apearing

    Hi Pat Understand do i need to ask the question agaain or wil i get replies as it is
  19. J

    fk id not apearing

    Pk Will not auto populate FK Hi still having problems with this one . To simplify things ,I have a Customers table and a orders table .there are no sub forms .I am entering data via forms .The tables are related to each other one to many. The PK from the customers table has a fk in the orders...
  20. J

    fk id not apearing

    Hi alan realy apreciate your help It seems I go 2 steps forward i step backwards But with perseverience and help from people like your self i will get there Many thanks john
Back
Top Bottom