Using JOIN Clauses
Question: I’m working with Visual Basic and Access 1.1. Currently my program uses two tables (tblrep and tblsales). The common field being tblrep.id = tblsales.id. The first form of the
Question: I’m working with Visual Basic and Access 1.1. Currently my program uses two tables (tblrep and tblsales). The common field being tblrep.id = tblsales.id. The first form of the
Question: I have written a testing program that writes results to a grid.How do I write the grid to disk so that changes can be addedfrom testing session to testing
Question: I need to place multiple option buttons on a form. I alsoneed to be able to have two buttons selected at all times.I can do this with multiple frame
Question: I am using VB together with Access. What I want to do is to include photo into my form. In Access table, I declare thisfield as an OLE field
Question: What it’s the correct SQl Statement to search an access database by a numeric field? I keep getting an invalid type error when I try to run the application.
Question: I am having a problem that I hope has not been answered herebefore. I am experiencing different results when I run a program than I do when I use
Question: I don’t know how to access individual characters in a string.ie. accessing single elements in an array of characters.Each time I try I keep getting Type mismatch. Answer: You
Question: I have a formless VB exe program that creates VB modules(.bas) and saves them to disk.Is there a way of having my program start VB passing my module name
Question: I have a copy of data widgets from sheridan sware and am using the SSDataGrid provided. All i want to do is insert data in the grid at a
Question: I’m using the 3D Panel in my application. When I setits background coulor to light grey, it looks fine onmy workstation but it’s white in any other workstations.That’s true
Question: Is there a way to put the cursor at the end of the text in a text box? I use .SetFocus to put the cursor in a multi-line text
Question: Can I get the name of the procedure that an error has occurred in?For example, I would like to send my error to a form that containsthe error number,
Question: Can one call a stored procedure or function in oracle 7through odbc from visual basic? This might be a questionfor an oracle user group, so if you know where
Question: I have a List with names and addresses from a database.I want to have the list as shown below.Mr. Smith Street 10Mr. Andersson Street 25I’ve tried aligning them by
Question: I have visual basic 2.0 Hopefully not for long. If I make a button that does a funtion like this. n = n + 1 print nit gives me
Question: I’m trying to use the KeyPress event to automatically uppercase what the user types. How do I do it? Answer: Put the following code into the KeyPress event of
Question: What is the best method to use for updating an Access 2 database from Visual Basic? I am a bit confused aboutthe methods presented such as 1) VB Data
Question: In procedure, I used statement like this:ds.FindFirst “fulldate = ’95-10-31′” ‘ds is DynaSet variablebut always it fails, and ds.NoMatch Value is True(-1).What’s wrong with this? Please help me. Answer:
Question: not having programmed in any of the BASIC languages, I am wondering if Visual Basic’s string variable is in anyway similar to what a string variable is in C
Question: What’s wrong with this code :if file1.filename=”*.bmp” then picture1.LoadPicture(file1.filename) Answer: I’m guessing you’re trying to check the selected filename to see if it ends in .BMP, right? The problem
Question: We have a Large VB application (code wise) and we are movingthe data from MS access to Sybase using the ODBC driver.Now, after we presented the project’s time tale
Question: I am trying to connect my MS ACCESS 2.0 Database to the WWW viaa VB-CGI-Script. I figured out, how to transfer data from a HTML-Form to my VB-programm but
Question: Is there any way to clear a combo box without it’s Textproperty being set to null? Answer: As far as I know and have tried, the only way to
Question: I am resizing my widows during runtime. I also want my dialogboxes to resize with the window. My program is doing thiscorrectly. But it is not resizing the command
Question: I have a requirement to only allow a copy of an application to be executed once.If someone tries to execute the app a second time, I want to give
Question: I have a Huge front end to an Access database. The front end was created in VB3.0, I recently upgraded to 4.0, it states that the references should work
Question: Data1.Recordset.FindFirst “LastName = ‘Quayle’”Ok that works fine. Why can’t I:Data1.Recordset.FindFirst “LastName = VarLN”where VarLN is a variable which the user has just provided? I get error 3070, “Can’t bind
Question: Is there an easy way to clear a combo box’s contents, other than using the Clear method? Answer: One of my users suggested that if you add a space
Question: What’s an easy way to make a copy of a currently open database? I’ve got open recordsets all over the place that I don’t want to close. Answer: Simply