Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 71
Search took 0.07 seconds.
Search: Posts Made By: sonic8
Forum: Modules & VBA 10-09-2019, 08:09 AM
Replies: 12
Views: 201
Posted By sonic8
Re: Use records retrieved from SQL server in an Access Report

Try this as Recordsource of your report:
SELECT * FROM [dbo.Select_from_tableView] IN ODBC [ODBC;Driver=SQL Server;Server=PHE-3J021434H;Trusted_Connection=Yes;DATABASE=IPTTrackerBE;]; If only need...
Forum: Modules & VBA 10-01-2019, 11:44 PM
Replies: 4
Views: 120
Posted By sonic8
Re: VBE Plugins

Oh yes! - Carlos, the author of MZ-Tools, has written several texts on that topic.

The most interesting to you is probably HOWTO: Create an add-in for the VBA editor...
Forum: Forms 09-20-2019, 08:23 AM
Replies: 31
Views: 310
Posted By sonic8
Re: Requery just ONE row from sql server

A view is similar to a saved select-query in Access but it is stored in the SQL Server database. See CREATE VIEW...
Forum: Queries 09-19-2019, 11:50 PM
Replies: 3
Views: 164
Posted By sonic8
Re: SQL Update query error Cannot convert char value to money

This looks suspicious:
WHERE c.Total NOT IN (
SELECT [PurchaseOrderRef]
Forum: SQL Server 09-19-2019, 01:57 AM
Replies: 14
Views: 246
Posted By sonic8
Re: SQL Works As Query But Not View

Did I miss something? On which error?

The original "Object reference not set to an instance of an object." error is pretty much meaningless and irrelevant. It's either a small bug in SSMS or...
Forum: SQL Server 09-18-2019, 12:49 AM
Replies: 14
Views: 246
Posted By sonic8
Re: SQL Works As Query But Not View

Possibly nothing at all and it's just SSMS being stupid here for whatever reason.

CREATE VIEW yourViewName
select p.stateID ...

If this also fails, you should at least get a more...
Forum: SQL Server 09-17-2019, 10:04 AM
Replies: 18
Views: 247
Posted By sonic8
Re: Set Default Values

Of course it is:
ALTER TABLE yourTableName
ADD CONSTRAINT yourDefaultName
DEFAULT 'Clients:' + char(13) + char(10) + 'Servers:'
FOR yourFieldName ;

But, I think...
Forum: SQL Server 09-05-2019, 12:39 AM
Replies: 7
Views: 169
Posted By sonic8
Re: scalar function not working and can't debug

It is! - That was a stupid decision by Microsoft.

With the input of 'Hello Moto', your function should work if there is an BL_ID 'Hello' in tblBudgetlines. If you just input 'Hello' it will search...
Forum: SQL Server 09-05-2019, 12:11 AM
Replies: 7
Views: 169
Posted By sonic8
Re: scalar function not working and can't debug

Focus on this part:
SET @strInprocess = rtrim(LEFT(@strinput,CHARINDEX(' ',@strinput)))

Are you aware that this will set @strInprocess to an empty string if there is no space in @strinput?
Forum: Queries 08-30-2019, 06:27 AM
Replies: 16
Views: 248
Posted By sonic8
Re: Are UDFs in queries a bad idea?

Drawing attention to the bit in red, are UDFs in a querydef a bad idea?[/QUOTE]
I'd say you need to see this in its context. If you want to provide a wide variety of sample queries for different...
Forum: Forms 08-26-2019, 10:49 AM
Replies: 49
Views: 751
Posted By sonic8
Re: What makes good design?

Understatement! - You design looks very clean and modern and is certainly in the upper 10% of Access UI designs I've seen.
A small hint: The Top-Property of the controls in the two columns is not...
Forum: General 08-21-2019, 02:35 AM
Replies: 16
Views: 250
Posted By sonic8
Re: Get a weekdayname from a date

I'm afraid this is incorrect and if applied as @Ports did, it makes matters worse.

VBA will use the system date format setting for parsing strings into dates. Don't touch it and you will be fine!...
Forum: Microsoft Access User Groups 07-15-2019, 11:20 AM
Replies: 2
Views: 250
Posted By sonic8
NADD - Netherlands Access Developer Day - Sept. 14, 2019

On September 14th, 2019 the Netherlands Access Developer Day will take place in Aalsmeer, close to the beautiful city of Amsterdam in the Netherlands. Its one day packed with Microsoft Access...
Forum: Modules & VBA 07-08-2019, 06:47 AM
Replies: 5
Views: 166
Posted By sonic8
Re: ADO stream question

Two suggestions:
Try using the adLongVarBinary data type for the parameter.


Read the content from the stream into a byte array and try to use that for the parameter value. You can...
Forum: SQL Server 07-07-2019, 12:58 AM
Replies: 6
Views: 324
Posted By sonic8
Re: Porting Access VBA to VB.NET CLR Functions in SQL Server

That is actually a very good example for functionality that absolutely does make sense to implement with .Net inside SQL-Server.

However, there are also implementations of the Levenshtein...
Forum: SQL Server 07-06-2019, 02:40 AM
Replies: 6
Views: 324
Posted By sonic8
Re: Porting Access VBA to VB.NET CLR Functions in SQL Server

Just a few thoughts on this matter...

Don't go overboard with your enthusiasm about this new toy.

Keep in mind that, as you found out already, you will need to enable the CLR integration in...
Forum: Modules & VBA 06-30-2019, 05:29 AM
Replies: 20
Views: 475
Posted By sonic8
Re: how to reduce the code lines

I think using the column names as fallback for no filter is not very intuitive.

However, the real problem is that it's not going to work this way. The text delimiters must not be used around the...
Forum: Visual Basic 06-21-2019, 12:33 PM
Replies: 8
Views: 2,587
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...
Forum: Modules & VBA 06-20-2019, 06:13 AM
Replies: 10
Views: 307
Posted By sonic8
Re: Best solution to zip a file from VBA

The issue with the Windows built in ZIP functionality is that it is working asynchronously. The method to add a file to the zip returns immediately but the actual ZIP-process is not yet complete...
Forum: General 06-19-2019, 03:37 AM
Replies: 3
Views: 320
Posted By sonic8
Re: Documenting tables

Yes, the Description property of the table itself. - You might need to toggle the visibility of the Property Sheet of the table to see its properties.
Forum: Forms 06-10-2019, 06:00 AM
Replies: 12
Views: 241
Posted By sonic8
Re: Sync Scrolling on two datasheets

Have a look at my SyncScrollbars Example (https://codekabinett.com/page.php?Theme=10&Lang=2#Microsoft-Access-Sync-ScrollBars-Sample), I think that might help.
Forum: Modules & VBA 05-20-2019, 09:51 PM
Replies: 8
Views: 204
Posted By sonic8
Re: Do you use any plugin/add in for VBE?

I couldn't live without MZ-Tools (https://www.mztools.com/)!

I used to use the mossProcBrowser...
Forum: Queries 05-14-2019, 10:33 PM
Replies: 9
Views: 243
Posted By sonic8
Re: T-SQL via pass-through

Get rid of the GO (https://docs.microsoft.com/en-us/sql/t-sql/language-elements/sql-server-utilities-statements-go?view=sql-server-2017) and it should run as a Pass-Through-Query. - ADO should not...
Forum: Queries 04-22-2019, 01:06 AM
Replies: 84
Views: 1,206
Posted By sonic8
Re: How it Work function Rnd()?

Always remember to call Randomize before invoking Rnd for the first time. Otherwise you might be surprised by the results of Rnd not being as random as you'd expected.
Forum: Modules & VBA 04-14-2019, 06:06 AM
Replies: 12
Views: 910
Posted By sonic8
Re: How to evaluate a string containing column names?

If you carefully read your own statement above, it might lead you to a solution.

Create the conditional formatting (by code) on the form (or report) you are displaying. If the relevant fields...
Showing results 1 to 25 of 71

Forum Jump

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