Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 40
Search took 0.03 seconds.
Search: Posts Made By: CJ_London
Forum: Queries 10-28-2018, 04:46 PM
Replies: 8
Views: 286
Posted By June7
Re: display every date in a date range

Consider following found code, no guarantee can make practical use of:

PARAMETERS [StartDate] DateTime, [EndDate] DateTime;
SELECT DISTINCT Format([StartDate]-1+100*Abs([Hundreds].[id] Mod...
Forum: Modules & VBA 09-07-2018, 02:10 AM
Replies: 12
Views: 512
Posted By isladogs
Re: On Load Event of Report

You shouldn't need to do so. It may be that the event has got disconnected from the report. Check it exists in the report property sheet.

Or try moving that into a separate procedure and calling...
Forum: Forms 05-11-2018, 03:46 PM
Replies: 4
Views: 255
Posted By isladogs
Re: can anyone point me in the direction of some rich text formatter code?

I have 2 different rich text editors - simple & complex
I've adapted & attached the simple one so it runs with no app window (therefore no ribbon).
Forum: Forms 10-26-2017, 11:02 PM
Replies: 11
Views: 887
Posted By static
Forum: Queries 08-08-2017, 02:00 PM
Replies: 2
Views: 395
Posted By plog
Re: Needing the expression/Formula to turn Seconds

1407182400 is 8/4/2014 20:00

It's the number of seconds his date/time occured after 1/1/1970 00:00 (http://www.unixtimestamp.com/).

So, to convert that to a date/time you would use the DateAdd...
Forum: Code Repository 04-18-2017, 02:17 AM
Replies: 1
Views: 4,242
Posted By isladogs
Close All VBE Windows

I use the following function to close all VBE windows
Very useful when so many windows are left open you can't find anything.
It also significantly speeds up loading the VBE editor if it doesn't...
Forum: Modules & VBA 01-26-2017, 08:05 AM
Replies: 18
Views: 807
Posted By static
Re: access the form layouts properties

You need to move the first (top or left most) control depending on the layout type.
Forum: Modules & VBA 01-25-2017, 01:09 PM
Replies: 18
Views: 807
Posted By Uncle Gizmo
Re: access the form layouts properties

By the way, my experience of searching Safari for information related to MS Access isn't particularly good when trying to find something which is a little out of the ordinary. I have more success...
Forum: Modules & VBA 01-25-2017, 12:57 PM
Replies: 18
Views: 807
Posted By The_Doc_Man
Re: access the form layouts properties


You probably knew most of this, but I'll do a mini-brain-dump (from my mini-brain) in hopes that something useful to you falls out. And also hope that nothing useful to me falls out and hits...
Forum: Theory and practice of database design 01-04-2017, 08:15 AM
Replies: 14
Views: 3,024
Posted By The_Doc_Man
How do I know if I have bad performance?

CJ London's posts inspired me. Those of you who know me know this could be a good thing or a bad thing. I'll try to keep it straight-forward.

To understand and properly analyze whether you are...
Forum: Modules & VBA 11-11-2016, 08:28 AM
Replies: 10
Views: 443
Posted By static
Re: If Statement for numbers

Function hasNumber(str As String) As Boolean
hasNumber = str Like "*[0-9]*"
End Function

might be quicker.
Forum: General 10-28-2016, 03:03 AM
Replies: 5
Views: 992
Posted By Minty
Re: Can't find laccdb file, unable to copy open db

I ran into similar issues a while ago after some windows updates. In the end I built a Developer Database that lists my databases and displays last open time, live version numbers, current dev...
Forum: General 10-28-2016, 02:56 AM
Replies: 5
Views: 992
Posted By sneuberg
Re: Can't find laccdb file, unable to copy open db

I'm assuming you're only having this problem with one of your databases. If that's the case do you have the same problem with a copy of the database? I assume you can copy it when you are out of...
Forum: Modules & VBA 09-21-2016, 04:34 PM
Replies: 4
Views: 680
Posted By jdraw
Re: global form error handler


There is one of these Global Error handlers that gets referenced from time to time. (vbWatchDog)
It is from EverythingAccess by Wayne Phillips. More info at his site...
Forum: Modules & VBA 09-21-2016, 04:06 PM
Replies: 4
Views: 680
Posted By gemma-the-husky
Re: global form error handler

maybe the error code is a feature of the application object, or the dbengine, or something like that.

eg https://support.microsoft.com/en-us/kb/186063

not sure where to look, though. maybe it's...
Forum: Reports 08-14-2016, 07:18 PM
Replies: 4
Views: 661
Posted By arnelgp
Re: columnhidden on a report

if the format of your report is columnar, just edit your report. select all the column heading and the textboxes/comboboxes at the detail sections. then on the ribbon->Arrange, select Tabular. this...
Forum: Modules & VBA 03-01-2016, 08:11 AM
Replies: 5
Views: 863
Posted By The_Doc_Man
Re: DateDiff Problem

The best way to understand the way Access handles dates/times is to realize that it is a "synthetic" variable as opposed to a native data type. Date/time data types are actually casts (a.k.a....
Forum: Queries 01-31-2016, 08:39 PM
Replies: 11
Views: 2,126
Posted By arnelgp
Re: Query to fill in missing dates

this is an example of cartesian by product.

create 3 tables:
tblDay, fields: DayNo (Number, Byte)
tblMonth, fields: MonthNo (Number,. Byte)
tblYear, field: YearNo (Number, Integer)

Forum: Code Repository 08-03-2015, 02:31 PM
Replies: 0
Views: 4,760
Posted By Uncle Gizmo
7 ways to do sequential numbering

Very interesting and informative post here:-

Forum: Modules & VBA 06-04-2015, 06:27 AM
Replies: 21
Views: 1,155
Posted By vbaInet
Re: Regex and dates

Ah ok, I see the problem, you're using the wrong collection. What you want is the MatchCollection as in my original code. And also the Test() part isn't necessary because there's no pattern to test...
Forum: Modules & VBA 05-22-2015, 07:17 PM
Replies: 3
Views: 1,783
Posted By vbaInet
Re: vba to populate windows task manager

Hey CJ, the return value is the process ID.

If you want to see the command prompt window after the command executes you can do:

shell "cmd /k schtasks /Query /FO csv"

You would most likely...
Forum: SQL Server 05-18-2015, 12:53 PM
Replies: 2
Views: 3,849
Posted By Rx_
Talking SQL Server Linked Server to Oracle slow --> OpenQuery Solution

This totally surprised me. Just wondering if anyone else had this experience?

Set up the Oracle ODBC service and created Oracle Linked Servers (read-only) on the MS SQL Server 2012 database. Then,...
Forum: Modules & VBA 03-05-2015, 05:07 AM
Replies: 6
Views: 1,558
Posted By James Dudden
Re: how to detect if user has a touchscreen

Would it help to know the screen size?
If so this link should help http://stackoverflow.com/questions/11843310/how-to-retrieve-screen-size-resolution-in-ms-access-vba-to-re-size-a-form
Forum: Forms 02-19-2015, 10:02 AM
Replies: 21
Views: 1,316
Posted By spikepl
Re: How to Allow tables to be filtered in Runtime

It seems to me that you are making something exceedingly complex.

You can abuse the system a bit - you'd have to test whether it works in Runtime. The subform control normally houses a form, but...
Forum: Modules & VBA 02-18-2015, 10:26 AM
Replies: 14
Views: 2,886
Posted By MarkK
You can programmatically modify the LinkMaster...

You can programmatically modify the LinkMaster and LinkChildFields properties based on activity in the combos. Like, . . .
sub combo2_click
with sfm
if not isnull(me.combo2) then
Showing results 1 to 25 of 40

Forum Jump

All times are GMT -8. The time now is 05:12 PM.

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