Recent content by IcesMaster

I assume you have three checkbox related to 3 fieldnames. You can create query based on the checkboxs like this Dim mSqlText As String mSqlText = "SELECT FieldA, FieldB, FieldC, FieldD FROM TableA WHERE " IF Me.CheckBoxA = False Then mSqlText = mSqlText & "FieldA = "NY&quot...

I read that Access 2003 is already using vba.net. If I install the tools, is it compatible to My Access XP VBA codes?

'This is what I did to Run stored procedure "TEST" 'ALTER PROCEDURE "Test" (@YourName nvarchar(20), @YourPass nvarchar(10)) 'INSERT INTO dbo.UserList (Name, Password) 'SELECT @YourName As Name, @YourPass As Password '----------------------------------------------------------...

Sorry. T can't find how to set passrthough in Access project. I need the way to pass parameter in Access project

Just make a button and open the click event and try this code: Private Sub buttonX_click() Dim mSql As string sSql = &quot;UPDATE tablename SET columnnametoupdate = columnname1 + columnname2 WHERE columnnametoupdate <> columnname1 + columnname2&quot; DoCmd.RunSql mSql End Sub Is that what you...

Why not create function to develop SQL Text and run it as Recourd source, in the form or at other form. It's only create WHERE clause based on the existing value 0f (text/combo)box. Example: Dim SdlA, SqlB As String SqlA = &quot;SELECT Assets.BarcodeNumber, Assets.AssetDescription...

With access XP as front end and MSSQL SERVER 2000 As Back End: It not satisfying me using &quot;DoCmd.OpenStoredProcedure&quot; when Executing non-select SQL, and I still questioning the effectiveness of using ADO in VBA. Is somebody know the best way? Thank you

The best way is by creating user's profile in Windows registry setting and set your application to use it. I'll explain later. I had a guess

#1 By making dial-up connection and synchronize it every day when I don't need real time data. #2 By using IIS and Data Access page through internet

How to include VBA reference when I distribute my Access Project while NOT USING DEPLOYEMENT N DEVELOPER EDITION

Is there any way to create subform under a form like in access by vb?

Thank you

Thanks Claire I already found that I made too much parameter so while I create the procedure to joint the functions I made mistake in writing the parameter structure. For Bertrand, here I made the sample of Joining parameter function in stored procedure as I mean Exp. I have two functions...

I have 2 procedures (functions) each having parameter (@...). How to joint it? Thanks

I have two stored procedure. Each having parameter (@...) How to join them cause I always find error while trying