Search results

You most likely have user entered updates along with code updates. This will cause your error.

If the tblVisits is linked, you can create a query with this SQL to find out where the backend database is located: SELECT msysObjects.Name, msysObjects.Type, msysObjects.Database FROM msysObjects WHERE msysObjects.Type=6 OR msysObjects.Name ="tblVisits";

I continue to wish you would use your words rather than expect us to understand Excel functions.

Can you use words to describe your requirements so we don't have to guess and reverse engineer?

What do you get if you open the debug/immediate window and enter: ? acReport

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 😉