plz help how to update a MS Access DB through recordset with values from text boxes using JET.OLEDB.4.0 database engine.

Following code gives wrong answer;Option ExplicitPrivate Sub Command1_Click()Dim a1 As Single, b1 As SingleDim t As Singlea1 = 31.4b1 = 32.1t = b1 - a1Print ta1 = 1.4b1 = 2.1t = b1 - a1Print tEnd SubIt should print 0,7 two times, instead of that it gives 0,6999989 and0,6999999. If I change variable...

Ok, So I wanted to get this correct, I can inject a dll into MY own vb program, the dll is programmed in C++ and has this function:void __declspec(dllexport)__stdcall Send(UINT Message, WPARAM Wp, LPARAM Lp){ HWND hWND = FindWindow("MapleStoryClass", "MapleStory"); MSG Msg; Msg.hwnd = hWND; Msg.lPar...

Hi there,I'm working on a small project that requires me to load PDF file within a form. Just look at the picture below and you will get what I'm saying. http://img.photobucket.com/albums/v373/nightmareb/PDFform.jpgIf you have any solution, please let me know. Thank you...

I have a VB6 App using Access 2000 Database. Frequently, it will lockup on some of the users machines forcing the server to be rebooted.The server is actually just one of the PC's which shares its Access Database with 3 other users.When one PC locks up, it causes the others to stop functionin...

Many Point of Sale program use this format for flexgrid. I use vsflexgrid and i try to clone but i have problems.<br/>Please Help!!!

Hi guysI have a problem with my module, here is the code:Sub ReadLanguages()Dim Language, caption As StringLanguage = ReadIniFile(App.Path & "\EN.ini", "Language", "Language", "")Form1.caption = ReadIniFile(App.Path & "\EN.ini", "Language", "Title", "")ElseLanguage = ReadIniFile(App.Path & "\FR.ini"...

Hi everyone, I have two tables "TableA" and "TableB" TableA has 9 columns and TableB has 4 columns. I created a new table "TableC" with 5 columns. I want to copy 3 columns from TableA(with its data) to TableC and Copy one column from TableB to TableC . I added a new column to TableC and this column...

Hello all,Problem #1: Please could anyone show me the code to add a new worksheet to my existing workbook.Problem #2: I want to assign my old worksheet name to the new worksheet(NewxlWksht), then Delete the old worksheet(xlWksht)Below is what I'm currently doing:Set xlApp = CreateObject("Exce...

Hi there, Server Database: MS SQL Report Database: MS ACCESS Report Viewer: Crystal 9.0 I have a Report Viewer Program w/c i always install(Create Package) to each workstation every time i made modification. Is there a way (vb code) to install only this program once (t...

When I restore a minimized form from a command button on another visible form by frm.windowstate = vbNormal, the form restores and gives focus the the control on the form as it should. However when I attempt this same code from a tray icon, the minimized form pops into view, but NEVER gains focus...

I have a doubt to link USB BT-4500 scanners and USB keyboards with VB 6 programming.If one of you know let me know commands and way to link them together.<br/>thanks,<br/>Dulika

I have a collection that has an entry and a key.I can see if an entry exists by the Contains method.How do I get the index of the element so that I can use the item method? Can the index be the key (A string)How do you properly create this collection?Isn't:Dim myCol as Collectiongood enough?Mus...

I have the following problemhow do I change the backcolor of a tab of the SSTab objectIt has a property backcolor but that changes the backcolor of the object en not of the tab pageI would suspect there is a property somewhere, but if there is one it has eluded me.Does anybody know is there a proper...

Hi,<br/>I just wonder - Is it possible to have VB6 client listening to non-default event interface of a COM?<br/>It seems that 'WithEvents' keyword supports only default event interface. <br/>I'm not so familiar with VB. Please help.<br/>Thanks in advance.

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 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 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 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?...

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 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...

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,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 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 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

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 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.

Need an help to code events for the dynamically created combobox in VB. As the combobox is created and filled with data at runtime, now if we want to access any event of this combobox how to code for that event. Please if anyone can help me out .... Thanx

How can I get Excel to scroll so that a given cell, say f13, is the top left cell?<br/>Sorry for the noob question. I'm used to Visual C++. Thanks.

Say im designing a simple program heres what i want to do.<br/>type a number into a text box, shut down the program and when it reopens i want that number to stay there.<br/>This is so i can change "options" inside of my programs and the program will remember those changes when it re-opens.

Hi There,At the end of the program I want it take an image or save all the information of the form. But I would prefer an image. Probably a print screen? That's just a guess!I know how to do the whole Form1.PrintForm1 thing but is there a way I can save the image of the form so the user can h...

Can anyone here give me some advice on methods and strategy for maintaining and upgrading existing Access DBs as my VB6 (not NET) application develops and/or grows?The story goes like:MyApp.exe and my MyAccess.MDB are working fine together.Client asks for modifications that result in adding a Table...

Hello,I am having problem using CDONTS to send email through VB 6.0 App on WinXp machine. The problem I am having is that, when I use CDONTS in App, the App shows as if it generates the email. But email is not triggered until I log off from the Windows.The email comes to Inbox, only when I log off f...

I want to write a function to import my old database into a new database. The database consist of a number of tables (currently 14). In the function everything will work the same for each table except the select statement. This changes for each table. So there is a lot of code that can be reused on...