11,868 Topics
 | |
| | Hi I have data set where I find it easy to sort data by using pivot tables. BUT one essential cell is not a part of each sample ID. I have tried to make a macro to insert this data without luck. So in b column every time an empty … |
| | Hi Everyone, I have sheet with rows filled with text, and I copy each row and paste it in another sheet,(paste special transpose). I created a macor for this step. but how to add the loop code so it keep doing the same steps till empty. Thanks  |
| | hello, i am neha currently and 2 nd year It student required to do a mini project using vb as frontend and sql as backend i liked the idea of student database project can someone help me with its coding and gui screens plz its urgent only 2 weeks to … |
| | if i'm going to select the ID # from Stud Info View , i want automatically display the selected number in another form and display the number in Student ID in form of Add Subject , i need your presence please help me .. please.. |
| | I'm learning win32 programming from [Here](http://www.functionx.com/win32/Lesson03.htm) and I have problem in part of tutorial about string table it gives me this error: Run-Time Check Failure #0 - The value of ESP was not properly saved across a function call. This is usually a result of calling a function declared with … |
| | hi there everyone this sounds sily but i am trying to make a calendar which will show attendance on the calander what i want is to stop on the todays date txtbox txtboxes are arreys so the name is txtDay(0), txtDay(1), txtDay(2)........... txtDay(41) Dim strDate As String Dim strStartDate As …  |
 | hi programming masters! i need your help..how can i SEARCH a record in a database and display the results?? example: if i type an ID number or a name on the text box and click the search button it will look for the records and display it.. i have a …  |
 | Hi, I am running vb6 forms in vb.net. My question is that is there any way to populate variable in VB6 Form through VB.net Form? Actually I have a single form of Voucher. I have multiple types of vouchers and I am separating them by their character code like CPV …  |
| | I need some help created a google weather api using vb .net. I found the code online and there are no errors. Problem is that I can't seem to display wether information. Nothing shows up on screen and I am not sure what I did wrong. any ideas? Imports System.Net …  |
| | I'm currently have and excel speadsheet that has 3 rows. What I would like to do is create a macro that reads the last populated row, usually will be column A1, and then created a new column listing the current date and time. So for example, I have ColA ColB … |
 | Hi My vs stopped working everytime i click datagridview Probelem Signature: Problem Event Name: CLR20r3 PS 01:devenv.exe PS 02:10.0.30319.1 PS 03:4ba1fab3 PS 04:System.Drawing PS 05:4.0.0.0 PS 06:4ba1e086 PS 07:49 PS 08:1f PS 09:System.InvalidOperationException Locale ID:1033 Additional information about the problem: LCID:1033 Please Help, Thanks |
| | I am new at vb .net and I want to know how to make website in it? like connect two papes or using header in different file and linking it together etc.. for some reason when I create a page than vb studio automatic adds a form tag and creates …  |
| | Hi there Everyone I am writting a program POS in which i have employees database. they get a code or we can say employee ID numbers. 100001 100002 100003 now i want to keep the recourd attached with picture ID as well file names will be 100001.jpg 100002.jpg 100003.jpg as … |
| | Can any body tell me how can I detect Key press when my focus is not on the Form, Like I've Hidden The Form and I want to make it visible by pressing a single key or combination of keys I tried VBKEY case but that works fine unless I …  |
| | can you please help me in my code MsgBox "Are you sure you want to Logout?", vbYesNo, "Confirmation" If vbYes Then Unload Me frmAuthentication.Show End If how can i have 2 choices example i want vb no and just stay with my form help me.. |
 | Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks … |
 | Hi all ! I'm using vs2008, sqlserver2008 and vb.net as language. I would like to ask, i got this line of error when i'm debugging my code **----Too many arguments to 'Public Function getDrawingNumber(PlcCode As String) As System.Data.DataSet'.----** below is my program code : Protected Sub Page_Load(ByVal sender As Object, … |
| | Good day! I have a running code but I found it not very fast in terms of saving data. Is there a way to make it more faster? I am using msaccess as databse. Set RsTrandet = New ADODB.Recordset Sql = "SELECT TranDetail.AccountNo,cashflowcode, TranDetail.Narration, TranDetail.TranNature, " & _ "TranDetail.TranAmount, Acctmaster.Accountname … |
 | Hi Guys, At my work I been provided a QAAWS that will provide me with certain. For privacy reason I cannot give you the actual QAAWS but it is simila to [this one](https://liveoffice.etosoftware.com/dswsbobje/qaawsservices/biws?WSDL=1&cuid=Afg7hriNfChBslO9TDgBqLc). I know how to create a web service and pulled the data using my own SQl queries …  |
| | Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks … |
| | I'm coding in VB6. I have pictures in Picture1 and Picture2. I would like to replace the picture in Picture1 with the picture in Picture2. What code will get this done? Thanks.  |
| | hi guys.. i always got this error in vb6.. here's my code [CODE] '########### Variable declaration ########### Dim conn As ADODB.Connection Dim rs As ADODB.Recordset '########### Variable initialization ########### Set conn = New ADODB.Connection Set rs = New ADODB.Recordset strUserName = txtUserName.Text strPassWord = txtPassWord.Text connStringSQL = "MySQL ODBC 5.1 … |
| | Calculate the total parking charges based on the time of entry and time of departure of each vehicle. a. 1st half hour :0.20 b. 2nd half hour :0.50 c. subsequent half hour :0.80  |
 | i have done a project is a web browser uses a sql server 2008 as a back end so i want make setup file for that project to work in a computer that has'nt sql server , in onother word i want bind my database with the project and make … |
| | Group, I've created some spreadsheets that others use. The headings of the spreadsheets are divided up with colors. However after I've created these and saved them formatted as I like, some of these cells are changing automatically after the other users open them up. I've read online there may have …  |
| | Hi Group, I've recreated a spreadsheet that has multiple macro's behind it. One of these macro's opens and existing file, copies the data in it and then pastes it into the original workbook (where the macro's originate) and then closes the existing file. After the copy and paste is done, … |
| | I created a sample webservice that will ask the user for some information and return in JSON form all the information required. I have two issues here 1. I don't want to make it required that the user enter bot the new dates and renewal dates, I want to make … |
| | Hello all, I have created a pharmacy application in vb6, i packaged that, itselt has an access database. it works well in my pc, but when i want to send it to another computer, it installs there but dose'nt work there and says: C:// desktop/main/pharmacy.mdb is not a valid path, … |
| | in my vb6 application i face this error, Data Automation Error! No elements found, what is this belong to? |
| | When I try to recompile an OCX while in VB6 (run in Admin mode), I get "Permission Denied". I'm running Windows 7, 64 bit. I've already tried to set VB6.EXE to run in compatibility mode for XP SP3. I'm trying to create a new version of the OCX. I set … |
The End.