devxlogo

Tip Bank

Copying Table Rows

Question: I have two databases and two tables in them have the same structure (same columns etc.). How do I copy some rows from one database to another? Both tables

Send on Behalf Of/Reply Problem

Question: If I set up a delegate and they send a message on my behalf, the reply goes to my delegate. How can I force the reply to come to

SMTP Mail Send Problem

Question: We are sending over 50K of outgoing e-mails an hour. Today the queue fills and we can only handle about 20K an hour. At some point the mail server

Allow Users to Reset Your HTML Form

You can use HTML forms to provide an efficient interface for collecting user information. You can include various types of controls like textbox, check box, buttons, listbox, and so forth

Maximum Number of Objects on a Form

Question: Is there any way to get more than 255 objects on a VB form? Answer: No, there’s not a way to pass the limit of 255 objects per form.

Using Format Function to Right Justify

Question: When using printer.print statements to send output directly to the printer, it used to be possible in QB PDS to use something like “printer.print format(number, “###,###.00”) to get right

Using Variables in SQL

Question: I have connected a form to the DB using an ADODC. I connect fine, I can read the DB if I put a literal in my sql: recordsource =

Initializing Array of UDT’s

Question: Here’s some simple code in Test.bas: Public Type MY_RECORD Field1 as String Field1 as StringEnd Typein frmTest.frmGeneral DeclarationsPrivate mArrayOfRecords() as MY_RECORDForm_Load ‘this line of code BOMBS If IsEmpty(mArrayOfRecords) then

Database Integration

Question: I am developing an application in VB6 that uses its own DB. I need to link my application’s DB with clients’ DBS or even ERP systems. Therefore, I need