Search results for query: *

hello all here is my problem I am testing a VB/Acess app in 98, 2000, xp home and pro. My app will write as record out to a table when testing in any OS. I then run a sql statement to pull back the record ie select * where [name] = 'john' the reocrd containing the name john is present on all...

I have created an app that uses an Access DB within the app I write records to a table then qeury the table based on criteria. It will pull back records as needed until it hits the last query. The last query is simple enough SELECT * FROM INF_Prof where name = 'joe' The table does have a...

Hello I have created a program that uses an mdiform to load 9 child forms. I have sized all forms to fit into the mdiform without a need for scroll bars. When the app runs on all oprating systems except XP all is fine but the same app running on XP will cause scroll bars to appear in the MDI...

Hello all So I left work last night with all things being normal on my PC. When I left work last night I had 'locked' my PC and first thing this morning sat at my desk and signed on. So... normally my screen resolution is set to 1024 x 768 but this morning it 'magicly' was set to 768 x 1024...

I am using the MSChart control in a VB app. Currently I am hardcoding a value for the X and Y axis titles through the custom properties dialog under the text tab. What I want to be able to do is assign the value to the X and Y axis at run time to allow for English or French text. Can anyone...

Hello all I am playing around inner joins and have run into a problem. Here is my code strsql = "SELECT Client.ClientName, Product.ProductID, Product.Product from Client " & _ "INNER JOIN Product ON Product.ClientID = Client.ClientID Where Client.ClientID = " & Val(txtClientID)...

Hello all I am a rookie when it comes to flash so I decided to create a site to display images as a way to learn a few things. The site is still under construction but I have a few questions if I could. - What is the best way to load images so that the site load time is minimized? - Why is...

I want to open an html page from within a VB app that is stored on my PC. I am using the following code to make it happen lngRtn = Shell("rundll32.exe url.dll,FileProtocolHandler C:\Envision\Forms & Documents\Index.htm") this will work but I have 2 problems First IE opens the html page but...

Hello all When I want to step forward through my code as it is executing I can use the F8 key to see what is being executed. My question is how do I step backwards. I have a form deactivate function that is being called and I can't figure out why so I have 'red tagged' the function to force...

Hey everyone, a quick question nothing too tough I think. I am working on a vb app that uses an mdiform, my question is can I prevent the user from resizing the mdiform? Thanks

Hey guys I am new to the MSChart control and am having a problem positioning the legend. I have a chart called chsummary I have positioned the legend to the rightof the plot area. I want the legend to start on it x axis just to the right of the pie chart here is the code I am using to do this...

Is it possible to have a msg in a msgbox display on 2 lines instead on one? an example I have a msgbox that displays the following msg You have not entered in the correct number. Please try again I would like for it to display as You have not entered in the correct number. Please try...

Hello all I am playing around with the inputbox function. As far as I can tell if I do not put in a default value then the user clicking ok without entering a value provides the same return as if the user clicks cancel? is this correct? and if so how can I tell the difference between the 2...

Hello can any one tell me why.. the following statement returns a record count of 0 strsql = "SELECT * From INV_Prof Where [AdvisorKey] = " & lngAdvisorKey Yet the following statement returns a recordcount of 1 strsql = "SELECT DISTINCT [ClientName] From INV_Prof Where [AdvisorKey] = " &...

Hello all I have a Access DB that I am saving and retrieving records to/from. I want to limit the user to save only 1 record per client name per Advisor per day. Here is my SQL statement strsql = "SELECT * From INV_Prof Where ([ClientName] = '" & strClientFullName & "') AND ([DateSaved] = #" &...

Hi there I have a textbox that contains a name, the user is allowed to change the name in the textbox then save it to a DB I do not want to allow the user to save a empty value to the DB so how can I check to see if the textbox contains a value that is not blank. My concern is that if the user...

Hello all This may be a bit of a rookie question but its driving me crazy. I have 4 buttons on a form all part of an array. When the user selects 1 of the 4 buttons, the selected button changes from a grey colour to a green colour. No problem making this happen But.. when button #1 is selected...

Hello all I am working on a project that uses MSCHART, although I have not been responsible for this portion of the project and have little knowledge of the MSChart control. With that said we do have a problem with the layout of the chart as it appears on the form. When the chart is displayed on...

Hello all here is my situation I have a total of 7 check buttons on a form. The first 6 are grouped together in an array. The user can select any or all of these buttons. The 7'th button is selected when the user wants none of the above. Here is my problem. When the user enters the form and...

Hello all A simple problem I think. I have a series of option buttons that by default are grey in colour. When the user selects one of these buttons I would like it to change to a different colour. If the user changes their mind and selects a different button I would like the first button...