Search results for query: *

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

You can use Make Table querry. For example&quot; You want to copy TableA to New table calles Table B SELECT * INTO TableB FROM TableA;

I think you must create a function in module. For example: Function CheckDate(CurrentTime) If CurrentTime <= &quot;07:00&quot; CheckDate = Date() - 1 Endif End Function So you can use the function in your procedures or form, like: CurTime = Time(Date()) ShiftDate = CheckDate([CurTime])

I also use Windows XP, SQL Server 2000 (Client Tools only and MSDE) and Office XP (with Service Pack 2). Everything OK. It might be caused by drivers program that is not compatible with your Windows XP.

Thanks to all. Now I have no more problem since I bought Office XP Developer Edition. It's including Free Access Runtime too. So my I don't have to ask my customer to upgrade their Office immediately. I hope this information usefull for the others About Office 2000 Service Pack, it's too large...

Yes trough the Tools - Security menu If you need the detail I will send you an email