Search results

  1. S

    Using queries on sub forms

    Thanks Paul I have managed to sort having looked at what I was expecting it to do and you were right it would not have been able to run the query criteria if I had not already specified.
  2. S

    Using queries on sub forms

    Thank You for all your comments, I have a main form lets call it Form A that has nothing attributed to it, it is basically a dumb form for the purpose of being able to review the data presented by the 5 x sub forms, all of which belong to separate tables which are fed in by the originators by...
  3. S

    Using queries on sub forms

    I have created a form that asks me for the input, the problem I have is it requires me to populate that input 5 times, to run each query, what I am seeking help with is to enter the value once and it to run across the 5 queries, does any one know how I can achieve this?, regards
  4. S

    Using queries on sub forms

    I am seeking help with what logically I see as an easy task, I appreciate this may be my 1st mistake. I have a form that opens up 5 sub forms within and runs a separate query against each of the sub forms to populate the value required, which is the same value for each subform which is pulled...
  5. S

    Producing table type report

    I am trying to produce a table type output on my report. The fields I wish to show have been set to be able to increase\decrease in and wrap text dependant upon the data contained within which works fine. The report looks great when no data contained within. When the fields are...
  6. S

    Conditional Fortmatting - Time before Now()

    Thanks for putting me on the right track, having got so involved in trying to get this to function, forget all about conditional formatting rules, sometime you just need bringing back to earth! Have now got it to do what I need by doing the following: Value <Now() = Red Background Value Is...
  7. S

    Conditional Fortmatting - Time before Now()

    I currently use a report that is continually displayed, it refreshes its data evrey 5 mins. The purpose of the report is to display when we are required to send various updates about a product. I cuurently have 2 criteria selected within condictional formatting for that field as follws...
  8. S

    Hi All

    Hi All. Living in the UK working as a transport manager, Came across this site whilst trying to find some answers to some of my questions, have dabbled with access for about 10 years on and off, so still a novice, all self taught so may have picked up some bad habits along the way. Looking...
Back
Top Bottom