Hi Guys,Im having a small problem with records and forms in ms access 2003. I pretty sure this will have a simple solution, but im still beginning to learn VBA.Anyhow the problem is, there is a table called orders, in this table there is a field that lists if the client is canadian or US.Now, there...

Hi All, I have a main report with 3 subreports in detail a,detail b and detail c sections.I want to supress page footer on all pages except on pages where subreports are ending. for example, if subreportA has 50 records so on page 1, report footer of main report should be supressed but on on next pa...

Hi guys,I have used compactDatabase command in my code which ends in error because the database (Ms access) i use is still locked. I closed all connections to the database and set db objects to nothing but still its locked. How do i compact database even if it is locked. The lock file is gone once t...

Hi,I hope somebody can help me with this issue as it is driving me crazy.I am migrating Crystal 8.5 reports that currently run in an ASP IIS5 Win2K Server web application to a new server running ASP IIS6 Win2003 Server. When viewing a report through the web app the Crystal viewer is displayed but n...

Hi, I want to send xml file created in vb to the server using HTTPS post . I the file I send should be saved in the server directory. Like If we open a website it will display the list of folders and files , right. the file I send to the server should be displayed in the list. Is it possible.

Hi All,<br/>I am planning to develop a SQL Query analyser. I am using SQL Server 2000. Now the problem is that HOW I CAN CHECK WHETHER THE QUERY (SYNTEX) IS RIGHT OR NOT.<br/>Hope a positive response...<br/>.

If anyone can help with this small problem, I'd be grateful.Starting from scratch, I've created a new form, upon which I placed an SSTab control (Microsoft Tabbed Dialog Control 6.0).On the first page of the SSTab control, I've created 2 combo boxes.I've then coded the Form_load...

I cannot figure this one out. I have a SQL Server Database. I have 4 tables I want data from. CustomerInvoiceShipperCustomer Address.Customer is keyed by CustomerID.CustomerID is a foreign key in Customer Address, and InvoiceInvoice is keyed by InvoiceIDInvoiceID is a foreign key in Shipper. Shi...

I have a good grasp on how the MsFlexGrid works and use it in all my applicationsThe one issue I can't fathom is how you know the Last Row in a grid has been clicked ORThe blank space below the last row in a grid was clickedie, Grid.row = Grid.MouseRow delivers the same answer whether you cli...

and I am running into an error "The procedure entry point SetWifdowOrgEx could not be located in the dymanic link library GDI32.DLL. ??I have already replaced the file on the New Machine in the "Windows\System32 dir. to no avail, App Built on XP Pro platform and I am Installing on a Vista Basic Mach...

Hai,who do i get the Google Talk Contact list count in the main window named "Google Talk"I tried with SendMessage = (Hwnd,LVM_GETITEMCOUNT,0,0)but does not work.Option ExplicitPrivate Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As St...

Hello Gurus, Hope You all are fine I am Back again with my Problem as usual, and I will be greatful if you all help me to solve the same. Thanking you all in advance.I have a Picture ( as Attached ) , which has Particle ( Cells ) of different colors, I would like to count Particles of a Particular C...

Hi Everyone,<br/>I want to download the mails from pop3 mail server. Please help me if there is any way to do this job using visual basic 6.0.<br/>Regards,<br/>Uddhab

I have a VB6 application which is throwing an error 'Object variable or with block variable not set'. The strange thing is that this error is only appearing in our Production environment & only appears intermittently (less than 1% of times this line is executed). I cannot reproduce the err...

I have checked the forum for winsock problems and found some that have similar problems, but I still wasn't able to fix my problem.My app is a simle test chat program with a server running on my comp and client trying to connect on it. Server listens on port 5535 and client connects on port 553...

from my form, i can call another form using 1 CommandButton. However, i want to refresh the data in the first form after i close the other form. The problem is that i cannot modify the second form, so i need to know whether there is any other way to know that the second form has been closed ?maybe i...

Yup!I need to scale different size image into a fixed picturebox. Without changing the image height vs width ratio.any of you can help me? thanks.1)scale the image as big as possible depending the fixed picture box height or width.I use the loadpicture function in loading picture.If I use the image...

I am trying to build a program for selecting items. Let's said I have 3 Forms.form1 - for selecting location : toilet/kitchenform2 - items available in toiletform3 - items available in kitchenthree of the forms have the same listbox to show all the selected items.I do not want to repeat in buil...

There are mouseUp, mouseDown and mouseMove control in VB6.0.But I want to make the effect of mouseLeave..just like what happen when we move the mouse cursor over the bar with "User Cp FAQ MemberList Calender NewPost Search QuickLinks LogOut"above...Do you ave any simple and easy implement solution?...

Hi, Hoping to get report passed off today but one problem i have with the re format of the report requested.I have been asked to put product code in the Pahe Header, But i need the page to change when this changes.IE: We have prod Code Wel008-110KSI and it runs 4 coils per shift on average, but on t...

I have been working for a consulting group for six months now, was brought on as their first employee to take them into the world of .net. I've done asp.net and vb.net winforms applications. They normally work with applications written in Access, but the back end has always been MS Sql Server...

Working with parameters and prompting for user input, is there any way in XI to automatically prompt for input *every* time the report is opened and not having to refresh?<br/>Appreciate the help..thanks in advance..

Hi AllI have an external application that I connect to, unfortuantly for some reason both VB.net and Crystal Reports does not like connecting to it using Add New Datasource Wizard or the GUI's, so for my .net application I connect to it using code as follows.. Dim connectionstring As Str...

I've been trying to no avail to determine network folder read/write attributes, such as "Read-Only". I've tried GetAttr(), but it does not show the correct permissions on our network, even though looking at the folders properties page, it does show all the set attributes under the Security...

Hello all!I have a problem.How can I make a list in a grid control e.g.from pure text in textbox:"5316900043947001FFEC",1"5316900043947001FFD7",1"5316900043947001016D",0to a list in any grid control that will look like:------------| KPSL ID | FLAGS |------------| "5316900043947001...

I have a problem reading the ascii codes. Well I am trying to read the languages like Greece and Chinese characters. On my form I have received incorrect words something like this:?e?I am trying to get my experience for months to find ways how I could read ascii codes for my application. Maybe I sho...

I am creating an Image processing Application in which 3 or 4 Images are superimposed one over the other. I am using DrawImage function for displaying the images. I want to select the Images using Layer concept and change it properties such as fillcolor, size etc. and use sendtoback/bringtofront for...

I like to use the Frame control for grouping...but..i hate it for it doesn't have Transparent Backstyle...I wonder why the microsoft do not build the transparent backstlye for Frame like what available for LABEL... or at least the maskColor as available in Button...I read some work for transpa...

Crystal version ( crystal build in VB. Net 2005)Hi, can anyone help me here..My problem for almost one month..I have two tables in Access database...1.) FinalCustRSOFields:RSONO PK AutnumberCustomer textZeroStock textNewProduct textProjectForecast textWithMotherPO textOthers textRequestedBy textNote...

Can anyone help me out I am newbee at vba and I am having some problems adjusting to it although I do want to learn. Anywayz I am using access 2003 for my project I am working on check boxes. I have a table with two fields region having the data type text and selection having the data type yes/no. I...

Hi, i face a problem in printing a report from report viewer with two sub report.My report layout is as below:Parent Report-------Body SectionSubReport1 SubReport2I have successfully created the report and the result is correct.But when i come to the print preview mode or printing the report,...

I have 2 tables and i combined it in the query (MS Access) <br/>during displaying report it separates related Data by ID but it doesn't work with my code.<br/>any one idea on how to do it please..?<br/>Interested to post code if needed..

anyone have idea about SMS pizza ordering system using VB.net

hi, I'm having difficulty in waking up a MS Project 2003 file using vb.net 2005. I need to retrieve the data at each row of each column but I don't know how to map the column name in MS Project with the textbox in vb.net. I need your guidance. thanks<br/>KY

Hai,<br/>I have one database containing Names,Address and Mailid, and some other details.<br/>I want to extract all email id from the database and save it into the notepad.<br/>Can anybody help to solve this.<br/>Database is Ms Access 2000.<br/>I need help in Vb.net 2005.

Hi,Is it possible to print a PDF (or PCL) file to a particular printer tray?For example:Client A has their headed paper in Tray1Client B has their headed paper in Tray2The printers are not the same make or modelIs it possible to write an application that will save two settings (printer name and prin...

Hi guys ,I have a problem in vb6.0 i want to play a vedio file in our application but i want some method like that i play this vedio file in clips means firstly some part of that vedio file is load in the memory and play inbetween the remaining part of the file is also load in the memory and play me...

I have CR 8.5 Developer Edition installed in my PC. I'm using CRAXDRT.dll specifically in creating my report at runtime. The only thing that gets me stuck is setdatasource parameter. it gives an error, "invalid index", with error code -2147352565. I'm limited on using VB.NET 2005 and Cryst...

hi All, i am vb programmer.i am using crystal reports with vb my problem is that i want to create dynamic reports. let me explain.i am attaching my crystal report with vb and looking through crviewer.and then i perform merge pdf.but this thing is static .i want to change the position of my sub...

I have a proram that extracts images from an Oracle database. I query on some data attributes and a blob column. If there are more than a 1000 images to extract an issues araises. The pattern is pretty constaint at 1000 good extracted images then the next 400 image written to the filesystem are a du...

I am relatively new to programming.<br/> I am currently using two seperate projects, one being vb.net and the other csharp, and would like to combine the two to one form, or program. Is there some simple way of doing this?<br/>Any help would greatly be appreciated,

I just installed VB6.0 and i can resize the for. what i mean is there is no handles to resize with ill post a pic so you guys can understand what im talking about.<br/>navigate here > http://i169.photobucket.com/albums/u234/justwingit774/help.jpg

hiiiii need to know something. it would be great if anyone helps me ! i am making a dvd player sort of thing using the mswebdvd control... i have used its basic functionality to play, stop etc. they all work absolutely fine.. what i further want in this player is that i can search within the video...

I have a problem with the code. I am trying to read my ini string and trying to connect from the first item to the first frame but I have received an error: Run-time error '13': type mismatchHere is the code:Private Sub List1_Click()If List1.ListIndex = ReadIniFile(IniFile, "OPTIONS", "thi...

I've been looking around the MSDN about Bluetooth but all i've got was about Bluetooth connection between a computer and a mobile device. Now im wondering whether this is possible. Is it possible? How can it be done?

Hi, i am trying to run this program, but it sends error:No controled exception of type: 'System.Data.SqlClient.SqlException' in system.data.dlladditional info: system errori am using visual studio 2003 and sql server 2000what can i do to solve this?thanks...Imports SystemImports System.Dat...

Hi.....<br/> When I try to add a new row to a DataGridView in VS.net 2005, the new row is getting added with a row index of zero. <br/> How do I get it added as the lower most row with max row index?<br/> Thanks......<br/> GeoNav

Title InputToWin(BETA)License info You must credit the author. Author nameShane FindleySystem RequirementsME/2000/XP/Vista with VB2003 or 2005 1.1 or 2.0 .NET FrameworkDescriptionThis class can be used to send keyboard and mouse events directly to a window.It sends input events, to the specified win...

I've been looking at macro programs for what I'm trying to do, but I cant find any that work the way I want my process to work. I'm trying to find a program which I can hold down mouse button 1 and the program makes it so while mouse button 1 is being held down that it will be the equ...

Hai all,<br/>How can i insert / Paste a picture in to the "Internet Explorer_Class" window? a SendMessage() solution is preferred.