Search results

How do I use the code tag

I am looking for some help from this community. I copy the following code to filter a list box and various combo boxes. I am having a hart time adding more code to the STRWhere statement. When I select items from the list box and also select an item from the combo box, the information is...

It says invalid inset into statement The SQL is just a variable to hold the expression

I have the following code where I am trying to copy the value of one table to another and for some reason that I can not figure out, the code is not working Option Compare Database Public Function taskschedule() Dim DB As Database Dim RS As Recordset Dim SQL As String Dim Descr As String...

When I filtering by Entity and CoCode and Benefits is blank, the code is selecting this block 'Filtering by Entity, Benefits and Company Code When I am stepping into the code Benefits value is zero

Yes I had done that

Hi, Can someone please check this code to and give me some input to see why it is failing. I am filtering a form for entity and cocode and the codes is selecting the block for entity, benefits and cocode Private Sub btnfilterdata_Click() 'On Error GoTo Problem: Dim FilterData As String Dim...

MonthNo is not a field on the tbmatchamount. I previously tried to pull just the month from a field on the tbmatchamount and I could not get the correct information. Month(matchmonth) I just need the month number = to a variable that I create from information con the control tag (Tagvalue)...

The cell that create the error is this and I know that it happened on the " & MonthNo =" & 1: MonthlyAmt = DSum("matchamount", "tbmatchamount", " EmployeeID=" & FLNo & "" And "& MonthNo =" & 1)

Can someone please check this function and give me some advice regarding fixing this mismatch. Public Function MonthlyAmt(FLNo As Integer) As Currency Dim MthDate As Date Dim MonthNO As Integer Dim YearNo As Integer Dim MatchAMT As Currency Dim STCreteria As String Dim FMTest As Form Dim...

Can you please explain a more simple term what I should do to accomplish this task

The purpose of this function is to pull monthly amount for various employees on a continues form. I do not want to use the crosstab option because I want to be able to filter the form by year later one. The final result should be something like this: Employee Name Jan Feb March .... XXXX...

I need the help of one of you regarding this function. I am creating a form to pull value from employees for each month of the year and I want to create a function to pull those values from a table. the function is giving me a mismatch error and I can not figure out. Thanks in advance...

I want to have the same end result as s crosstab but without using the wizard because I want to be able to filter the date by year or month

Thanks for your suggestion. What is your thought on getting the information on a form with just one line for the employee and the amount on each column

- I am opening a recordset because I need the date field which is locate on the table no on the query. The query only has the employee name and the monthly amount from January to December. if I add the date on the report is going to show the employee duplicate. one line for each month

Hi As you can see I am new on this. I have a form with monthly data for various year and I want to create a combo box to filter the data by year. I have this event after update on the combo box but it is giving me an error and I do not know why to fix it. I create a query with every month but...

What could be the easy way to create a cross tab report for every month/year that I can change without using the default access option

I just need to filter the selection

Hi all I need to guide regarding filtering this column in a query. I have the following column: BenefitsReconciliationDate: IIf([EndDateValue]=-1,[ReconciliatinDate],[EndDate]) If the value is null, it shows -1 and 0 if is not null the value for the reconciliation date is the following...