I have been contemplating using Janus GridEx 2000 in one of my fairly major database apps, but didn't want to buy the license w/o asking to see if any of you have any experience with this product. I like what I see from the trial version, and I like the user interface, but didn't know if any of...
I have a combo box that I want to include all records in a database. That way the user can input his/her own data. Anyway, is there a property or anything to do this? I know that I can code it, but that brings me to point #2. This is the code I am using to set my recordset.
dim db as...
I am trying to create Error Handling code that will jump a line if a certain error occurs. Here is the problem. I have to delete a table from a DB on exiting a form. The problem is, that I need to have that table deleted and created multiple times during the life of the form. I have no...
I am doing a query of a fairly large DB. Each record in the DB has a unique "job #". Every year has its own prefix. what I am trying to do is to query out all the records for one year. I am picking the year with a combo box. Here is the query I am using. I cannot get the...
I have a DE that is bound to a table that is created at run-time. I have a grid on a separate form that is supposed to show the results of a query. It is within that query that I create the table. However, the DE does not seem to refresh itself. I have tried loading it by code, I've tried the...
I have a dataenvironment (DE) that I want to be able to change by code. I want to be able to change the table that it is bound to through code. I have an ADODC control that is always bound to the correct table as defined by the user. If there is a way to send the ADODC's recordsource to the...
I want to be able to change the recordsource of an ADODC control through code. For example, I have a large DB with numerous tables - each representing one year for the last 15 or 20 years- and I want to allow the user to choose a year via a combo box or some other way, and have the ADODC's...
Is there some way to change the text in a text box to read the words backwards? For instance, I want to be able to put ,"Hello" in a text box, click a command buttton, and have the box read ,"olleH". I also would like to use another button to change it back to normal. Is...
There are a bunch of free downloadable controls and files at www.vb2themax.com. For instance, I downloaded a control that puts a icon in the system tray when you run the program. I also downloaded a control that allows you to create custom message boxes. You can put your own captions on the...
I would like to be able to have the user draw images of their choice on my form. I can get a circle and rectangle to be the size that I determine with the mouse, but is there any way to resize or be able to see the image as it is being drawn? Do I need an ActiveX control or is it something...
I have figured out a method to click and drag a circle on a form, but the problem is... When I run the program and click and drag to create a circle, the circle is smaller than where I dragged. I know this because after I have one circle on the form, I postion the mouse right on the edge of the...
I have a form that has option buttons on it. When one option is chosen, I want to be able to click and drag a circle, or another option is an oval etc... The problem is... can you click and drag shapes at runtime? Please help me with this. TIA. PS. I can make fixed sized lines and circles...
Does anyone have any ideas as how to create/show a ruler on a form? I need to show the scale of a label. The label represents something that is approximately 8 inches wide by 12 feet long. I want to show a ruler on both sides so the user knows how long the object is without remeasuring. I...
I have figured out my backspacing problem. Now I have something else... I need to round numbers to whole numbers. I have a mathmatical expression that will almost always return a whole number and a decimal. I need to clear the decimal and round to the nearest whole number. Is there some way...
Is there anyway to backspace in a text box without using the keyboard? Actually, I know there is a way, I just can't think of it. :-) I need a mouse interface, no keyboard work. I have a number pad set up using command buttons and all the numbers work fine, but the backspace button is...
Is there any way to manually insert data into a Report's label? There is not a function for the procedure I need, so I want to code it on a main form, and send the value to the Data Report. Any help would be appreciated. TIA for your speedy answers.
I have an app that has a data report. The data that is shown in that report is user-defined. The user chooses the info to display, and the info is taken from one table of the DB and written to another table. The Data Environment that is tied to the Report is tied to the second table. The...
I have an app that uses a Data Environment(DE) and a Data Report(DR). The DE is tied to an Access DB table that has all of the records deleted from it on a command button click. Then records are added via user-defined stipulations on another table in the same DB. It is just a summary of info...
I am trying to make my app compose a message. Every time I try, I get an error saying, "Valid session ID does not exist." I have tried everything I can think of. Please help. TIA.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.