Search results

Paul, thanks a million for your help and code. It worked a treat. Everyone else thanks for your comments. Cheers nia

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

THat would be great if you let me know how you did it....was just going to leave it and let the user enter the number twice. Any help appreciated!! THanks

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

Cheers have it more or less sorted. Thanks for the help Nia :o

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

Thanks a million for yer help guys, sorry for the delay in relaying my thanks... Again much appreciated. Nia

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

Thanks for the help guys/gals Much appreciated. nia

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

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

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 (",)

Well in my main form, i have three combo boxes. One for Naming of the Area, the next is for Test Id then lastly for the Year. These are all stored in the Table Retest. Then in the subform underneath i have a textbox for the Test Date, a combo box for Reason for Retest, another combo box for...

Hi, thanks for that, i have linked both forms now but now my problem is that once i write in information into the subform of the second record, it overwrites the information in the subform of the first record, so now the information in the first and second records of the subform are the...

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

Hi me again Did as i was told, created a table named Analyst, with one field called AnalystName. Then in the properties of my drop-down menu in my form i changed it to table/query and in the control source i pointed to my new table, but this didnt work, so then in the control source i typed '...

Excellent, cheers lads!! Nia (",)

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

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 (",)

Hi Mile-O-Phile Thanks for the help, much appreciated. Did as your link suggested, but still duplicates are appearing on my drop-down menu!!! Do you have any other suggestions?? Cheers Nia (",)