Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 417
Search took 0.07 seconds.
Search: Posts Made By: Gasman
Forum: Forms Yesterday, 03:08 AM
Replies: 10
Views: 117
Posted By arnelgp
Re: Email Form As Shown (Not in Tabular Format)

I created yet another function.
this time it only take a snapshot of the form.
Forum: Modules & VBA 09-17-2019, 01:36 PM
Replies: 23
Views: 459
Posted By Nixversteher
Re: Problem when subclassing form

This is an experiment (only 32bit) with your subclassing title bar double-click code where the editor can be open (hopefully).
But I think if you want to use subclassing it is better to outsource...
Forum: Forms 09-10-2019, 02:43 AM
Replies: 4
Views: 95
Posted By isladogs
Re: Followhyperlink to Different Browser

Daniel Pineault has some code that should do what you want https://www.devhut.net/2018/02/01/vba-open-a-url-in-firefox-chrome/

However Access insists on using IE for some actions no matter what...
Forum: Code Repository 09-07-2019, 05:37 PM
Replies: 7
Views: 237
Posted By Micron
Randomizing Data for Posted db's

We often ask Original Poster to upload a copy of their db but the issue might be that it contains sensitive data. Complete data removal may not allow us to troubleshoot the OP's issue because...
Forum: Forms 09-04-2019, 09:35 AM
Replies: 5
Views: 119
Posted By bob fitz
Re: Cascading combo-boxes in table form

If your sub form is in datasheet view then the solution used in the attached db might be used.
Forum: Queries 08-30-2019, 05:31 AM
Replies: 16
Views: 301
Posted By FLJerseyBoy
Re: Different results-Access 2016 passthrough query vs MSSQL

I am soooo relieved to report that I now know what the problem was. ("Was" being the key word, lol.) It had nothing at all to do with VBA or, really, with anything else I could imagine.

Forum: Windows 08-14-2019, 07:46 AM
Replies: 8
Views: 172
Posted By Uncle Gizmo
Re: DB on opening Win 10

I'm sure it could be done, and I'm sure someone will let you know! However there is an alternative which might be nearly as good and is straight forward.

Open your MS Access database, then open...
Forum: Forms 08-14-2019, 02:57 AM
Replies: 1
Views: 58
Posted By MajP
Re: When is a Bookmark created ?

varBookMark = Me.Bookmark
as soon as you requery you get a new set of bookmarks. Code fails here.

Forum: Queries 08-13-2019, 09:39 PM
Replies: 12
Views: 248
Posted By MrHans
Re: Query to Transform Data

Recently I stumbled upon an improved version of ConcatRelated written by Gustav Brock, see this link:...
Forum: Sample Databases 08-09-2019, 04:28 AM
Replies: 4
Views: 4,703
Posted By isladogs
Re: CDO EMail Tester

Something Iíve been meaning to do for a long time
Iíve just updated my CDO Email Tester to include HTML Email as well as plain text.

Unzip the attached file & keep all files in the same folder...
Forum: General 08-05-2019, 11:12 AM
Replies: 20
Views: 381
Posted By isladogs
Re: Pencil and paper

I agree. Its time for Bill to leave this forum. We've all been very forgiving of past rudeness and have given extremely extensive support. In several cases, members have almost completely rewritten...
Forum: Queries 08-05-2019, 07:51 AM
Replies: 26
Views: 194
Posted By theDBguy
Re: Query not showing records

I believe Access adds the current year to the date, if not provided. Otherwise, the result would be a division, which is why I asked about the datatype.
Forum: General 08-03-2019, 10:50 PM
Replies: 38
Views: 604
Posted By MickJav
Re: The enduring nature of Access

The last version here


There is only one more error found which reletes to adding holidays for years that are...
Forum: General 08-02-2019, 08:42 AM
Replies: 38
Views: 604
Posted By NauticalGent
Re: The enduring nature of Access

While we are waiting for Tera’s sample, here is the first in a 9 part series of videos on how to do custom ribbons.

I had toyed with the idea myself but what I have works and quite frankly, I was...
Forum: Modules & VBA 07-31-2019, 11:29 PM
Replies: 67
Views: 656
Posted By arnelgp
Re: Code for Business Hours -Help Please

' compute Work hours between business hours
' arnelgp
' for Lilly420
' 1-aug-2019
Forum: Modules & VBA 07-26-2019, 12:57 AM
Replies: 11
Views: 235
Posted By MajP
Re: Mark possible duplicates in Search

Here is a good helper function that I use especially if doing a lot of SQL searches.

Public Function SQL_Text(ByVal varItem As Variant) As String
If Not IsNull(varItem) Then
varItem =...
Forum: General 07-25-2019, 11:58 PM
Replies: 41
Views: 671
Posted By isladogs
Re: Shutdown PC through Access button

Here is the code I've used for the purpose. Place in a standard module
I expect its similar to that in Arnel's example & Gasman's link

Option Compare Database
Option Explicit

'NOTE switches...
Forum: Modules & VBA 07-25-2019, 09:55 PM
Replies: 15
Views: 269
Posted By Pat Hartman
Re: Auto Backup of Split Database.

This is the code that goes in the Unload event of the form that opens first and is unloaded last. Some of the paths are hardcoded in this example but I suggest using a different method. You could...
Forum: Queries 07-25-2019, 05:36 PM
Replies: 15
Views: 563
Posted By Galaxiom
Re: Show Results From Month Specified

:eek: :eek: :eek:
In the expression I posted, definitely. There is a world of difference between a function on the left hand side of a WHERE clause where it must be applied to every record and...
Forum: Forms 07-13-2019, 10:35 AM
Replies: 62
Views: 921
Posted By Micron
Re: How to make a field mandatory

AFAIK, if the field cannot accept zls then it will be null. Then again, I know if you try to add only a space to a table field, Access will remove it, hence still null.

Possibly something like...
Forum: Forms 07-12-2019, 07:05 PM
Replies: 62
Views: 921
Posted By Micron
Re: How to make a field mandatory

This works where I have both textboxes and combos where their Tag property is (e.g.)
reqd,message 4 and more text
Note that it is reqd and then a comma and then text with no spaces until the...
Forum: General 07-11-2019, 12:22 PM
Replies: 9
Views: 157
Posted By arnelgp
Re: Start an Access app from an external program?

you can use api to get ms access window handle number if the app is running. 0 if not running:

Option Explicit

' Module Name: ModFindWindowLike
' (c) 2005 Wayne Phillips...
Forum: Modules & VBA 07-10-2019, 02:38 PM
Replies: 14
Views: 326
Posted By sxschech
Re: How Does Outlook Resolve Email Addresses

Here is a function I use for resolving email addresses.

Public Function Outlook_Resolve(sendto As String)
'Resolve and return Outlook email address
'Code copied from Outlook_ReplyAll, so may...
Forum: Queries 07-09-2019, 12:12 AM
Replies: 9
Views: 193
Posted By CJ_London
Re: Multiple Appends

try sorting it?
Forum: Modules & VBA 07-03-2019, 07:38 PM
Replies: 30
Views: 593
Posted By GC2010
Re: VBA To Reply All Email

I'm still learning VBA but I frankenstiened some code together a few months back to do a similar task. Maybe this will point you in the right direction.

What this does is it scans the sent mail...
Showing results 1 to 25 of 417

Forum Jump

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

Microsoft Access Help
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