Recent content by shaomwang

Ken, Thank you for your help. The same question as bellow: I use a code behind a search form to get sql sentence like below: strSql = "SELECT *" strSql = strSql & "FROM [CLAIM]" strSql = strSql & (" where " & Mid(varMyWhere, 6) & ";") How to pass entire sql sentence as parapeter to store...

I use a code behind a search form to get sql sentence like below: strSql = "SELECT *" strSql = strSql & "FROM [CLAIM]" strSql = strSql & (" where " & Mid(varMyWhere, 6) & ";") How to pass entire sql sentence as parapeter to store procedure? Or only where clause to store procedure?

I created a program which uses form to let user input parameter. I try to use SQL store procedure, and then use pass through query to call this store procedure. The key point is: how to pass the parameter which user input from form to store procedure? Help

Can you tell me how to tell user the number of page of report before print, using code?

Can you tell me how to tell user the number of page of report before print, using code?

Can anyone tell me how to use public variable, which got value from a form, in report header?

How to use public variable in report header?

How to make a form let user to select fields of the table?

How to hide database window so that user can not see all object (eg. query, form...)in MDE file?

I have a table including 3 fields. Company, Product_ID and Order_Date. How can I use VB code to take any one record in Order_Date field and assign to a variable? [This message has been edited by shaomwang (edited 11-14-2000).]

I need code to find first order which meet the condition basing on the following table. COMPANY PRODUCT_ID ORDERDATE FIRST_ORDER--- ------- ---------- ---------- -------------- AAAAAAA 1111111111 5/20/2000 AAAAAAA 1111111111 3/20/2000 BBBBBBB 3333333333 3/15/2000 AAAAAAA 1111111111...

I found answer myself. You can use build in command filecopy to do it.

How to make labels or controls in the form flahing under certain condition? For example, if order date = 4/10/00, the label or control of order date will flash, if total amount > $1000, the label or contrl of total amount will flash.

Every day I need to rename one file which downloaded from mainframe and give it name as today's day and month. For example, 0422.txt, 0423.txt, so on. How can I write a function or procedure to do it?