Recent content by rhonda11

I have a form with a subform. The form has project ID and other fields, the subform is for updating the progression of the project. So, if I need to update the project, I would go into the form and select new in the subform and it would give me a blank subform. However, there's a delivery date...

Thank, you save me a lot of time.

Please help me to insert multiple record in a single statement and what the max record I can insert in one statement. The below is what I been doing for inserting a as a signal record. Insert into emp123 (first, last, age)values ('Charles', 'Smith', 26); Thanks in advance

Thanks guys, it works!! My combo box record source or row source already have a sql statement and all I did was add ...WHERE [projectcompleted]=False. I requery the combo box afterupdate. Thank you all, you been very helpful, I appreciate you help.

I have a form for project look-up base on a combo box that if you select the project id, another form display selected project. Within this form, user can update the project at the subform, in this there a "completed" check boxe, which that this project is completed. My question is, if...

Thank you for your help but it's still not working, i'm getting "#name?" error. What is this mean?

I have a form with a subform that gets update pretty often. Within this subform there's a delivery date field that I would like to remains the same everytime the user click to get a new form to update. What I did was put the following code on the Default value from the event. However, this code...

I'm getting a "#Name?" error when executed. What I have is Dlast("[DeliveryDate]", "ProjectUpdate", "[ProjectNo]=" & me.parent!projectNo). After I saved it, went back and it was converted to the following...

When I updat a record from the subform by project ID. I would it to clone the last record with of the currect Project ID (not the last record in general of the table but depending on the last record for that project ID). I have tried to do the following, however it clone the last record of the...

I have a database that require a password. The user will not have the ability to go into the design mode of the database (database window is inactive for them). One user accidentally press the F11 key and the database window appeared. As an administrator, I press the SHIFT Key and Enter key in...

Does anyone know what is this error message "Internal Server Error 00-0003"? I get this message when I attempt to login a bank application via internet using Internet Explorer 5.5 as our browser. I think maybe this is setting problem but I have mirror the other computer in my office...

Thanks for your respond but I understand the parameter. However, what if you what to customized your own search form. Let say, I pull the form with the customer record but I would like to create another text field and a search button within the same form incase I what to retrieve another...

Just an general question, I also wanted to create a search form. Whereas you have a text field and a search button that can search for keywords or partial word base on what you entered in the text field. Then, the result would either found an exact match and bring up that record or could be...

I'm sorry. But, I'm new at this. How do I do that if the DeliveryDate from the ProjectUpdate table depends on the ProjectNo from the Project table. This is what got so far: =DLast("DeliveryDate","ProjectUpdat") The above is not giving me the updated deliverdate depending on...

Thanks for your help,it works! However, I want it to duplicate the deliverydate field depending on the Project No being selected. For instance, I have a ProjectNo that have many updates (projectUpdate). When a ProjectNo is retreive to update, I would like it to copy the last update delivery date...