Recent content by joannef

Using Crystal Reports 10, when creating a pie chart from a SQL 2000 sp to be used in a VB .NET application, it is duplicating the totals it is pulling from the database (Counts the different types of data). Anyone have an idea why? Thanks for the help in advance. Joanne

I am trying to export data to excel for a mail merge and found out if I do not use the snap to grid and add guidelines it will insert blank columns and rows. Having found the solution to my major problem I then went to my Visual Studio solution, opened the report, and now I am unable to find...

I have an Access 2000 database that users rely on heavily for mail merges, this of course created many headaches so I have develpoed a SQL backend and VB .NET front end to avoid the issues I am having with Access and record locking. Now I want to add the mail merge capability and create the...

Thanks Glenn, That gave me a workaround as well. Joanne

They are just a regular combobox with a set of list values, because the list values have no type of ctl I cannot seem to exclude them from being resized. Thanks for taking the time to look into this. Joanne

Got any suggestions for type of when it gives an error on the list items in the combo box. For example if the items in the combobox are Type1 Type2 Type2 When I run the resize it will tell me the control is of type "Type1" not list or combobox and therefore gets into the code...

I lied, but at least now it starts the application and its only when I switch forms that it gives me the same runtime error 383 I had before. And I do think it is the comboboxes causing the trouble at the moment. Back to the grindstone. Joanne

Hurray!! The renaming of the subroutine fixed everything. Thank you so much for your time and knowledge. I will have to remember that as programs get "smarter" with newer versions, I will have to use better programming techniques from ths start to keep up with it. Joanne

I wqas getting runtime error 424 object required .. which with your help moved it along until now i get the error runtime error 383 'Height' property is read only, when I look at the control it seems to show "". If I say do all but ctl = "" it resizes the form wrong. What...

Here is the full sub routine. This was working, could updating to Service Pack 3 have made need new references? Public Sub Form_Resize(frm As Form) 'Passes in the name of a form and does the form resizing On Error GoTo Errhandler Dim Heightratio Dim Widthratio Dim ctl As Control frm.Move...

Why not use the IsNumeric function in Vb? Dim MyVar as long, MyCheck as boolean For example MyVar = "53" ' Assign value. MyCheck = IsNumeric(MyVar) ' Returns True. but if MyVar = "Help" MyCheck = IsNumeric(MyVar) 'Returns false If mycheck = false then...

That helped me get to my next problem :) Dim ctl as controls For Each ctl In frm.Controls ctl.Top = ctl.Top * Heightratio Next ctl Any suggestions? And I do appreciate your help with this. Joanne

I have this resizing code in my standard module that used to work before I moved to a Windows 2000 OS. Public Sub Form_Resize(frm As Form) 'Passes in the name of a form and does the form resizing ActiveForm.Move 0, 0, Screen.Width, Screen.Height ... End SUB Now I get a runtime error and the...

I have a linked word document that I just recently added a password to for only authorized users to view the contents. Because the link on the web page worked fine before this password was added, now I am finding that once I open the document and add the password, an instance of WORD is kept...

I have a program that runs fine on WIndows 98 and NT. But for some reason it wont run on Windows 2000. I have updated the DAO object Library reference. I have installed the Jet pack 4.0. But when I do to install the mdac_typ.exe it runs through the whole installtion and as it does something...