Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 266
Search took 0.02 seconds.
Search: Posts Made By: sonic8
Forum: General Today, 03:28 AM
Replies: 18
Views: 249
Posted By sonic8
Re: Useful links

I saw, you have a section for video tutorials.
You should add the LearnAccessByCrystal YouTube Channel (https://www.youtube.com/user/LearnAccessByCrystal) there. Crystal has some very good tutorials...
Forum: SQL Server 11-08-2019, 07:08 AM
Replies: 5
Views: 83
Posted By sonic8
Re: T-SQL to copy contents of OutLook Folder

Nope! - T-SQL runs inside SQL Server and there is (almost) no option to communicate to the outside world.
The options that do exist (xp_cmdShell, CLR-Integration) are usually restricted.
Forum: General 11-02-2019, 09:46 AM
Replies: 4
Views: 174
Posted By sonic8
Re: Link scrolling of 2 Web Browser Controls

Well, you might be right. The webbrowser control has an HWND property, which should be the window handle of the control. But this property does not return any value when the control is used on an...
Forum: General 11-01-2019, 10:52 AM
Replies: 11
Views: 349
Posted By sonic8
Re: Access: The DB that will not die

If Access had the additional features you wished for, you would also need an additional skillset to handle them properly.
Forum: General 11-01-2019, 06:30 AM
Replies: 11
Views: 349
Posted By sonic8
Re: Access: The DB that will not die

They did that already!

The special Access backend type you need to use for that is called SQL Server!


No, seriously, Access´ strength (and gravest weakness) is that is just file based. So,...
Forum: General 10-29-2019, 03:09 AM
Replies: 4
Views: 174
Posted By sonic8
Re: Link scrolling of 2 Web Browser Controls

Check out my Sync-ScrollBars-Sample. (https://codekabinett.com/page.php?Theme=10&Lang=2#Microsoft-Access-Sync-ScrollBars-Sample)It is intended to sync the scrollbars of two forms, but maybe it also...
Forum: Forms 10-19-2019, 08:56 AM
Replies: 83
Views: 1,663
Posted By sonic8
Re: MS Access: custom control built in another language

That info is out of date. The 64-bit Common Controls were released about two years ago with Office 365 Version 1707.
Forum: Forms 10-18-2019, 11:34 AM
Replies: 83
Views: 1,663
Posted By sonic8
Re: MS Access: custom control built in another language

No, you can add a single form to any number of forms as a subform. You even add it multiple times to the same form.




Possibly yes. I created ActiveX-Controls in .Net to be used in Access...
Forum: Modules & VBA 10-17-2019, 05:00 AM
Replies: 5
Views: 127
Posted By sonic8
Re: Obtaining query names in ADP file

I've got no idea why linking the views would produce such an error message.
I suggest, you further investigate that on your end and come back with the steps to reproduce the issue, if it persists.
Forum: Modules & VBA 10-17-2019, 02:22 AM
Replies: 5
Views: 127
Posted By sonic8
Re: Obtaining query names in ADP file

Please provide more information on what you tried.

The creation of a table (for the linked view) should only happen in your local Access file where there are no permissions required for this.
Forum: Modules & VBA 10-17-2019, 01:25 AM
Replies: 5
Views: 127
Posted By sonic8
Re: Obtaining query names in ADP file

Don't!
Leave the "queries", at least the views on the SQL Server, where they are. Just link to the views in your new Access database. This will result in less work and better performance.
Forum: General 10-15-2019, 01:06 PM
Replies: 7
Views: 182
Posted By sonic8
Re: Access front end -to- SQL back end

Hard to say without seeing the "simple query". If the query is actually simple, then it should also run very fast with a SQL Server backend on a remote network.

Can you post a sample of your...
Forum: Modules & VBA 10-09-2019, 08:09 AM
Replies: 12
Views: 240
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-09-2019, 04:24 AM
Replies: 12
Views: 240
Posted By sonic8
Re: Use records retrieved from SQL server in an Access Report

I think, you can only set the Recordset of a report in an ADP-Application.



Minty's suggestion is probably the best approach to solve this.
Forum: Modules & VBA 10-08-2019, 01:03 AM
Replies: 10
Views: 181
Posted By sonic8
Re: Debugging step into F8 not working

Check if the option "Use Access Special Keys" is enabled in the settings for the current database. Otherwise [F8] will not work.
Forum: Modules & VBA 10-01-2019, 11:44 PM
Replies: 4
Views: 140
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: Modules & VBA 09-25-2019, 11:15 PM
Replies: 5
Views: 119
Posted By sonic8
Re: problem with odbc connection or vba code

ODBC-Direct-Workspaces have been removed from DAO with Acccess 2007 and the corresponding upgade to the ACE-Library for DAO. They would have allowed you to use DAO to do the stuff you try to do. Now...
Forum: General 09-25-2019, 11:10 PM
Replies: 9
Views: 303
Posted By sonic8
Re: NOTICE TO ALL MEMBERS : Site Issues

Not sure if is related, but I just noticed that several of my profile settings were set to values I most likely did not set myself. E.g. Private Messaging was disabled and I don't think I did this...
Forum: Forms 09-23-2019, 11:13 PM
Replies: 31
Views: 358
Posted By sonic8
Re: Requery just ONE row from sql server

Interesting idea. That simulates what Access/ODBC does automatically when using a linked table (or view) with a standard query in Access.




I agree on you not needing a view. - When I...
Forum: Forms 09-20-2019, 08:23 AM
Replies: 31
Views: 358
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: SQL Server 09-20-2019, 05:48 AM
Replies: 4
Views: 132
Posted By sonic8
Re: Sql server relations in FE

No. The relationships in the frontent are pretty much irrelevant.
Not sure, if you can create them at all, but it won't do any more than pre-linking tables in query design view.
Forum: Forms 09-20-2019, 05:43 AM
Replies: 31
Views: 358
Posted By sonic8
Re: Requery just ONE row from sql server

I guess, it's not going to work with a Pass-Through-Query.
Create a view with the main SQL statement from the Pass-Through-Query, link the view to Access and use that instead. A Refresh should work...
Forum: Queries 09-19-2019, 11:50 PM
Replies: 3
Views: 175
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: 287
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: General 09-19-2019, 01:47 AM
Replies: 9
Views: 303
Posted By sonic8
Re: NOTICE TO ALL MEMBERS : Site Issues

+1 - Happend multiple times to me yesterday.
Showing results 1 to 25 of 266

 
Forum Jump



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