Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 58
Search took 0.02 seconds.
Search: Posts Made By: theDBguy
Forum: Reports 11-25-2019, 11:33 AM
Replies: 35
Views: 328
Posted By Gasman
Forum: Queries 11-14-2019, 01:42 PM
Replies: 29
Views: 330
Posted By bob fitz
Re: Circular reference when using filed name in IIF query

SELECT YourTableName.Mobile AS M, YourTableName.PersonalCellular AS PC, IIf(IsNull([M]),[PC],[M]) AS Mobile
FROM YourTableName;
Forum: General 11-12-2019, 10:13 AM
Replies: 26
Views: 301
Posted By isladogs
Re: Import/Export Data Tasks

For info I've just uploaded a new thread to the repository with code to view & edit the XML in the import/export data tasks: ...
Forum: Modules & VBA 11-04-2019, 10:42 AM
Replies: 7
Views: 205
Posted By Gasman
Re: 64bit office, appactivate fails

Use the full name

Forum: General 11-02-2019, 09:49 AM
Replies: 2
Views: 132
Posted By jdraw
Re: 1001 * dbg

Congrats DBG!!
Forum: General 11-02-2019, 09:45 AM
Replies: 2
Views: 132
Posted By isladogs
1001 * dbg

As many of you will have noticed the DBGuy not only posts good advice he also posts a lot of it...
In the past 28 days he has amassed a mind boggling 1001 posts.
Forum: Modules & VBA 10-27-2019, 06:44 AM
Replies: 4
Views: 160
Posted By Gasman
Re: Add a file to the "Recent Items" listing in Outlook Attachment


FYI the o/p had crossposted at https://www.mrexcel.com/forum/microsoft-access/1113343-add-file-recent-items-listing-outlook-attachment.html

However he did mention your solution.
Forum: Excel 10-24-2019, 08:31 AM
Replies: 14
Views: 275
Posted By Gasman
Re: Export data from Access to Excel then open a macro


Have you tried something along the lines of

objXLS.run Prep_R

Forum: General 10-12-2019, 10:02 PM
Replies: 26
Views: 430
Posted By Pat Hartman
Re: strDocName Error

Let me try again.

Select * from yourtable where somefield = null ---- will NEVER return any rows regardless of how many instances of somefield are actually null.

Select * from yourtable where...
Forum: Queries 10-07-2019, 07:41 AM
Replies: 31
Views: 767
Posted By isladogs
Re: Appending Table with a Picture

Post #18 was moderated. Posting this to trigger email notifications
Forum: Queries 10-07-2019, 07:36 AM
Replies: 31
Views: 767
Posted By Gasman
Re: Appending Table with a Picture

It does not theDBguy, it merely mentions it and the download is clearly shown on the left.
The code for the demo is also available in the forms.:confused:
Forum: General 10-04-2019, 09:30 AM
Replies: 3
Views: 162
Posted By arnelgp
Free Programming E-Books

to all of you out there!
want to download Free programming E-books
including VBA, SQL,Algorithms, MSSL, MySQL, etc.

follow this link: https://goalkicker.com/
Forum: Queries 09-19-2019, 09:49 AM
Replies: 7
Views: 169
Posted By MajP
Re: Filter through text box

I updated my Find as you type (FAYT) classes to turn any form into a FAYT with a single line of code. There are some features to allow you to define the type of search and to search and specified...
Forum: Modules & VBA 09-12-2019, 08:25 AM
Replies: 11
Views: 171
Posted By isladogs
Re: how to prevent access VBA from opening all classes

Easily done!
I have an autokeys macro that does exactly that.
I use CTRL+SHIFT+X but you can use anything you like.
Take care not to overwrite an existing Access keyboard shortcut
Forum: Modules & VBA 09-12-2019, 07:39 AM
Replies: 11
Views: 171
Posted By isladogs
Re: how to prevent access VBA from opening all classes

See this link for some code that may speed things up for you :
Close all VBE windows (https://www.access-programmers.co.uk/forums/showthread.php?t=293239)
Forum: Modules & VBA 09-12-2019, 07:21 AM
Replies: 11
Views: 171
Posted By Hello1
Re: how to prevent access VBA from opening all classes

Alright, I found it out. After closing all the class objects, I just had to do a compile :banghead:

After that when I relaunch the .accdb the class objects dont open
Forum: SQL Server 09-05-2019, 08:18 AM
Replies: 4
Views: 257
Posted By Minty
Re: Line numbers in error messages

If that is in the query window in SSMS you can normally double click on the error and it will take you to the offending line ?

Caveat : This may be version dependent
Forum: Forms 09-04-2019, 07:52 AM
Replies: 20
Views: 282
Posted By Mark_
Re: Single Field Form - Best Practice

Having run into it lately, if you DO go with image files your best if they are in .PNG format. I've had issues with non-PNG images not appearing on reports, even if they do show on an image control...
Forum: Modules & VBA 08-29-2019, 02:50 PM
Replies: 7
Views: 204
Posted By otto
Solved! How to use Docmd.SetParameter ?


nice to hear that topic wasn't boring. I should have asked the question 8 hours ago. Then I wouldn't have lost so much time. Next time I know where I can get help. :)

Forum: Code Repository 08-28-2019, 07:49 AM
Replies: 0
Views: 490
Posted By isladogs
Normalise Spreadsheet Data Easily For Access Using Excel Power Query

When faced with normalising spreadsheet data for use in Access, various solutions are available often involving complex user defined functions.

By contrast, a very simple approach was recently...
Forum: General 08-16-2019, 04:09 AM
Replies: 2
Views: 117
Posted By isladogs
DBG's Post Count

Just a quick post to observe that, to my surprise, I've just 'snuck past' the DBGuy's top listing of post counts for the last 7 days.
It won't last and indeed will probably not be true by the time...
Forum: Queries 08-13-2019, 09:39 PM
Replies: 12
Views: 292
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: General 07-19-2019, 01:35 PM
Replies: 6
Views: 200
Posted By sxschech
Backup a Backend - enhanced

I saw theDBGuy's link post #2 to backup a backend. https://www.access-programmers.co.uk/forums/showthread.php?t=305939&highlight=backup
Good timing as I was about to add a backup option to one of...
Forum: Forms 07-18-2019, 09:50 AM
Replies: 3
Views: 104
Posted By CJ_London
Re: Yes/No field

take a look at this link which implements DBGuys suggestion

Forum: Queries 07-08-2019, 04:10 AM
Replies: 9
Views: 222
Posted By CJ_London
Re: Multiple Appends

no need to create a table of dates - you can do it in a query.

create a table which contains one numeric field and populate 10 records with the values 0 to 9

in this example the table is called...
Showing results 1 to 25 of 58

Forum Jump

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