Search results

  1. N

    Query calculating problem

    Hi there, I have a main form called 'Project', within the form 'Project' I have inserted a continous subform called 'SubProject'. Within 'Project' is a numeric field called 'Headcount' and within the subform 'Subproject' is also a numeric field called 'SubProjectHeadcount'. In my query i want to...
  2. N

    Re-generate number from Main form onto subform...

    Hi..me again.. Another query...I have a text box called 'ProjectNo.' on my main form, and once I hit my button to create my subform I want what i entered into 'ProjectNo' on my main form to appear on the subform....automatically, instead of having the user insert the projectNo twice...possible...
  3. N

    How can I "connect" my forms

    Hiya, I wonder if anyone could help me with a problem that i have... I have created a form called 'Project', and within this form I have a command button that opens another form called 'SubProject'..what do i have to do so that if i open up my SubProject then this particular record is only...
  4. N

    Date Query

    Hello all, Is it possible to create a field that will calculate the difference in days between two fields that are in Date format....that are all in the same query...?? Thanks Nia
  5. N

    Drop down menus

    Hiya, I want to have two drop down menus, D1 and D2. Is it possible when you select a value in D1 a unique list appears in D2, having different list in D2 for each value in D1... Is this possible? Many thanks Nia
  6. N

    Form with unique numbering system

    Hiya, My boss has asked me to create a database whereby a person can input the type of project being undertaken and then the database gives a unique number for the documentation for the project. There will be at least 2 drop down menus as well as a text boxes. There will be various types of...
  7. N

    Criteria for Yes/No data type

    Hi all, Just wondering if it's possible to create a criteria expression in my query to prompt the user whether they want the query to show up the true values or the false values of my field that uses checkboxes... Thanks Nia (",)
  8. N

    Subform

    Hello, I have a form within my database, and within this form is a subform. But every time i move on to the next record in the form the content of the subform does not change, ie the information in the subform for the first record stays the same for the next record. How can change so that when i...
  9. N

    Drop-down menu

    hiya... If i have a drop-down menu on my form, where by in the properties i have it as a value list, then in the control source i list all the possibilities in ".." separated by ;, how can i change it so it will accept any new information entered as well as having the information from the...
  10. N

    checkboxes in report

    Hiya folks.. Just wondering is there any way i can display the result of my checkbox from my form as a simple YES or NO in my report, instead of the standard checked or blank box. Thanks Nia (",)
  11. N

    Trying to limit drop-down list

    Hiya, I have a drop down menu in my form for names, and although you can pick from it...everytime I type in a name instead of just picking it iti goes into the drop down twice, so now i have 6 or 7 duplicates of the same name!!! I could just put into a fixed list but sometimes a new name the...
Back
Top Bottom