Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 39
Search took 0.02 seconds.
Search: Posts Made By: sonic8
Forum: Modules & VBA 09-17-2019, 01:36 PM
Replies: 23
Views: 489
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: Tables 09-11-2019, 12:43 PM
Replies: 17
Views: 325
Posted By Mark_
Re: Identify and rename MS Access latest table - SQL

This may sound like an odd question, but why do you need to rename a table? From the format, it looks like you are saving data as part of a table name.
Forum: Reports 09-05-2019, 01:00 AM
Replies: 16
Views: 423
Posted By isladogs
Re: Access Rich-/HTML-Textbox does indents bulleted lists with wrapped text incorrect

There is another very powerful approach you should consider.
The hidden undocumented Wizhook function includes a TwipsFromFont property which you can use to get the exact height or width of any...
Forum: Politics & Current Events 08-28-2019, 09:26 AM
Replies: 16
Views: 382
Posted By CJ_London
Re: Queen Elizabeth to be evacuated as Brexit riots break out in London


regret to advise you she died over 400 years ago - https://www.google.co.uk/search?client=opera&q=when+did+queen+elizabeth+the+first+die&sourceid=opera&ie=UTF-8&oe=UTF-8
Forum: Reports 08-19-2019, 03:12 PM
Replies: 16
Views: 423
Posted By CJ_London
Re: Access Rich-/HTML-Textbox does indents bulleted lists with wrapped text incorrect

Only thing I can suggest is to do some string manipulation. Using VBA, parse or split the string on "<ul>" (I think), determine how many characters can be shown on the first row and <blockquote> to...
Forum: SQL Server 07-06-2019, 03:52 AM
Replies: 6
Views: 330
Posted By Galaxiom
Re: Porting Access VBA to VB.NET CLR Functions in SQL Server

I started translating Damearu-Levenshtein Distance (https://www.access-programmers.co.uk/forums/showpost.php?p=1258195&postcount=10) function to SQL then discovered TSQL doesn't have arrays which...
Forum: Modules & VBA 07-01-2019, 05:21 AM
Replies: 20
Views: 475
Posted By The_Doc_Man
Re: how to reduce the code lines

If you look, Sonic8, my first sentence was about how you want clarity, not brevity, even though I had a suggestion for reducing typing.
Forum: Modules & VBA 06-30-2019, 03:38 AM
Replies: 20
Views: 475
Posted By jdraw
Re: how to reduce the code lines

For your own code readability and for anyone who may maintain the code, better to assign meaningful names to your controls. Child85 and text5, text25 don't convey any application meaning...
Forum: SQL Server 05-04-2019, 04:29 PM
Replies: 7
Views: 318
Posted By Galaxiom
Re: SQL Server Security 101

SQL Server has very fine grained security on all objects right down to individual table columns with control over allowed actions (Update, Insert etc).

If you want to protect particular records in...
Forum: Other Software 05-02-2019, 04:37 AM
Replies: 4
Views: 314
Posted By Uncle Gizmo
Re: Something about "GIT" I'm not getting?

I've posted a link to your article on my Facebook group "Nifty Access Hints and Tips" = https://www.facebook.com/groups/MS.Access.Hints.And.Tips/permalink/10156811524890845/ = I don't know if you...
Forum: General 03-25-2019, 05:09 AM
Replies: 8
Views: 364
Posted By The_Doc_Man
Re: Creating a Cloud Based Program

Been too long since I studied the nomenclature, sonic8. I won't argue the corrections. However, I will clarify that UDP doesn't involve persistent sessions involving the strict sequence numbering...
Forum: General 02-26-2019, 08:39 AM
Replies: 14
Views: 353
Posted By MajP
Re: Moving from x32 to x64

You might want take note of my text on Windows API in 64-bit-VBA for further reference

I strongly recommend everyone read the article referenced...
Forum: Modules & VBA 02-25-2019, 07:37 PM
Replies: 2
Views: 169
Posted By sumdumgai
Re: How to change path in Saved Import Spec

Would something like this be sufficient and effective:

With CurrentProject.ImportExportSpecifications("spec name")
startpos = InStr(.XML, "Path = ") + Len("Path = ") + 1
Forum: Forms 01-30-2019, 08:17 AM
Replies: 7
Views: 85
Posted By MajP
Re: Continuous Forms - Different Properties For Each Row

Seems to work
I have a field called Vals with a textbox txtVals
I have a field called Precision with how many decimal places

I have calculated txtbox called txtCalcVals with a control source of ...
Forum: General 11-11-2018, 01:14 AM
Replies: 25
Views: 575
Posted By Galaxiom
Re: Books don't alway tell you everything!

Why not use the OpenRecordset's Option parameter dbAppendOnly ?
Forum: Modules & VBA 09-23-2018, 08:19 AM
Replies: 5
Views: 164
Posted By MajP
Re: vba field validation

I would say 95% of validation is done in the before update and not the after update. The before update allows you to cancel and correct a mistake. With the after update the value is committed to...
Forum: Queries 09-13-2018, 02:27 PM
Replies: 3
Views: 124
Posted By Galaxiom
Re: How can you filter a [data + time] field by just date?

This will perform vastly better than applying a function to every value in the table:
WHERE [DateTimeField] >=Date() AND [DateTimeField] < Date() + 1
Forum: Tables 09-13-2018, 07:31 AM
Replies: 14
Views: 360
Posted By The_Doc_Man
Re: Indexing

The idea of to index or not to index (aye, THAT is the question) is that you need to know if there is a big enough benefit to outweigh the increased maintenance costs associated with the index that...
Forum: Code Repository 09-08-2018, 08:42 PM
Replies: 0
Views: 1,547
Posted By NauticalGent
Changing Saved Import XML

The need for Access and Outlook to talk to each other is inevitable. There are plenty examples on the web if all you are doing is working with your own e-mail account, but when you need to work with...
Forum: General 07-20-2018, 04:54 AM
Replies: 3
Views: 2,121
Posted By isladogs
Re: Using Mod properly

True ... for even numbers ... but in post 1, it specifies odd numbers
Forum: Modules & VBA 07-16-2018, 04:07 AM
Replies: 14
Views: 488
Posted By MajP
Re: 3 FIELD should be unique

I think you need to reread the OP's post. There is no way to make a "conditional" key where you can duplicate any 3 of 5.

Can you provide an example? Are you really...
Forum: Forms 07-03-2018, 07:44 PM
Replies: 8
Views: 403
Posted By Pat Hartman
Re: Recommendation - book dedicated to forms

I did a quick search on Amazon and came up with these two.
Forum: Tables 06-22-2018, 12:17 PM
Replies: 5
Views: 239
Posted By MarkK
No. Cascade Update does not inform the child...

No. Cascade Update does not inform the child record, upon creation, what the ParentID is. On creation in table B, the ParentID still needs to be specifically provided at creation time. Once the...
Forum: Theory and practice of database design 06-22-2018, 06:54 AM
Replies: 60
Views: 9,354
Posted By NauticalGent
Re: Why indexing is important for good performance

A video for those of us who don’t like to read!

Forum: Site Suggestions 06-08-2018, 05:49 AM
Replies: 41
Views: 2,409
Posted By AccessBlaster
Re: Header area - feedback please

I like the new logo, the three tabs look outdated.
Showing results 1 to 25 of 39

Forum Jump

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