Search results

SQL SELECT tblMain.Date, tblMain.Region, tblMain.Contact, tblMain.Discussion FROM tblMain WHERE ((([Forms]![frmMnForm]![Region])=True)) GROUP BY tblMain.Date, tblMain.Region, tblMain.Contact, tblMain.Discussion; Private Sub Combo2_AfterUpdate() Me.RegHistSub.Form.Requery End Sub My subform is...

It is a combo box. Sorry for the confusion. My code is in the code builder with the name of my subform. It does not update after I make a selection. Could it be something in the query?

Something isn't clicking, probably me. It will not update. Should the code go in Expression Builder or Code builder in the After Update box of my list box? Do I need to include anything else in my query. Right now the query is dependent on what is in the list box on my form but will not run...

I just tried but it gave an error. Where do I need to include that verbiage and is that the exact verbiage I need to use?

I need to have a subform query embedded in my main form that when the user selects an item from a drop down box it will display the query results in the sub form. I have my query set up to work off of this drop down box I just can't get it to update on the subform when selected. Any ideas?

It's been a long week so forgive me but I am not following. Is this going to take names off as they are selected then refresh when all have been used?

Can you please expand a little. I am not sure what you mean.

I have a list box that is filled from a table with names of individuals. What I would like to do is when one of the names is selected it will take it off the list and do this for all the names in the list until all are removed then will reset and have the names avaialble once again. Is this...

It is a table.

I have a list box with names of individuals. What I would like to do is when one of the names is selected it will take it off the list and do this for all the names in the list until all are removed then will reset and have the names avaialble once again. Is this possible and if so how can it...

I have a list box containing various items. I would like to have another field return a numeric value depending on what is selected in the list box. For example, if Closed is selected from the list box, the other field would return a 1. How can I do this. The new field also needs to be...

I have a ddlb called FieldA with multiple choices. I want to have another filed, FieldB that will return a numeric value based on what is in FieldA. For example if Red is selected from the DDLB I would like Field B to have a 1. I am thinking that a Case Module needs to be done but how is can...

That's not exactly what I had in mind. I have done this in the past using Case and saying Case "Red" Value = 2 and so on. All of the options in the list box (FieldA) will have a numeric value 1-4. I just need to link the code to FieldB after the selection is made in FieldA.

I have a drop down list box on my form called FieldA. I would like for FieldB to update with a number depending on what is in FieldA. For example, if FieldA has Red, I would like FieldB to return a 2. I know this needs to have a case function done, but how do I get it linked to FieldB?

I have figured out the problem. I have the turnaround time in my query formula linked to a module and did not have one of the fields defined to make it a number. Thanks anyway.

Tried it and still doesn't work. Something is up with the Avg formula that it doesn't like. I have banged my head around too much on this one. If the turnaround time is on the report there should not be a problem averaging it right? i have done this countless times without any problems.

I am receiving an error message (...could not execute SQL statement...)when I try to run a report with an average of a field. I have a query that calculates turnaround time between 2 dates using the DateDiff function. My query runs fine and the report runs fine as well. I am trying to get an...

These threads are about getting the number difference in time. I need to just count the number of accounts that came in between time a and time b when the time is between a pm and an am time.

What I am trying to do is get the total number of accounts that came in between 8:30 am and 8:00 pm and also the number that came in after 8:00pm and before 8:30 am. I assume I will need to have 2 queries written. I don't have a problem with getting the number between 8:30 am and 8:00pm. My...

Is there a way to exclude weekends and holidays from a turnaround time formula? If I have a start date and an end date, I do not want the turnaround time to be skewed when people are not here. Thanks for the help.