Quote Syntax Error
Question: I’m trying to delete a set of records in a table attached to a data control by using an SQL statement like the following: MergeRec.Data1.Database.Execute “DELETE Patient Visit WHERE
Question: I’m trying to delete a set of records in a table attached to a data control by using an SQL statement like the following: MergeRec.Data1.Database.Execute “DELETE Patient Visit WHERE
Question: How I peek and poke on Visual Basic 3.0, or is there a replacement available for the INP/OUT functions? Answer: In my File Archives area, I have a file
Question: I am developing a VB3 app. I want to update an ACCESS 2.0 table weekly, in code, with a text file that is down-loaded from a VM mainframe. I
Question: I wanted to create a front end GUI panel using VB. This panel would have command buttons, and a picture box. When the user clicks on a command button,
Question: How do I compare dates in VB? Also, how do I store dates into Access? I can’tget them into the right format. Answer: For comparison of dates, look up
Question: I am a beginner programmer with VB 3.0 Standard Edition. I am not very familiar with the Common Dialog VBX (CMDIALOG.VBX). I am designing a Recipe Book program and
Question: In my “Save As” dialog box (from CMDIALOG.VBX), my OK button and Cancel button both save work. How do I recognize when the userpresses the Cancel button? Answer: One
Question: I need a 3D bound text box control so I can avoid having to place standard text boxes in 3D panels for a chiseled effect. I have been unable
Question: I am currently migrating my VB/Access application to Microsoft SQL Server. However, the “SEEK” function in my old program does not work any more and I can not find
Question: I am currently writing and testing an installation program which will soon be distributed. During the this process, I edit the SYSTEM.INI file. Most Windows software willallow you to
Question: I have an established Access v2.0 database with fields intables named “Circuit ID”, for example. How can I use VB v3.0 to query this database without changing all references
Question: I have been attempting to write some code that acceptsinfo from text boxes labeled “Login” and “Password.”I then need to check the password up to x amount of timesbefore
Question: How do I use 3D effects on message boxes and common dialogs? Answer: Here is the code you need, in the form of two simple functions. Please note that
Question: How do I write VB code to copy one file to another? Answer: You can either use the FileCopy Visual Basic command, or use the method outlined elsewhere in
Question: How do you control whether the window title bar is visible or not visible on each form when the application is running? Answer: If you set the caption to
Question: I am having trouble transferring a bitmap that I loaded withthe LoadBitmap call from a resource to a picturebox. Howdo I do that? Answer: The LoadBitmap call returns you
Question: I have two forms. There is a combo box on Form1 and a list box on Form2. Form1 has functions to add and delete names from the combo box.
Question: I want to read the MSMAIL.INI file to get information for my program when it starts, and write information there when the program is terminated. I am looking at
Question: How do I determine the Windows directory? Answer: The API call to use is “GetWindowsDirectory”. The Declare statement is listed in the the Windows 3.1 API help and the
Question: Could you (easily) please tell me what .FRX files are in VB?I’d be forever grateful. Answer: FRX Files are displayed in Windows 95 as Visual Basic Form Stash Files.
Question: I added records to a list box using the datacontrol. Now I would like to use the list1_dblclick procedure to access the recorddblclicked and use it. I know there
Question: I semi-understand InStr, however, lets say I am trying to parse e-mail addresses and test for “@”. How do I find my way to the beginning and end of
Question: How can I make my program totally exit Windows? When the user hits “Quit Windows”, I want Windows to exit. Answer: Use the ExitWindows API function. The declare statement
Question: How do I delete a record with the data I’ve selectedin a DBListBox (VB4.0). If I use the e.g. Findfirst command I get the message:“The action was cancelled by
Question: I am using the data control through the Standard Version of Visual Basic 4.0. The data control is linked to a table in our database and when I try
Question: How can I make it so that a form will stay on top until the user presses a button? For example, an error message pops up, the user can’t
Question: I want to make a list-combo visible but, I can’t get using API function :SendDlgItemMessage.What is “hDlg” in the following declaration?Declare function SendDlgItemMessage Lib “User” (Byval hDlg as Integer,
Question: How do I save an OLE object into an Access database without using a data control and the OLE OCX? Answer: You should look at the AppendChunk and GetChunk
Question: I having trouble using strings and text. I am writing a document creation system and all the text in between the “” char. would be red. All other text
Question: I’ve got to control 3 stepper motors from the printer port. How can I activate pins on the printer port using Visual basic. For Example I want to activate