Search results

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...

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

Thanks for your help

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

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...

Hi big pat .That terrific .Thanks very much

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

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...

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

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...

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

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...

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...

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...

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...

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...

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

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

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...

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