Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 57
Search took 0.03 seconds.
Search: Posts Made By: theDBguy
Forum: Queries 11-14-2019, 01:42 PM
Replies: 29
Views: 260
Posted By bob fitz
Re: Circular reference when using filed name in IIF query

Try:
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: 273
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: 154
Posted By Gasman
Re: 64bit office, appactivate fails

Use the full name

https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/appactivate-statement
Forum: General 11-02-2019, 09:49 AM
Replies: 2
Views: 102
Posted By jdraw
Re: 1001 * dbg

Congrats DBG!!
Forum: General 11-02-2019, 09:45 AM
Replies: 2
Views: 102
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: 133
Posted By Gasman
Re: Add a file to the "Recent Items" listing in Outlook Attachment

theDBguy,

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: 225
Posted By Gasman
Re: Export data from Access to Excel then open a macro

PMFJI,

Have you tried something along the lines of


objXLS.run Prep_R


https://access-excel.tips/run-excel-macro-from-access-vba/
Forum: General 10-12-2019, 10:02 PM
Replies: 26
Views: 417
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: 758
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: 758
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: 160
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: 168
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: 167
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: 167
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: 167
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: 234
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: 281
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: 180
Posted By otto
Solved! How to use Docmd.SetParameter ?

Hello,


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. :)

Bye
Forum: Code Repository 08-28-2019, 07:49 AM
Replies: 0
Views: 403
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: 272
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: 197
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

https://www.access-programmers.co.uk/forums/showthread.php?t=305659
Forum: Queries 07-08-2019, 04:10 AM
Replies: 9
Views: 211
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...
Forum: Visual Basic 06-21-2019, 12:33 PM
Replies: 8
Views: 2,617
Posted By sonic8
Re: private function that returns an array

A() is an array without any element in it. You cannot "populate" it before resizing it first. Otherwise there is no "space" in it where you could put anything.
Use ReDim...
Showing results 1 to 25 of 57

 
Forum Jump



All times are GMT -8. The time now is 11:48 PM.


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