10,991 Topics

Member Avatar for
Member Avatar for Papa_Don

I need to identify how the code identifies that a file is at the "eof" (end of file). Here's why: On Monday's, I'm having to combine text files created over the weekend that will eventually be read and pulled into an Excel spreadsheet (generally there are three files). Using VB.net, …

Member Avatar for |-|x
0
444
Member Avatar for Nova6112

Hi, I'm developing VB6.0 Project using SqlServer2008. After completing the project if i'm using MsAccess the .mdb file will be stored in Package but when i'm using SqlServer Which file shouli use or how can i use sqlserver for using in other system which are not installed SQLServer2008

Member Avatar for JerryFJustic
0
129
Member Avatar for M.I.Sahil

AOA, I m using VB6 as front end and MS ACCESS 2010 as Database (DAO recordset) , I have created some Parametric queries in Access and also created some Crystal reports based on those queries, all this work find in designe mode, but when i compile the project and make …

Member Avatar for M.I.Sahil
0
450
Member Avatar for edzel joh

i am a student college ,we have a project that covers the inventory and pos i need help for giving me some advise to create this project using vb.net and ms acces

Member Avatar for Reverend Jim
0
317
Member Avatar for M.I.Sahil

Can anybody let me know, why i receive a (Runtime error 3319: Syntax Error in union Query), when I run the following union Query : sSQL = "SELECT 0 AS VoucherNo, #" & Format((txtFromDt), "dd/MMM/yy") & "# AS VoucherDate, " _ & "Vendors.VendorName, ""[Balance Brought Forward]"" AS Narration, 0 AS …

Member Avatar for M.I.Sahil
0
372
Member Avatar for PinoyDev

I am creating a table dynamically of which fields are date. I have a running code below but I want to remove those doble quotes in both sides.. If I remove the chr(34) on both ends, I get this error saving "invalid field defination". My code and table screen shots …

Member Avatar for PinoyDev
0
144
Member Avatar for Hari om
Member Avatar for Pompy

Hi i am trying to do this project for class and i have been stuck on it for a couple of days Here is the assignment **Array Assignment Write a program that allows the user to enter up to 20 Pro team names and then displays them. The user doesn’t …

Member Avatar for Santanu.Das
0
182
Member Avatar for bonzo2008

Can I save the information from common dialog Save as Jpg or Bmp format to an INI file and retrive it when the program starts. Now I have this line Image4.Picture = LoadPicture(App.Path & "\test.bmp") to load the picture. and it's not good. I would prefer to have that the …

Member Avatar for bonzo2008
0
254
Member Avatar for preciousjame
Member Avatar for TrustyTony
0
99
Member Avatar for PinoyDev

Good day! I just need a little help on how to get the last months date (dd/mm/yyyy) between two dates? I have two date pickers(fromdate & todate). Ex. If fromdate is 24/01/2015 and todate is 24/12/2015, it should enumerate the end of the months starting fromdate to todate. So the …

Member Avatar for PinoyDev
0
139
Member Avatar for PinoyDev

Good day! I just need a little help regarding my query..I need to get the opening balance by subtructing debit and credit column where date is less than fromdate(datepicker). But sometimes if the fromdate is a date without transaction, it still displays opening balance? I cant figure out whats the …

0
125
Member Avatar for bonzo2008

I will not that the code below shall count up or down '********************************* Sumtax For lngIndex2 = 1 To ListView1.ListItems.Count lngTot2 = lngTot2 + ListView1.ListItems(lngIndex2).SubItems(5) Next Text10.Text = Format(lngTot2, "###0.00") if I have say 83.67 in a listview then in the text10.text shall be the same amount no differens text10.text …

Member Avatar for bonzo2008
0
153
Member Avatar for Ash77

Hi all, Hopefully this is a simple question to you guys. I am trying to do the following: I have created a userform, in which I can select balance sheet items. The commandbutton of the userform copies the selected balance sheet items to Sheet2. Based on the number of years …

Member Avatar for rubberman
0
90
Member Avatar for Alessandro _1

I have Farpoint Spread 3.0 with VB6 and I succesfully populate the grid binding the control to an ODBC Oracle table and also the formatting works well. I need to change the data in the grid and save them automatically in the database. I activated the property DAutoSave = True …

0
86
Member Avatar for Papa_Don

Hi group, I've written some VBA code behind an Excel spreadsheet to check to see if another workbook is open. If it isn't open, I'm having the code open it for me. This works fine the first time the macro runs. However this same spreadsheet has a cell where a …

Member Avatar for Papa_Don
0
284
Member Avatar for krishom.ray

Dear Senior, I want to make a small application for inventory Management for my store keeper into he will enter stockout/Expiry/Return detail and through which he can find detail of present available stock and can cross check their all report with actual available stock. i can use VB through VS2013 …

Member Avatar for Santanu.Das
0
113
Member Avatar for tbzserge

Hi there, I have an excel sheet which contains CustomerPartNumber, MPN, CustomerPO,TotalReel,Company,Location,....as header. I need to print all the records which contain CustomerPartNumber, MPN, CustomerPO,TotalReel,Company data using barcode printer. I have succeessfully done this part. The problem is the header excel sheets that i receiving is not in a fix …

Member Avatar for clairestreb
0
138
Member Avatar for hello_2

Dear to all, How to make Regex match code for vb6 to extract domain names but only with related links like this.For example if i write the word "visual basic" then my program show me related links about the word "visual basic" in a list box. such as http://www.vbforbegginers.com http://www.vb.nethardturorials.info …

Member Avatar for clairestreb
0
191
Member Avatar for Pradnya_1

When you press a button I want to turn labels(with their current value) into textboxes.

Member Avatar for clairestreb
0
80
Member Avatar for Nova6112

Hi, I've developed and using one application in my System now i need to change some corrections in my application which is developed by VB6.0 and MS-Access, but unfortunately i lost my project file.Now i've only Package with setup only, How can i decompile my Application to get My code, …

Member Avatar for ddanbe
0
95
Member Avatar for reyarita

hey guys ! good day! guys i have a thesis project,enrollment system in high school den i have confuse with how to process in sectioning. sample guys if one student will enroll in one section (section galatia)den if the staff will click save button den if its done. then another …

Member Avatar for Vers20
0
837
Member Avatar for Xiao_1

when i click the btn assign the error come out where go worng? Private Sub btnAssign_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAssign.Click ListBoxall.Items.Add(ListBoxassign.SelectedItem) End Sub (**ArgumentNullExceotion was unhandld** *Value cannot be null. Parameter name: item)* the admin the listbox done not show up which part go wong …

Member Avatar for Santanu.Das
0
169
Member Avatar for fiaz ahma
Member Avatar for Nova6112

Hi, I'm developing application in vb6.0 with MS-Access. When i try to fetch data between two dates using DTPicker for Ex. i select 15-Jan-15 , 16-Jan-15 in DTPickers it selects only datas from 16-Jan-15 it's not select data from 15-Jan-15.I'm using the following Query : sql = "select * from …

Member Avatar for Nova6112
0
126
Member Avatar for xrjf

By means of Mates8, graph coding becomes a bit easier. The web page has four textboxes so the figure gets bounded to the left, right, top and bottom; and a draw button. Additionally, a panel control will contain the image generated by the code after the button is pressed.

Member Avatar for xrjf
0
564
Member Avatar for hacgor

I start programming in Vb6 a few weeks ago, and I have a big problem now… When I like to insert Date in .dbf table from my VB6 Application, I get the error: [COLOR="Red"][B]Malformed GUID. In query expression[/B][/COLOR] My SQL string: [COLOR="Green"]strSQL = "[B]INSERT INTO stok_sme (Date_time) VALUES ({^" & …

Member Avatar for Santanu.Das
0
1K
Member Avatar for muzingayemduduzi.ncube
Member Avatar for Nova6112

I've developed a simple banking system containing Deposite and Withdraw. I am using deposite,withdraw and balance are my database fields when i try to deposite the last balance fetched and then added with new deposite value i'm using (select last(deposite) from bank) this query to fetch last balance value . …

Member Avatar for Nova6112
0
176
Member Avatar for Nova6112

hi, I've developed a VB6.0 Application and i created Package. now i need to set Productkey or some systems which are allowed by me only can install my application... is there any techniques to do like this.. some of my friend told that we can do this using MAC address …

Member Avatar for Nova6112
0
129

The End.