Recent content by wlgzhang

Pat, Thank you for your help! Wei

Hi everyone, A simple question here: I try to copy my 97 access database application to 2000 version I recently installed, but I could not run my db since it dose not recognize the DAO objects, such as object currentdb ..., in my code. I would like use DAO objects in the access 2000, what...

Hi all, Here is a simple question: I have a few users (2-4) may use the db application at the same time, so I decide to make my Access database application as replicated system. Before I use the replicate menu in the access interface or write the code to make the system becomes replicated, do I...

problem with datepart function Hi Pat & Filippo, Both helps are solving my problem. Pat's suggestion is right. I can just compare with two dates and no need to break them. Thanks again for the helps! Wei.

Hi all, I have find solution for the calculating expired Date function. I use DateValue function to convert the calculated result and it works fine. ExpYear = CurYear + 2 Me.ExpiryDay = DateValue(CStr(CurMonth) & "/" & CStr(CurDay) & "/" & CStr(ExpYear)) However, I have not...

Hi All, I have a function that checks the CQ evaluation expired date in my Access DB. The Expired date using the short date format is DD/MM/YYYY When I use Datepart function to extract the month from the Expired date, the function returns wrong Month. Also, I have a very simple function to...

Hi Gizmo & Adrianna, I go to Microsoft website to read the online version of programmer guide. I delete all the book marks in the table, and work with objects of rows Columns cells in the table directly. Now I solve my problem and get the output right the way to the document by change my...

Hi All, I am developing a BDMS by using Access, have been asked to publish data to a word table, I inserted some bookmarks into this table. I try to pull data form access and insert these data onto mapped bookmarks. When I run the code, I get a runtime error: You entered multiple destinations...

Hi All, I set up a word template and have inserted some bookmarks into a table in the template. I try to pull some data form access to this word template. However, I get a runtime error: You entered multiple destinations for a page, line, footnode, endnote or document. I had done some programs...

Update Query Problems: Hi All, Thank you for all Your replay. I find out where the problem is (missing a pair of single quotation )and fixed it. Now the code works and no more pop up dialog boxes to bord me. The code has been little changed as Shown on color marked place: ResultSql = "...

Hi Pat, I did follow all of your suggestion, still got runtime error: syntax error in parameters clause. If I get rid off the parameter clause, I always get pop up dialog box witch ask me to put the value of Result. I do not know why. the size of the DB is about 12MB, I have to take time to...

Automation: Access to Excell: Change Font on fly Hi Greetz and all, Sorry about the stupid question that I posted this morning. I think now I know the answer: Because of the statement of: with objWS.Rows([defualt row],[Column]) end with the default row is the start row, and the rows inside...

Automation: Access to Excel: Change Font on fly Hi Greetz, Thank you for your help. I have tried your code, it now works. However, there is trick, and I am worry about it: When I change the code like what you told me exactly as the following: Function FillScheduleHeading(objWS As...

Hi WayneRyan, Thank you for your help. I did had type on that field mane, and I had fiexed after I post the question for a while. Know, the works correclty, but I do not like the pop up dialog box witch ask me input the value that I have assigned to the field in the update query. I tried to do...

Update Query Problem Hi all, I have fixed my update query hence the query is working right now. However, I do not know how to get ride off the parameter input box at run time Counld anyone help me to come up the solution, syntex? Thanks for any help. Wei