Search results

Hi, I'm trying to get a return value from an Scalar-valued function in an SQL server into access. function is as follows: CREATE FUNCTION [dbo].[SQLStr] () RETURNS nvarchar(2000)AS BEGIN Declare @SQL nvarchar(2000) Set @sql =N'SELECT...' return @sql END GO and I'm trying to call it like...

I'm trying to find a way to manipulate specifically named objects on the form via name. Currently Ill run code like this to find every object: Function (i as Integer) Dim MyObject as Object For Each MyObject in me.Controls If MyObject.Name = "Level" & i Then...

Hi, Ive been trying to get a piece of code out that dynamicaly looks at several controls at a certain "level" and sets the controls on the "levels" below to a value that the user has chosen on the first level... I'll try to explain: The user has 8 levels of data, the first level choise...

Hi, I'm trying to write in some events that I want to start on application open and close. So far I have not been able to find those event handlers. Open is pretty easy, just need to stick it on the first form that opens, but close is a bit tricky. There is no way to be 100% sure that any 1...

Hi, I'm trying to make my access applications compatible with 2007 and have hit multiple issues, one of which i cant seem to get around! One of my forms has a tab control and one of the tabs has a continuos subform. The problem is the continuos property does not work in 2007!! Any ideas as...

Hi, I am trying to build a small UI to allow a user to import text files. Unfortunately I have no way to let the user select the file without using Activex controls (which are currently not installed). Is there anything I can do to develop some sort of a basic file-picking UI that returs the...