Search results for query: *

All, I hope somoneone can help with this one. I have frm_test and it has a copy record command button on it. frm_test_copy is the form that is used to capture the copied record from frm_test There is a drop-down field on frm_test called status. The values in the status field are Working...

All, I have 3 forms. One is a search form and the other is a results form, and then there is a results form from a button that copies a record. I have a command button on the results form to copy that record. Once that record is copied it opens up the form with the copied...

All, Is the following possible? I think I want to set up a rule for this if that is the right way to go: I get an email from joeblow@nothing.com I want the rule to automatically send a template email back to joeblow@nothing.com. That template email would be something like a confirmation...

All I have 2 fields on a report that I want to sort by. 1 is a date field and the other is a text field. The name of the date field is: iecdNumber and the name of the text field is: iecd_number. The iecd_number field has to be a text field because users are allowed to enter numbers and...

All, I have the following code in this section of a report: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Here is the code: If Me![newly_opened] = "Lime" Then Me![iecdNumber].BackColor = vbGreen Else Me![iecdNumber].BackColor = vbWhite End If If Me![newly_opened]...

All, I have a radio button, I would like to click and when clicked, I would like for the background color of the field: text1, to change to yellow. This is on a form that is in Continuous view. I have the following code associated with the OnClick of the radio button...

I have a form that is associated with a table of course. I have a radio button called: chg_hw and a date field called: expIECD I have code that generates a date in the expIECD field. I have another field called: aprv_date. I have a report called: rpt_expIECD_HW I need to generate code...

Does anyone know if command buttons can be added to reports? I tried to make a form to look like a report, but I need Continuous Form and it doesn't work for me, because I have to subforms on the form. It gives the error can't have a continous form that contains subforms. Any help would be...

All, I have a report set in a column format. I have about 10 fields horizontally placed in the detail section. 2 of those fields or from a subreport. One of the subreports is a can grow field. I would like to somehow have borders around everthing so it looks something like cells in...

All, I have a Yes/No field called answerYes, which is in a table called tbl_Data. I have a switchboard with a command button that I would like to reference the tbl_Data and if the value is True for answerYes in all records, I would like to make the value False in every record. Is there...

All, I have the following code below that is behind a command button on a form. Once the email comes up and they decide not to send the email and close the outlook message, it will give an error message. I would like to suppress that error message by using the following...

All, I have a dueDate field on a form and I have a date in that field of 3/15/04. I would like for the database to automatically send an email to recipients 10 days before the dueDate is met. I have the code for sending the email, but I don't know how to get the dueDate field to...

All, How would I change the color of the body (body text if you want it) of the syntax below to a red font? DoCmd.SendObject acSendNoObject, "test", , Me.email, , , "your subject here", "body text if you want it" Can someone please help me? Jerome Benton JERPAT Web Designs www.jerpat.org...

Is there anyway to change the text color of a field on a form on the After Update event? I use something like: Me.textbox1.forecolor = 255673 on the After Update event. The color changes to red while the form is up, but if I close down and open it up again, it goes back to the original color...

All, I have figured out a temporary solution for copying a main form and sub form record. Note: There are two forms involved here and they should be identical, but just named differently. Main Form's name is: frm_main, and the form that captures the results is called: frm_main_copy. You...

All, I got the following code working from a command button on a search form. The search form has 5 fields to search on. My only problem now is that I can only enter one search criteria at a time to get the correct results. It doesn't work when I put more than one search criteria in. For...

All, I am getting the error message below: Syntax error (missing operator) in query expression 'tbl_sub1.MainID = tbl_sub2.MainID FROM tbl_test INNER JOIN tbl_sub1 ON tbl_test.MainID = tbl_sub1.MainID'. Here is the code I am using: Private Sub cmdSearch_Click() 'Set the Dimensions of the...

I hope someone can help me with this. I am getting the following error for the code further down: Syntax error (missing operator) in query expression 'tbl_sub1.MainID = tbl_sub2.MainID FROM tbl_test INNER JOIN tbl_sub1 ON tbl_test.MainID = tbl_sub1.MainID'. Here is the code I am using...

All, I am getting the following error with the code below: Run-time error '3129'; Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE', The code I am using that is getting this error is below: Private Sub cmdSearch_Click() 'Set the Dimensions of the...

I can copy data from a subform with the following: Private Sub Command2_Click() frm_subform1.SetFocus DoCmd.RunCommand acCmdSelectAllRecords DoCmd.RunCommand acCmdCopy End Sub I want to copy 2 subforms at the same time, and I don't know how. I have tried the following and it doesn't work...