Search results

I am lost. You want to add records to t_CombinedVelocityTotals using t_ItemSearch. Is t_ItemSearch populated by another query etc or is it the transaction table? Now in t_ItemSearch you have a field Status Date as text field this should be a date/time field. Now using Monday as an example how...

I would have another table to record the attendance for the current month. This would have emp_id the PK of table1 and day1 to day31 as fields. In the Datasheet view it weill have the employee name or number in the first column and day1 to day31 displayed across the top but in lieu day1...

What problem are you having? Post a sample of the current employees and the required data structure.

You can not use the code in the Open event for a continuous form. You have to do the checking for date in the query that is the record source for the form. You will need something like this test_date: IIf([volgendeactie]=Date(),[volgendeactie],[laatsteactie]) test_date is the alias for the...

I am not familar with using criteria for reports but here are a couple of suggestions that you could try based based on past experience using code. If Me.1259rec is a date then you may need to use the following format [CouponBk].[1259rec]=#" & FormatMe.1259rec , "mm/dd/yyyy") & "#" Also the...

Do your requery in the Got Focus event of each combo box and not the Enter Event of each combo box or form.

Here is another alternative. Use a query to join the ID in table1 to ID in Table2. If you have field names in both tables with the same name then you will need to use aliases. Suppose you have a field named "field1" in table1 and "field1" in table2 then you will need aliases by using...

In the Help there is How to: Create Multiple Instances of a Form This is in the the article Dim frmInstance As New Form_Employees You will need to play with the dim statement Hope it helps

Bob From my understanding of the question is that the user wants to compare ID in table1 to ID in table2 and if they are the same then do the calculation. See the following line in the user's code If "Field1".value = ID then This will require two loops similar to this air code Set...

Create a module with this code OpenForm(frmName As String) Set frm = New Form(frmName) end sub To call the module use OpenForm("Form Name")

In the table that you are appending to make sure that you have the primary key set. Then in the code to run the query have the following code Docmd.Setwarnings false run your query code here Docmd.Setwarnings true The Setwarnings will not display and message for a duplicate record when you...

Should ID be a date or Text or a number etc?

For new clients use an append query to append the data entered on your form to the clients accounts. When you click the account run the query and the client details will append to the table.

dorramide7 I have already provided Dgavilanes as solution so please contact. It is a coincidence that two people are working on the same form. Just a point you can not have the word and background colour the same colour, if you do you will have the text box with a colour and the word will...

Yes, that will be OK

Dennis In the form code where you do the calculation add this code Dim color_red As Long Dim color_yellow As Long Dim color_green As Long color_red = RGB(255, 0, 0) color_yellow = RGB(255, 255, 0) color_green = RGB(0, 255, 0) ' calculations go here ' now format the backcolor Select Case...

If the calculated field is an unbound field for a continuous or a datasheet view, then you will have the same colour for the calcuated field in each record.

Paul Sorry my mistake I forgot it was in the Forms and not the General forum

We can help you if you post more details and your code.

I use the following code in a report that shows what account must be paid within the next 30 days. If the due date of the account is within 30 days then the back ground of the text box is shown as Yellow, otherwise it is White. Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount...