Search results

Thank you Isskint I will try this out. Elaine

Hello, I did a calculation in a query that gives me how many minutes/hours it took to process records. Now what I need to do is show how many records took only 0-2 hours to process. 2-4 hours to process. 4-6 hours to process etc. How do I do this? Any help is greatly appreciated. Elaine

Hello, I have a form with a field named Remain date and a field named Count. Every time the remain date field is changed I want the other field Count to increase by 1. The Count field will start off at 0. So I want this field to count the number of times the remain date field was changed...

Thanks I will try it out.

Form 2 will not be loaded when the user completes the record and checks the box in form 1. When form 2 is opened I want those records that match those records in form 1 to have the same completed date. An ID # will be the same in form 1 and form 2 and that's how the records will be connected.

Hello, I have a form (form 1) that allows the user to enter information. I have a button on form 1 that when the user is complete with entering the information they will mark the record complete by clicking on a button and the current date will prefill into another field.(field 1) Once the...

Thanks John I am going to check it out. Elaine

How would I limit a combo box selection based on a text box value for example: if a field named team prefills with the word admitted(I am not selecting this field it prefills based on another field). I want a field called producer code which is a combo box to have a drop down selection of only...

Thank you Pat. Will try it.

Thank you so much JANR it worked.

Thanks Ken

Hello, If there a way to combine all of the dlookup formulas since I am wanting the underwriter, region and line to fill in based on the prefix of the policy number? Right now I have them separate: 'I am wanting the lookup to find the underwriter by looking at the policy prefix field and...

Hello, 1. The name of the form - edit data 2. The name of the textbox - agup code 3. The name of the combo box - producer code 4. The Row Source of the combo box. - qryProducers1 Thanking you in advance. Elaine

Hello, Example: I have 4 digit codes in a table I create along with 7 digit codes associated with the 4 digit codes. I have code 2261 and this code is associated with Three 7 digits codes of say 1249510, 1249511 and 1249512. When I enter code 2261 in my text box I would like a drop down list...

Hello, I have a four digit code that may only be associated with one 7 digit code or it may be associated with more than one 7 digit code. If the four digit code is entered and is associated with 2 or more 7 digit codes I want to produce a list of the 7 digits codes that the four digit code is...

Thank you for your reply. Elaine

Hello, My employees are entering how long it will take them to do a transaction. They will click a checkbox to give them the start time in a sepate text box. They will click a checkbox to give them the end time in a sepate text box. Both have the input mask of 00:00. I would like to add the...

This part of the code will be different depending on the transaction type: dtTemp cound be 1 or 3 Me.TMG_Target_Date = fAddBusinessDay(dtTemp, 2) '48 additional work hours ' If dtTemp > Me.Date Then ' Me.TMG_Target_Time = Me.[Time Received] ' End If Else...

Yes, because the transaction types were different so I thought I had to repeat the code again. I don't know much about code so any help will be greatly appreciated. Thanks.

Hello, I am getting a duplicate declaration in current scope error. How do I fix it. Sub SetupTargetDate() On Error GoTo ErrorHandler Dim dtTime As Date Dim dtTemp As Date If IsNull(Me.Date) Then Exit Sub If IsNull(Me.Time_Received) Then Exit Sub dtTime = Nz(Me.[Time Received]) If...