Recent content by tyronedjackson

I have a table with two columns called FromDate and ToDate indicating the start and end of a student's program. Since the client sells it's programs by weeks, they would like a report that shows the number of weeks sold for every week of the year. The challenge is to get a crosstab query to...

The syntax for the CurrentUser function is CurrentUser() with the parenthesis. I didn't see the parenthesis in your code.

Just as The Doc Man has instructed you, all of this goes in the OnOpen or Onload event of your form... Private Sub Form_Open(Cancel As Integer) 'Declare your query variables as strings Dim Update_Query(A) As String '...and so on for all the five queries 'then assign a value...

Having trouble with a transaction that adds payments to a payment table using the sum of the group of payment details, and then adds the details to a related detail payment table. The information comes from records in one subform that may include multiple detail payment records for mulitple...

I'm new so please bare with my explanation. If it doesn't make sense, let me know and I will explain again differently. I would first try this.... strWhere2 = " AND ([Location] Like '" & IIf([Forms]![frmDataEntry]![fltrLocation]= "<All>", "*" ,[Forms]![frmDataEntry]![fltrLocation] & "'))" I...