Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 40
Search took 0.02 seconds.
Search: Posts Made By: CJ_London
Forum: Queries 10-28-2018, 04:46 PM
Replies: 8
Views: 285
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: 351
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: 254
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: 782
Posted By static
Forum: Queries 08-08-2017, 02:00 PM
Replies: 2
Views: 394
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,113
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: 775
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: 775
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: 775
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,023
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: 442
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: 928
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: 928
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: 668
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: 668
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: 644
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: 858
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: 1,961
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,696
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,152
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,778
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,702
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,516
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,303
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,747
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 07:27 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