Recent content by klee

I still couldn't fix the printing problem that I had, but it is better than before. I have a subform in a main form, whenever I click on the print, it will print all the records that I have in that subform. Is the subform that generate the problem? Is there any way that I can code it? Or...

thanks jwindon, I'm sorry about that, I thought it is related to VB, so I went to that area. Thanks anyway I will try that out.

I have problems with the dates in my form. I have a RequestDate field and DateNeeded field. Currently, my requestdate can key in a date that is > than the dateneeded. I think I will be able to control the field through the VB code. I wonder anyone would be able to help me up with this, show...

I have tried to use the validation rule, but it does not work at al. I have a requestDate, and a DateNEeded. I did not changed anything in my requestdate, but in my validation rule for the DateNeeded, I typed in "DateNeeded">"requestDate". It does not work. Is there any recommendation Thank you

Thanks mrssevans, So do I just type the ending date must be greater than beginning date in the Validation Rule Column?

Thanks jwindon, I did that, but the problem is if I changed the Required field to Yes, it will create a problem for the form. I have form that linked two tables together, but does not required all the attributes to be part of the form, if I changed that, it won't allow me to save my data, a box...

HI, I came across a problem about date in my form. I have a beginning date and an ending date. Logically, the beginnig date should go before the ending date, but now, I can type in any date I one, for example, my beginning date can be 11/11/2002 and ending date: 12/11/2001. Besides, is...

I need to match the subform data to the mainform data. for example, I have a programmer id 11111. I need the subform to display all the information that relate to this id number. I need a solution urgently. Thank you

I wonder is there any one that know what's going on when a box popped up and say you can't add or change any record because a related record is required in table X ANy comment? Thanks

I wonder is there any one can show me how to control the data in the form. I want all the field to be filled before user can submit the form. Thanks

Thanks jwindon Actually I am running the printing through the Print Current Form command that I have created through the wizard so do you think the best way for me to solve this problem is to choose the needed form and then design a report that looks exactly the same like the form?

i have a report already, but user say that they need to print a copy of the form that they fill in, so I thought that they can print it directly from the form after filling all those particulars

I have a problem printing my form, assume I am on the 4 form right now and I want to print this form, the database does not allow me to do that,it just print out all the forms that i have in my database. I have try to put a page break after the form, it still have the same problem Is there...

thank you very much

Thanks for the solution,but I guess I did not state the question clearly. I'm creating a database that allows the management to assign tasks to the programmers and users. This is the tables that I have Request Assignment ~Request# (Primary) ~Request(com.key) ~UserID (Foreign)...