Search results

To make a free Custom Google Search page you just need a Google Account, and to https://cse.google.com/cse where you can specify sites to search, look & feel, and lots of other options. Instructions here (quick version) or here (long version) including access via API's, search results via JSON...

Re: Solved or Never Solved? I completely disagree. Other than questions like "what's the function called that does xyz ?", the majority of issues are potentially never "SOLVED". Often, even coding advice from Access2007 still applies to current versions, and any advice always has the...

...also don't forget to .close the recordset at the end of the procedure. This page has some good starter tips for working with VBA recordsets (#12 re: closing and #4 re: what Gasman said).

DateDiff("d",[date1],[date2]) will give you the difference between [date1] and [date2], in Days. Check out other options here. With that in place you can get averages, sums, etc. For averages, paste this into SQL view: SELECT Count([date1]) AS CountOfRecords...

Hi Bechert, There must be some reason that you are specifically referring to the century? Perhaps you're dealing with historical dates or working towards Julian? Beyond that I have some thoughts -- but I'll likely just confuse matters, so everyone stop reading now. :) Ridder's function...

...for a sole, specific source, with a known output format?

I have a faint memory of playing with a multi-monitor API, many moons ago. I believe there is a specific API but I can't find it at the moment (and currently I don't have multiple monitors to test, anyways). The GetSystemMetrics user32 function has a few monitor-related functions which may or...

Hi Greg, You have 2 AddNew statements in a row, that could be part of the issue.

I spent some time on a similar task recently and can confirm that specifying a sort order is not possible. It's probably a lot easier to populate a table and let Access sort it with a query, rather than going through the trouble of sorting an array. You might get some ideas here...

Access isn't very co-operative when it comes to producing emails with HTML body, especially with it's lame excuse for support of HTML Templates so I put together my own email-template-interpreter a while back. I've attached an adaptation of it using your data example. (Both files in the zip...

No problem, just send me all your code and I'll take a look... (Kidding!) First, you'll proably want to "add trust" to the database by adding a digital signature to your VBA project (see this and this) otherwise, users of a protected version could get a scary warning every time they open the...

You get an A for effort, but you don't need VBA for that! :) On Sheet 1 or Sheet2, cell A1, you can enter a formula like =Overview!A2, where 'Overview' is the name of the first worksheet. Example attached. :)

If you're updating the table with a SQL statement, "July 28, 2017" is a text field (hence the quotes) #July 28, 2017# is a date. However Access doesn't recognize either one as a date if the Weekday is included. Also keep in mind that the FORMAT function returns text (not a date data type).

This should help: Sub OpenOutlook() Dim myNamespace As Object On Error Resume Next Set myNamespace = GetObject(, "Outlook.Application") On Error GoTo 0 If myNamespace Is Nothing Then Set myNamespace = CreateObject("Outlook.Application") MsgBox "Outlook...

Close! ;) I think you want: DLookup("[Session]","tblTAssign_FPA","[AcademicYr] = " & txtApptYr.Value & " AND [Rotation] = " & iRotation & " AND [Session] = " & iSession )

Correct me if I'm wrong (and I hope I'm wrong) - as I see it, a huge part of the issue is that many JSON don't stick very closely to the "standards; often very slight differences -- which would be fine if each API provided a schema to use as a template when parsing, but's that's not the case...

Hi Greatdod, Welcome!

@jdraw AWESOME, thank you for sharing!

SQL Server Express stores data locally. You can try it for free and if you decide that you need the full version of SQL Server, the data is easily transferred over. Here's a quick overview of the options.

To 'select all' the rows, set Multi Select to Simple or Extended, and add a button called btnSelectAll with code: Private Sub btnSelectAll_Click() 'select all rows in Me.Entitlements Dim counter As Integer For counter = 0 To Me.Entitlements.ListCount-1 Me.Entitlements.Selected(counter) =...