Search results for query: *

Hi, I am currently doing a project which involves 2 form modules. By hitting a button in Form A, Form B is opened. I would just want to temporarily save data in Form B because user may want to cancel the operation anytime by hitting the "CANCEL" button in Form A. Eventually, everything will be...

johnwm,vbSun & nigelrivett, Thank you guys for the references! MichaelRed, The reason why I'm creating a temp copy of SQL server db to an ACCESS db is to facilitate the easy searching of certain field (fullname). I've created a module, a sort of an autocomplete thing (populate a datalist...

vbSun, I am not also familiar with SQLDMO. Any tutorials about it? Thanks.

DrJavaJoe, Really sorry I failed to mention that I'm doing all this at run time. The purpose of this to create a local copy of the database for each user to work on. The tempory ms access db is created/refreshed each time the user starts the system .

Thanks guys! You're all great!

mattKnight, Thank you for your reply. I'm not really familiar with DTS package in VB. Could you please tell me how to go about it? Thanks.

Hi guys! I am currently working on a project which requires me to copy records (200,000+ ) from SQL SERVER database to a temporary MS ACCESS database. Somebody, please help.

JBats, Thanks for the code! It really solved my problem. Regards. God bless! Percy

Hi guys! I would like to know how to handle apostrophe in a SQL statement. I'm getting an error when I process the statement below: tmpfullname = "O'CONNOR, MARLYN VALLE" strSQL = "Select FullName from BRGY Where Fullname = '" & tmpfullname & "'" set rsconn =...

Hi guys! I like to know what is the most effective way of handling records on a multi-user environment (connecting to db, adding, deleting, editing records). There are records in my database that does not have a valid bookmark. Does it in anyway connected to the way I add, delete, edit and...

Just a follow up. How will I split up contents of a Rich TExt Box in such a way that the first group which will be my first record in a DB will fit in exactly on a letter size paper? Thanks.

Could you please give me an idea on how will I determine which group of text or how many words goes to page 1 or record #1 and so forth...? Thanks again.

petevick, Thanks for your reply. I was able to show the contents of the RTB thru label control but is only limited to displaying 1 page. Do you have an idea on how I could possibly show all the pages? Thanks.

Hi guys! I just want to know if there's a way wherein I can view and print a document (2 pages max) coming from a Rich Text Box into Data report without saving it first on a database and also retaining all of its attributes e.g. bold type, centered?

dgillz and chelseatech, Thanks for your reply. Sorry if it appears not clear to you. I'm talking about storing the path to the image on a database and retrieves it in the report. Percy

Hi guys! I just want to know how to display image files ex. jpg, bmp in Crystal Report 7. Thanks.

CCLINT, Thanks again. It surely is faster than the code a previously used. One more thing sir, how will I use this method to edit all the fields or a particular field in the recordset. And could you please give me tips on how I could optimize the performance of my application. There are times...

Hi guys! Does anybody have an idea on a faster way to search a particular record on a database. I tried using recordset.find method and it's really slow. I'm trying to find a string on an MS Access DB of 100,000+ records. Please help.

tedsmith, Thanks for your reply. I would like to correct my posting it's primary key that I'm referring to when I say primary. Do you have an idea of a faster way to copy a large database say 100,000 records with 10 fields or append records from one db to another including attributes such as...

Hi guys! I'm trying to copy an mdb to another mdb. I use the filecopy command but I'm getting error if the mdb is in use. I tried to use the SELECT INTO statement in DAO and it worked but the primary are not copied. Can you please tell me how I can have an exact copy of an mdb. I'm using VB6...