Search results for query: *

Hi. I have found one of the common problem that from my transactional replication, it always give this problem. Error Message : The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. Error Detail : The...

Hi, Can we direct the printing to the printer which is attach to the terminal service client? Example: Location A: workstation A and printer A Location B: database server. Workstation A had setup a terminal service using windows 2000 to database server at Location B. How to setup so that...

Hi, I am using Crystal report professional 8.5 in my workstation. I write VBA code just to retrieve crystal report (.rpt file) from local database and it is running well. Then I copy the VBA code and crystal report file to other pc but I didn’t install Crystal report professional 8.5...

Hi, I am using Crystal report professional 8.5 in my workstation. I write VBA code just to retrieve crystal report (.rpt file) from local database and it is running well. Then I copy the VBA code and crystal report file to other pc but I didn’t install Crystal report professional 8.5...

Hi, My SQL log file size already full, i totally can not perform any backup to clear the log file and system hang. How to clear the log file via other approach?? Or how to increase the log file size?? Note: The log transaction is not important. Thank you. Regards, Tan

Hi Terry Thank you for your help. Finally i get the answer. TQ. Regards, Tan

Hi, i need your help in SQL syntax. Let say i had a field name Book_No and data such as AH38JKJ98J. Meaning Book_No = AH38JKJ98J. What are the SQL syntax to just retrive "H38JK" from the Book_No?? VB syntax is Mid(Book_No, 2,5), how about SQL?? TQ.

Hi, Thanks for all your reply, finally i get the answer. Thank you. Tan

Normally when we create list box in VB and we add quite a number of item in the listbox, it will show a horizontal scroll bar at the right hand side of the listbox. How can i change the scroll bar position from the right-hand side to the bottom of the listbox. SO that i can scroll from left to...

in my sql table got a table name POORDLIN_SQL. Inside this table have a field name ord_no. The format of this field is xxxxxx00 (meaning 6 digit number follow by 2 fixed zero behind). Below are my VBA code: dbs.Open "Select item_no from POORDLIN_SQL where ord_no = '" & Me.PORelNo.Text...