12,155 Topics
{Prescriptions.GlsType} Like "SV" and ( ((IsNull({Prescriptions.R_DV_CY}) and {Prescriptions.R_DV_SP}="+2.00") or (IsNull({Prescriptions.R_NV_CY}) and {Prescriptions.R_NV_SP}="+2.00") or (IsNull({Prescriptions.L_DV_CY}) and {Prescriptions.L_DV_SP}="+2.00") or (IsNull({Prescriptions.L_NV_CY}) and {Prescriptions.L_NV_SP}="+2.00")) ) i am having this type of recordselection formula but when i execute this if the First condition ***[((IsNull({Prescriptions.R_DV_CY}) and {Prescriptions.R_DV_SP}="+2.00") or ]*** becomes true then it is giving output, …
i am doing a project which will display real time ECG(electronic cardio graph) of the patient in vb6. i doint have any idea how can we use serial communication data to plot a continuous graph. thank you.
How can I make ONE database be updated from multiple terminals connected through a LAN network? How can I access the database through a LAN network in visual Basic 6?
please help me how to do it ,,, step by step please.... hahahahaha
i want to change the path so it saves to the current file location. so lets say my current file is 'Z:\cdrfiles\myfile\123'then it should save to the current file open Dim SaveOptions As StructSaveAsOptions Set SaveOptions = CreateStructSaveAsOptions With SaveOptions .EmbedVBAProject = True .Filter = cdrCDR .IncludeCMXData = False .Range …
Hi Everyone. It's been a while since I was on here last, but ran into an interesting problem with a nested for loop that I cannot solve. Hoping someone here will know the answer. I placed breakpoints in my code at the For x=1 to 10 line and after to …
-->>Hi everyone,I'm having this problem with updating records in my application my code is: SQL = "UPDATE Ministers SET User_Name='" & txtUser_Name.Text & "',Password='" & txtRetype_Password.Text & "',Prefix='" & cmbPrefix.Text & "',Passport='" & NewPicture_Name & "';" Call dbConnect Conn.Execute SQL Conn.Close Set Conn = Nothing -->>The SQL and Conn variables …
[FONT=Comic Sans MS]Hi everyone, I'm shreya. I'm doing my bca (bachelor in computer applications)-4th sem. I'm required to do a mini project on dbms using msaccess and backend as vb. I'd be glad if you can suggest a project. I have 3 months to complete this project. I hope I'll …
If I install a program that was created by Visual Basic 6.0 (via Package and Deployment Wizard), and install it on my computer, is Visual Basic 6.0 need to run that installed program?
I'm Kashif. I have some columnaised data in some 100+ workbooks; whereas each sheet contains some 25,000 rows. I want to use some particular rows where numeric (e.g 3009223468) or some name is repeated. Then these rows to be copied in a new sheet getting the name from the repeatitive …
I used the upsize wizard in Access 2010 to split my database with the table being on the SQL server. I entered this in the autoexec (was macro, I converted it) Function autoexec() oConn.Open "Driver={SQL Server};Server=JCPLMSQL01;Database=TestingConnection;Trusted_Connection=yes;" DoCmd.OpenForm "Form1", acNormal, "", "", , acNormal autoexec_Exit: Exit Function End Function I don't …
i want to make my project's look like windows 7 have..means glass interface, and buttons, all controls graphics like windows 7. i have searched alot, but i could not find...can u help me regrading this?
Hello everyone, I am trying to build a inventory ans pos systeme with Ms-Access as database and VB 6.0 programming. I got stuck in one place again. What I want to do is trying to print out the codes and price of the products. In this form, I have a …
Hi all, We use a .hta vbscript from a fileserver, but after office 2007 has been intalled, the script does not read/write from/to a .mdb file on that same fileserver. The script does work, if it started from a desktop instead of the fileserver. (reading/writing the same .mdb file on …
helllo... i need a code to receive sms on pc using at commands in vb6....urgent helpppp till now i have got this much bt i am stucked code== [code] Private Sub Form_Load() With MSComm1 .Handshaking = comNone 'make sure the serial port is not open (by this program) If .PortOpen …
Hi, I want to select a number with 0's after its decimal point. For example, if I have incoming data as 16.90, 17.00, 17.10, 17.20, 17.30, ......, 17.90, 18.00, 18.10, 18.20, ......., 18.90, 19.00, 19.10, ......... and so on. I want to select only numbers 17.00, 18.00, 19.00, ..... from …
I have a simple application in VB6 with two forms (i) A Start Up Form (ii) Application Form - which simply reads a text file and prints it. PROBLEM:- Everything loads ok from StartUp Form and Application also loads and "APPEARS" to work ok, but as soon as I try …
Good day! I have this query that produces 5000 list of items in 10 columns in list view. I found that it slowly load the items at about 30 seconds. Im planning to divide the result @ 1000 per list. Moving the list per 1000 by using adodc control. How …
I use MySQL database (innodb) I use Visual Basic 2008 I have a table Employees with two fields EmpNo and Managerno ALTER TABLE Employees ADD PRIMARY KEY (EmpNo CREATE INDEX index_Managerno ON Employees (ManagerNo) How do i now IF Mysql using this index is if i do this: SELECT * …
Hi All, There are many articles available that describe how textbox watermark can be done with the .Net framework(C# and VB.Net) I'm working on a VB6 project. How to implement this with a VB6 textbox?
Good day! How to move to a specific record base on the current recordset of adodc control? I have this employee_(empID, empName, EmpSalRate). I have load all employees data by using this code: dim Sql as string Sql="select * from tml_employee order by empName Asc" AdoDc.ConnectionString=Conn AdoDc.RecordSource=Sql AdoDc.Refresh Thus, I …
Please, i want to compare a column in table with 2 colomns in another table. Such dat if the values on the first column corresponds to the other then it will do something. I've tried SELECT * FROM tblToad frm d first table and then SELECT color FROM tblcolor, bt …
pls help guys i have the digital persona biometric i have the problem in getting the id i need id because im just use id to save into database plss help me tnx.
hii..sneha here , i'm studying in te-it, and i was in search for some interesting and innovative topics for my dbms project for which we have to use vb as front end & oracle as back end... so plss can u suggest me some of them.pls avoid regular & popular …
Hi there. I developed a program that creates Data Reports using this way : [Click Here](http://www.vbtutor.net/vb6/lesson40.html) But instead of using "Microsoft Jet 3.51 OLE DB Provider", I used "Microsoft Jet 4.0 OLE DB Provider" because when I used "Microsoft Jet 3.51 OLE DB Provider" it couldn't connect to the database …
We are atsked to create a net salary calculator or something that computes the net salary. I used three radio button in which if it is selected, it has corresponding solution for each selection. The three radio button are probationary, regular and permanent.......here is the code Private Sub Command1_Click() Dim …
can you give some example codes for forecasting inventory..
Greetings, I'm a bit new at Visual Basic 2010, and i have one main problem. I want to creat a Calculator for a game, however i have issues getting it to work. When i select a setting from my main Combobox i want it to add different settings for the …
I am having an issue with scrip deployment through GP on a 2003 domain. As well, I am also having an issue with placing this issue in the correct category. I have a BAT file that has the ability to modify a select registry key and force the change even …
Hi, Do you have any useful explanation of how to create a draggable window? What I wish to say is when you select your window will have no border ( considering that, it cannot be dragged around screen), how to make it draggable, for example by making a certain area …
Hello, Im new to VB and therefore i require some guidance in this tricky situation that im stuck in. Basically, what my program does is calculate the mach number of an aircraft when the speed of sound and value of temperature are added into the text box. The problem arises …
Hi IT Masters, I have a a VB6 exe applocatopm that **works perfectly** on the server **(MS Windows 2008 R2)** and to another computer. I just copy pasted the exe file and downloaded all dll files needed. (No installer of the app and there's no way to find it) But …
Please Help! I dont know how to use vbDatabaseCompare. I need it for my login form to work!
i need a intr0ducti0n ab0ut visual basic...any s0me0ne t0 help me... :'( ..
-->>Hi,I'm having an Access database (.mdb) with Members table and column Date registered just for an Example with datatype as text. -->>Now I have an Interface that I need to use it to get all registered members within the specified range of dates by using the Datepickers (1. Is for …
hi friends i am new in vb coding. i have two tables in ms access table 1 containing location column and id and table 2 containing id, name and date1, date 2...date 30 i have made form design in visual basic with "name" label with combo1 that selecting data from …
hello i need to read and store data from a device through serial port. i have searched the forum but havent found something which is really helping me. can anyone give me some resources or sample codes where i can figure out how to do it? thanks in advance. regards …
I'm currently creating a program where a user should enter the correct color shown in it. This should be entered in text box. What code should I use to make the program accept both upper case and lower case text inputs? For example "red" should be equivalent to "Red" something …
Hello All, I have shell script which runs on unix box but recently we moved to windows box. I am completely zero in VB script I need you guys help to convert the below script to VB Thanks in advance for the help. CheckQDepth() { arch_log_file=`ls $arch_dir |grep $FNPARAM | …
i am new in visual basic 6 so please help me.. this is the problem..we are asked to create a file in the MSexcel of a 5 rows by 5 columns..after that we are going to create an application to VB on how to open and save file using our …
Hello everyone, I am new to vb 6.0 and trying to build an inventory software. in the stock entry form I used a MSHFlexgrid, 10 text box and a add button. I want to various items in ten txtboxes and each time a click the add button it will be …
Hi, How add Crystal Report Version 11 in VB6. At present I have been using Crystal Ver 8. I need to upgrade to Crystal Ver 8.5 or above to implement exporting rpt's to pdf. Now, I have installed CRystal report 11 Developer edition in my system and from VB i …
Could you pls help me for making a script to route it to ' axtalm@alm.com ' , when a message come, if it is coming from extalm@alm.com and the subject of that message is nsn_ext_alm ?
XML,Excel Macros Hi I am working on some stuff where i need to Import the data present in XML file to excel sheet. i wrote below code for it Sub ImportXMLtoList() Dim strTargetFile As String Application.DisplayAlerts = False strTargetFile = "C:\BookData.xml" Workbooks.OpenXML Filename:=strTargetFile, LoadOption:=xlXmlLoadImportToList Application.DisplayAlerts = True End Sub But …
Hi All, I want to enter special character like signs of alpha beta gamma theta and store same in ms access database . How can it is possible. It is possible with MS Word because we can change fonts in single line. Thanks Alok Shrivastava
**Hi all. Im new to visual basic. im using vb 2008 express edition what im trying to do is take everything in my database and put it in my datagridview. The datagridview can be edited. From there, i want to make the changes then save them later. So my question …
Does anyone know of a way to invoke the DOS "ROUTE" command(s). I have written a .bat program that adds routes, but I want to take a particular interface from my ROUTE PRINT output and then ROUTE ADD the routes to that interface. Since that interface is dynamic due to …
Here's thought I had while working on a project for a Visual Basic class. First off, we were required to create an application that shuffled and dealt a poker hand of 5 cards out of a 52 card deck. The code we are using to generate the seed for the …
Hi,everyone I am trying to develop a simple program that will register Users with the following requirements as reflected with the fields on the interface: imgPassport.Picture ‘This is the Image for accepting Passport Size provided by the user lblPicture_Name.Caption = "User's Passport Size" ‘This is the Label to display the …
The End.