Search results

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...

What are the expressions in the detail section and form footer?

You could try Sum() the statement from the text box. =Sum([your statement here])

I took one of your expressions and began creating a function with comments about the process I go through in your other thread. You need to start the conversion and a new thread when you begin to stumble (we all do).

Here's how I would go about converting the expression into a VBA function in a standard module named modBusinessCalcs. You can test this in the immediate window by using: ? YourFunctionName(value1, value2, value3,...) You should also understand how to add a breakpoint to allow your to step...