Go Back   Access World Forums > Search Forums

 
Showing results 1 to 20 of 20
Search took 0.02 seconds.
Search: Posts Made By: gleesonc
Forum: General 10-04-2019, 09:30 AM
Replies: 3
Views: 160
Posted By arnelgp
Free Programming E-Books

to all of you out there!
want to download Free programming E-books
including VBA, SQL,Algorithms, MSSL, MySQL, etc.

follow this link: https://goalkicker.com/
Forum: Modules & VBA 10-04-2019, 07:35 AM
Replies: 16
[SOLVED] Word Merge
Views: 354
Posted By isladogs
Re: Word Merge

Hmm - I see nothing in his code that requires changing for 64-bit as it has no API declarations

Attached is the modWordcode module that I've used for many years and none of my clients have...
Forum: Modules & VBA 10-03-2019, 03:07 PM
Replies: 16
[SOLVED] Word Merge
Views: 354
Posted By isladogs
Re: Word Merge

I've used a modified version of Albert Kallal's super easy mail merge for over 10 years. Just import the entire module to your app and run it using one line of code. There is no 'add-on' and all the...
Forum: Sample Databases 09-16-2019, 06:23 AM
Replies: 1
Views: 385
Posted By arnelgp
Better Msgbox alternative

before giving this out to the OP, might as well put it here for everyone.
the bulk of the code is not mine, just added some good feature.
Forum: Modules & VBA 08-28-2019, 12:19 AM
Replies: 4
Views: 131
Posted By Galaxiom
Re: Word Automation Late Binding

A handy alternative that makes it simple for Late Binding is to include a module with all these constants declared.

BTW I sometimes design with the library loaded so the Intellisense works, ...
Forum: Modules & VBA 08-27-2019, 04:52 PM
Replies: 4
Views: 131
Posted By MajP
Re: Word Automation Late Binding

For any constant go to the immediate window
?wdCell
12
Forum: Modules & VBA 03-27-2019, 06:06 PM
Replies: 25
Views: 356
Posted By June7
Re: Run code AFTER Access closes

Automatic updating database is fairly common topic. Here is original updater code from my db. Notice there is no script file called, all self-contained - don't ask me how it works, it is found code....
Forum: Queries 03-27-2019, 01:19 AM
Replies: 10
Views: 296
Posted By isladogs
Re: Sequence missing to be tracked

Here's a variation on the previous answer
I'm assuming this is only a subset of all your data as you already have the answers for this dataset!

NOTE: 'No' is a reserved word in Access - UserNo...
Forum: Sample Databases 03-23-2019, 10:27 AM
Replies: 4
Views: 4,884
Posted By isladogs
Re: CDO EMail Tester

Following an question via PM by AWF member ellenr, I've discovered a new issue sending email using CDO using a GMail account
Google has added additional security which effectively blocks email sent...
Forum: Code Repository 03-14-2019, 11:09 AM
Replies: 2
Views: 990
Posted By isladogs
Synchronise data with external source

The attached items were written some time ago in response to various questions from forum members including several posts by AWF member jaracek such as: ...
Forum: Modules & VBA 02-16-2019, 10:41 AM
Replies: 1
Views: 179
Posted By isladogs
Heisenbugs and schrödinbugs

A link in a thread I was assisting with earlier today led me to a Wikipedia article about Heisenbugs (https://en.wikipedia.org/wiki/Heisenbug).

For those who are unaware of the term, a Heisenbug...
Forum: Modules & VBA 02-12-2019, 08:24 AM
Replies: 4
Views: 131
Posted By theDBguy
Re: After 25 years, just noticed something: DSum will multiply fields

Hi. That's what's cool about domain aggregate functions. It won't apply aggregation until all expressions are evaluated. So...
DLookup("[FirstName] & ' ' & [LastName]",...)...
Forum: Modules & VBA 02-12-2019, 08:20 AM
Replies: 4
Views: 131
Posted By cyberman55
After 25 years, just noticed something: DSum will multiply fields

Posting this just in case others haven't noticed this. On a lark, I tried it and it worked!

Me.txtConsumeCost = DSum("[cost]*[AmountUsed]", "qryfrmProposalWiz05Sub0400Parent")
Forum: Tables 02-01-2019, 08:26 PM
Replies: 3
Views: 181
Posted By Pat Hartman
Re: Unviersal link to table

Here's a database with a form that shows a method for letting the users do their own relinking without using the linked tables manager.
Forum: Modules & VBA 01-30-2019, 11:18 AM
Replies: 7
Views: 114
Posted By Gasman
Re: Sending Emails based on table field value

There have been several on here as well, as far as email with data in the body.

Even I have posted some code several times.

I am not going to look for it, but will post again.

Please note...
Forum: Modules & VBA 01-23-2019, 07:38 AM
Replies: 10
Views: 94
Posted By theDBguy
Re: How to run vba for another databse

Hi Zandyboy. If all you need is to create a backup copy of the backend data file, then maybe you can avoid all that by trying out this other approach...
Forum: Code Repository 12-18-2018, 03:19 AM
Replies: 0
Views: 2,584
Posted By isladogs
Access/Windows/Office365 Checker

Attached is a utility for checking the following:
a) Windows version & bitness (32/64-bit)
b) Access version & bitness
c) Whether Office 365 is installed

This is an updated version of the...
Forum: Sample Databases 11-27-2017, 10:51 AM
Replies: 0
Views: 2,401
Posted By arnelgp
fnAnySQL() parameter query

i am now shelving my FixSql() function, for the time being to give way to a new function someone shared on this forum (you know who you are).

I modified the function so it can be generic and be...
Forum: Sample Databases 04-27-2017, 04:48 AM
Replies: 9
Views: 6,165
Posted By isladogs
Set a group of controls as visible/hidden, enabled/disabled or locked/unlocked

The attached utility demonstrates a way of setting the state of a group of controls at the same time using the controls' Tag property.

The properties that can be controlled are: .Visible ,...
Forum: Sample Databases 04-24-2017, 06:50 AM
Replies: 8
Views: 7,195
Posted By isladogs
SQL to VBA and back again

Some years ago, the wonderful Allen Browne created a small utility called Sql2vba
See his website: http://allenbrowne.com/ser-71.html

The purpose was to save developer time:
"Rather than typing...
Showing results 1 to 20 of 20

 
Forum Jump



All times are GMT -8. The time now is 03:57 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World