Search results

When using date functions provided by others, it's important to diligently test the functions across several sets of data (or dates, in this case). Just because a function seems to works properly/accurately/error-free on today's date, that doesn't mean it will be accurate for the whole year...

Re: Performing a spell check on the contents of a userform field It would indeed be handy if the title of this question was renamed in indicate it's an Excel question. That said, another way to check spelling in Access is with the help of a reference to Excel. From a related answer of mine:

Twenty-five years ago today, November 13, 1992, Microsoft's Project code-name Cirrus was officially released to the public as Microsoft Access 1.0, marketed as the "Business Information Access Program plus Menu Developer's Kit". (Ahh the unlimited potential in a career as a professional Menu...

Was sapi_onecore.dll already on your system? I see a potential download site for onecore.dll but not sapi_onecore.dll.

Hmm ok, now I'm curious: in your opinion, is that a good thing or a bad thing? The world seems to be moving away from face-to-face contact, yet contact "in general" is easier (for example, this very conversation!) As a single parent of a teen, I wrestle with this on a daily basis...

...to export data from Access to Sharepoint? Here is an example using docmd.TransferDatabase from MSDN : DoCmd.TransferDatabase transfertype:=acExport, databasetype:="WSS", _ databasename:="http://example/WSSSite", _ objecttype:=acTable, Source:="Customers", _...

Thank you, we will check out Destiny. My son is 13 and I've come to terms with the fact that keeping him sheltered from violent games is impossible, so instead we keep an open forum, such as his love of GTA on PC. "When I was his age".... ah, nevermind, at his age I was playing Leisure Suit...

There are a number of solutions if you check Google.

...looking closer, you're missing the 2nd half of that statement. Perhaps a mis-copy/paste? You're saying: (if that makes sense)

Count the number of the left-brackets and the number of the right-brackets. They should always be equal.

Sub IsDatabaseOpen() Dim appAccess As Access.Application Dim fileName As String, File_is_closed As Boolean fileName = "c:\path\filename.accdb" On Error Resume Next Set appAccess = GetObject(fileName) If Err.Number <> 0 Then File_is_closed = True Debug.Print "File...

Great, that's just the kind of info I'm looking for! The Wayback Machine is fun for Internet flashbacks! (I was just thinking back to my first search engine, Altavista...) For some reason I don't understand, some hosts like Google Pages don't allow stuff like: Thanks again for the suggestions...

Good Day fellow "Access people"... :) I'm looking for two recommendations. I realize there's no "single right answer" but I'll check out any suggestions you can make (and I'll report back to this thread on what worked out for me, and why!) 1. Which Web-Design forum is the best? (For all...

Microsoft doesn't go out of their way to advertise all the products they offer 100% free for current or former students or teachers at recognized institutions (worldwide I think?)... Basically, you need to have an email address from a school that you've attended, where you can get a "click here...

Hi Zandy, welcome! I was an Access developer as part of a past job, and then I wasn't, then I missed it and got back into it for "recreational" purposes (ya I'm a geek, lol), and that led me to paid work, for something I enjoy. (That's always a bonus!)

Welcome Alan! Agreed: what good is a boring, lone teacher when we have access to thousands of teachers with the help of forums like this!

I may be a database geek but I have no idea about gaming systems, however my son was just gifted a PS3 and the link you posted is exactly what kind of site he was asking for help finding - thanks! Sorry, I have no advice on which PS4 co-op games are the best, but do you happen to have any...

Here's a possible (although odd) possible fix, and there are others in that thread.

I'm always struggling with outlook integration. Did you see this lengthy (90+ post) thread on the subject?

You could store the field as text instead of hyperlink, and then convert it if/when/how you need it. I don't use the "hyperlink" data type any more, for a number of reasons that this guy explains well.