MS Access
Access Concatenate
Class: Concatenate(“SELECT [memclass] FROM [member_list_XLS] WHERE [number] = ” & [number]) Used in IFA Member_list_source-XLS
Access: Convert reports in 2003 to PDF without any PDF software
You can use the A2Kversion with A2000, A2002 and A2003. It can also be converted to A97. Please view the form named README before launching the converter.New Release: Feb 03/2009 – UPDATED DLL’s only! UpdatedDLLsONLY.zip DynaPDF.DLL is an update from the developer of this library. It fixes a bunch of issues with the conversion of […]
Using Blat, Stunnel and Gmail Together
I’ve been a long time fan of blat, a command line utility that uses SMTP for sending quick messages. The problem is that a SMTP Server isn’t always available to every computer. For awhile, I was loading a separate SMTP Server program on any computer that I needed to use blat on. I have since […]
Adding new staff to database
To add new staff and give access to IPCA database: 1. Go to IPCA_DB folder 2. Open backend file 3. Under Tables, go to PCAStaff add new staff.
Best way to do Access search or find
Best way to do a search and result database form is using a filter. See FMC Supporter database as an example. that Angie did. Also see under the infoage backup folder Angie’s goodies scripts.
How to Lock Down that .accdr!
How to Lock Down that .accdr! Mark EdwardsPresident/Chief Architect at VBA Office Solutions, LLC With all the issues surrounding Access app security like a Navigation Pane that won’t stay hidden, or being able to change the extension on a .accdr file name to .accde or .accdb to crack it open, etc., I’ve been busting my […]
10 Things we LOVE about Access 2013
http://accessexperts.com/blog/2012/08/20/10-things-we-love-about-access-2013/ Microsoft Access 2013 is out and both Ben and have been experimenting with it for sometime now. Here are 10 things we love about the new Access web services: 1. It’s SQL Server-based. (Ben) It used to be that Access had its own database engine, known originally as JET and now called ACE. We could […]
Truncation of Memo fields
http://allenbrowne.com/ser-63.html In Access tables, Text fields are limited to 255 characters, but Memo fields can handle 64,000 characters (about 8 pages of single-spaced text) – even more programmatically. So why do memo fields sometimes get cut off? Queries Access truncates the memo if you ask it to process the data based on the memo: aggregating, de-duplicating, formatting, and so on. Here […]
Access Rich-Text: Which subset of HTML is supported?
http://office.microsoft.com/en-us/access-help/insert-or-add-a-rich-text-field-HA010014097.aspx