Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 60
Search took 0.31 seconds.
Search: Posts Made By: smig
Forum: General 10-12-2019, 10:31 AM
Replies: 10
Views: 202
Posted By isladogs
Re: remove the "Unknown Publisher" security warning

Are you distributing your files as ACCDE files or using a professional installer package?
If the latter, you can include script to make the install location trusted. You can also purchase a...
Forum: Modules & VBA 10-08-2019, 01:08 PM
Replies: 23
Views: 308
Posted By isladogs
Re: look for file update over the internet

To answer some of the recent points i need to do a bit of a preamble

My earlier conditional compilation code written around 2011-14 was both over-complex but also in the wrong order. At the time I...
Forum: Modules & VBA 10-08-2019, 12:53 PM
Replies: 23
Views: 308
Posted By theDBguy
Re: look for file update over the internet

Sorry about that. But the way I read it, Win64 does reflect if the Office environment is 32- or 64-bit. For example, let's take a look at the Conclusion paragraph of this article...
Forum: Modules & VBA 10-08-2019, 11:30 AM
Replies: 23
Views: 308
Posted By theDBguy
Re: look for file update over the internet

Oh, I see... For that, and Colin can correct me if I am wrong, but I think you may have to go to the Registry to find out. Check out Colin's demo on finding out the version and bitness...
Forum: Modules & VBA 10-07-2019, 10:11 AM
Replies: 23
Views: 308
Posted By isladogs
Re: look for file update over the internet

Hi smig/DBGuy
You're both right!

The code was written in about 2012 when most of my clients were still using A2007. With the advent of A2010 (32-bit & 64-bit), VBA7 was introduced and I started...
Forum: Modules & VBA 10-07-2019, 08:15 AM
Replies: 23
Views: 308
Posted By theDBguy
Re: look for file update over the internet

Hi. I believe Isladog's approach is just trying to cover all bases. It may not be required for some situations, but it may be necessary for others. For example, do you have any Access 2007 or earlier...
Forum: Modules & VBA 10-07-2019, 02:29 AM
Replies: 23
Views: 308
Posted By isladogs
Re: look for file update over the internet

You're in luck!
See my example app - Create a web version checker (https://www.access-programmers.co.uk/forums/showthread.php?t=293970)
Forum: Forms 10-06-2019, 06:30 AM
Replies: 6
Views: 95
Posted By theDBguy
Re: Read the Conditional Formatting colors ?

Hi. Check out the FormatCondition Object (https://docs.microsoft.com/en-us/office/vba/api/access.formatcondition).
Forum: Modules & VBA 06-11-2019, 04:27 PM
Replies: 6
Views: 678
Posted By HiTechCoach
Re: Create and edit google calendar events

I do Google Calendar interfacing from my apps, including Access..

I first tried interfacing with with Google Calendar writing only VBA code. Not easy and takes a lot of time to learn.

I found...
Forum: Modules & VBA 06-11-2019, 04:16 AM
Replies: 6
Views: 678
Posted By theDBguy
Re: Create and edit google calendar events

Hi. Take a look at this other discussion (https://www.utteraccess.com/forum/index.php?showtopic=2041518).
Forum: Modules & VBA 05-23-2019, 11:50 AM
Replies: 2
Views: 151
Posted By theDBguy
Re: Select case Time() ?

How about?
Select Case True
Case Time()<#12:00 PM#
'morning
Case Time() Between #12:00 PM# And #6:00 PM#
'afternoon
...and so on
End SelectHope it helps...
Forum: Modules & VBA 05-23-2019, 11:48 AM
Replies: 2
Views: 151
Posted By Gasman
Re: Select case Time() ?

I use this in my Outlook

iTime = Val(Format(Now(), "hh"))

' Quit if not a mail item
If TypeName(Item) <> "MailItem" Then
Exit Sub
End If

Select Case iTime
Forum: General 10-28-2018, 10:16 PM
Replies: 20
Views: 511
Posted By June7
Re: Changes to BE table won't be represented on FE

Review http://accessjitsu.com/2017/01/25/microsoft-access-vba-to-compact-and-repair/
Forum: Modules & VBA 10-27-2018, 07:10 AM
Replies: 6
Views: 175
Posted By CJ_London
Re: reading InputMask property of a field won't work

so far as I know there is no other way.
Forum: Modules & VBA 10-27-2018, 01:47 AM
Replies: 6
Views: 175
Posted By CJ_London
Re: reading InputMask property of a field won't work

I think you will find the property does not exist until you actually use it. Many properties work this way
Forum: Modules & VBA 10-27-2018, 01:18 AM
Replies: 5
Views: 182
Posted By arnelgp
Re: Access still looking for deleted table :(

in the future, if you are unable to compact your db, try changing this code to:

If Len(tdf.Connect) > 0 And Left(tdf.Name , 1) <> "~" Then
...
...
Forum: Modules & VBA 10-27-2018, 12:44 AM
Replies: 5
Views: 182
Posted By isladogs
Re: Access still looking for deleted table :(

Compacting may remove all traces of it from Access.
If not you can remove the legacy object from the system table MSysObjects by an indirect method.
Have a look at...
Forum: Modules & VBA 10-27-2018, 12:38 AM
Replies: 5
Views: 182
Posted By arnelgp
Re: Access still looking for deleted table :(

the tabledef of the deleted table is still exists with prefix "~". so test the first string of the tabledef name if it is "~" (Left(tdt, 1)="~"), and ignore it inside the If clause.
Forum: Modules & VBA 12-21-2016, 06:56 AM
Replies: 12
Views: 814
Posted By The_Doc_Man
Re: How to scramble words with random characters ?

Ah, but you do. You just don't realize that you do.

First, what is a string? Just a sequence of individual characters associated with each other by being part of a string variable. Each...
Forum: Modules & VBA 12-02-2015, 04:40 AM
Replies: 7
Views: 889
Posted By gemma-the-husky
Re: Darken color

took ages to find where I had put it ....


Function analyseRGB(col As Long) As String
Dim r As Long
Dim g As Long
Dim b As Long
Dim q As Long
r = col Mod 256
q = Int(col / 256)
Forum: Modules & VBA 11-12-2015, 03:04 PM
Replies: 36
Views: 2,469
Posted By jdraw
Re: Alter Table Alter Column help

I have created a table, called Tables_indexes.
I process all tables in the current database.
If the table has 1 or more indexes, I record the name and the properties of that index.
An index name...
Forum: Modules & VBA 11-11-2015, 02:09 PM
Replies: 36
Views: 2,469
Posted By jdraw
Re: Alter Table Alter Column help

smig,

I'm sure you have resolved the issue. But for anyone looking at the thread I did create a routine base on the M$oft link.

For what it's worth, I took one of my existing tables "tblBio"...
Forum: Modules & VBA 11-08-2015, 06:26 AM
Replies: 36
Views: 2,469
Posted By jdraw
Re: Alter Table Alter Column help

There are details here (https://msdn.microsoft.com/en-us/library/office/ff845002.aspx)
Forum: Modules & VBA 11-02-2015, 04:32 AM
Replies: 46
Views: 2,761
Posted By speakers_86
Re: How to hide built in ribbons

Run this once from the immediate window:
Public Sub CopyCutPaste()
Dim cmbRC As CommandBar
Dim cmbButtonCopy As CommandBarButton
Dim cmbButtonCut As CommandBarButton
Dim...
Forum: Sample Databases 10-31-2015, 12:15 AM
Replies: 0
Views: 6,869
Posted By speakers_86
Dynamic Ribbon Example

This shows you the basics of dynamic ribbons.
Showing results 1 to 25 of 60

 
Forum Jump



All times are GMT -8. The time now is 09:02 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