Search results

try: SELECT tblTickets.IDTicket, Count(tblTickets.ID) AS CountOfID FROM tblTickets GROUP BY tblTickets.IDTicket, tblTickets.Status HAVING (((tblTickets.Status)=1));

This project would require a robust database like SQL Server or Azure. The whole integrated system seems like SAP or Dynamics. I wouldn’t attempt to roll your own if your business depended heavily on it.

Just look away from the screen 😉 I believe this has been discussed here before with no easy solution.

I would add a column/field that stores whether or not the status is still in use. You should not be hard-coding <> 4 AND <>5.

There is an API for google calendar which I haven't reviewed. You can also import from various other calendars as well as CSV.

Have you considered a shared google calendar? I have done this with several organizations.

I would experiment with some different values and delimiters in a query and a pass-through query.

Is the combo box bound? According to documentation: "Microsoft Access uses the OldValue property to store the original value of a bound control"

I believe with aggregate functions like Min or Max, you will need the Group By.

I’m traveling out of town this week without a laptop so won’t be able to reply. Did the PDF report pages correspond with the desired output based on the data in the file you provided? If not, could you provide files that align?

Try add the date delimiters Dim strSQL As String strSQL = "TransactionDate = #" & Format(Me.DatePicked, "m/d/yyyy") & "#" Me.Filter = strSQL Me.FilterOn = True

@Gasman and I both mentioned "last line". Did you try before reply?

Your ORDER BY is in the middle. Try move it to the end of the SQL statement.

I'm in and out of Eau Claire for a banquet. Might not even have time to visit my grandkids.

I’ll be in WI tomorrow 😉

Isn’t there payroll software that does all of this for you?

Does your code compile? I don't see an "If ... Then" line in Private Sub OrderDtl_frm_Exit(Cancel As Integer). I hate using ElseIf when it is much easier to use and maintain Select Case.

Conditional formatting does allow disabling. In the following form, I have set up conditional formatting based on even or odd CompanyID values.

I have used a solution with a hidden text box in the form header to store the primary key values of the selected records. Then create a conditional formatting rule that determines if the current record's primary key is contained in the hidden text box. You would need to have some code in the...

You can test your code/functions in the immediate window (press Ctrl+G) and enter the function with some sample values ?ReturnData(1, 50000, 25000, 1000, 2500) This will run your code and return the results. Play with a variety of different values/scenarios to confirm all possibilities. You can...