Search results for query: *

Thanks PHV, that did it!

Sorry to seem over simplistic but why not just add 1 to the value when updating in the after update event?

I have an developed an access database (front end to SQL Server) that was developed to facilitate operations for a company that no longer exists. I am using the database for a new company but am required to remove references to the old company. I have been able to do this in all but one place...

I am using native asymmetric encryption with SQL Server Express. When I backup the DB on one server and move it to another I can access my encrypted data columns but only if I open the Master Key with the password every session. This does not occur if I restore to the original server, the...

How does one schedule a SQL DB backup to occur on a regular periodicity without human intervention?

Does anyone know of a Rules Engine / AI code generator for VBA / MSAccess?

Does anyone know of a Rules Engine / AI code generator for Transact SQL?

I made the mistake of thinking this VB code would work in an ACCESS module...perhaps it even will but not in the form shown on the site. Does anyone know how to make DWORD registry entries from an access module or the Access 2007 "Package Solution Wizzard"?

SQLDenis, your the best.

What is the syntax (if any) to set multiple variables from a sengle SELECT statement in a stored procedure. For instance, I might: @WorkVar = (SELECT columnX FROM tableX WHERE condition) and get a single variable filled. Is there a syntax for bringing back multiple columns into multiple...

PHV...thanks, this will do it.

BY the way, the registry entries I need to make are DWORD entries.

Using the "Package Solution Wizzard" to create Access 2007 runtime install packages I have been able to add KEYS (like "Trusted Locations") to the registry but I need to change some of the default application settings like "Confirm Document Deletions" so that end users are not asked to confirm...

George Solved it for me. I was putting the OUTPUT qualifier on the variable in the CREATE statement but not in the EXEC statement. It works now, thanks.

I am using the folowing CREATE, SET and RETURN statements but nothing is returning from my proc, any tips? CREATE PROCEDURE dbo.sp_ReplicateChildSchedule @P_Child nvarchar(50), @P_WeekToCopy DateTime , @P_WeekBeginDate DateTime, @P_Msg Varchar(50) OUTPUT AS SET @P_Msg = '0...

SQLSister, Can you point me to any reference material on "set-based logic" to replace cursors?

Hi Dennis, and thank you. This is my first post...in fact this is my first programming in quite a while. The reason I did not want to call an outside proc was that the function I wanted to call from several places was a cursor loop and I did not want to cause the overhead of allocating and...

How does one construct a callable function within a stored proc? For instance, if I had a block of code that turned on the lights and there were three places in my proc that I wanted to turn the lights on I would not want to have the same code in three place. This is old programming 101 stuff...