Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
tvanstiphout's latest activity
T
tvanstiphout
replied to the thread
How do you know if an Error occured in your Stored Procedure from MS Access Pass-through Query?
.
I used a sproc without any error handling, just simply: select * from sometable where PK = 1 / 0; When executing that with a PT query...
Today at 4:46 AM
T
tvanstiphout
replied to the thread
Solved
Caching recordset in MS Access VBA
.
Hi Pat, I'm assuming this was directed at me, with regards to my testing of DAO caching. Re "If you have a large set of records and...
Wednesday at 1:22 AM
T
tvanstiphout
replied to the thread
Solved
Caching recordset in MS Access VBA
.
On the point of DAO caching, I did some research last night, and it is a real thing: I linked to a SQL Server table with Order Details...
Tuesday at 7:47 PM
T
tvanstiphout
replied to the thread
Handling Extensive Maths in MS Access
.
If that is how you operate: the hour is over, that data is never going to change anymore, let's calculate the numbers and report on them...
Sunday at 3:04 PM
T
tvanstiphout
replied to the thread
T-SQL Encryption function sought -
.
So true. I was tempted to suggest that in first instance :) We need to do everything possible to prevent a successful attack using...
Saturday at 6:09 PM
T
tvanstiphout
replied to the thread
Max Query Join
.
Can we assume the usual: 1, When you say ID field, it is a numeric field 2. The tables have a primary key 3. In the Relationships...
Saturday at 2:40 AM
T
tvanstiphout
replied to the thread
T-SQL Encryption function sought -
.
Yeah, either that, or totally overthinking it and calculating a hash over each physician's account info.
May 10, 2024
T
tvanstiphout
replied to the thread
SSMA_TimeStamp field never gets updated
.
Typically not. The field value is not updated client-side.
May 9, 2024
T
tvanstiphout
replied to the thread
Form Layout View takes forever to appear when Field List is included
.
Where are you seeing this slowness? How are you deducing this is related to "filtering through the entire list of every field in every...
May 9, 2024
T
tvanstiphout
replied to the thread
Microsoft References Needed For SendObject
.
What is the bigger picture? Did you switch to New Outlook perhaps, and that stopped SendObject from working?
May 9, 2024
T
tvanstiphout
replied to the thread
Performance Issues
.
Is it this issue? "SQL Server" ODBC Driver Slow in Monthly Channel (Fixed) (accessforever.org)
May 9, 2024
T
tvanstiphout
replied to the thread
Preventing System Admins From Accessing Database
.
> or accessing the stored procedures and functions Look up "WITH ENCRYPTION" clause in BOL.
May 8, 2024
T
tvanstiphout
replied to the thread
Preventing System Admins From Accessing Database
.
> you should be able to install an instance of a SQL Server with an SA account for which you have the credentials for Ha! There is the...
May 8, 2024
T
tvanstiphout
replied to the thread
Need help with formatting a row
.
Help files are mostly online nowadays. Search online for "VBA StrConv" and you should find the page you are looking for.
May 7, 2024
T
tvanstiphout
replied to the thread
Need help with formatting a row
.
That is called vbProperCase. You can use the StrConv function for that. Look it up in the Help file.
May 7, 2024
Home
Members
Top
Bottom