Posts
 
Reputation
Joined
Last Seen
Ranked #2K
Strength to Increase Rep
+5
Strength to Decrease Rep
-1
100% Quality Score
Upvotes Received
7
Posts with Upvotes
3
Upvoting Members
6
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
3 Commented Posts
4 Endorsements
Ranked #402
Ranked #4K
~27.5K People Reached
Favorite Tags
Member Avatar for themaj

I have an old SSD (150mb) running Win7 along with 3 other HDDs. I disconnected everything , installed a new 480mb SSD and a new licensed copy of Win7. If I reconnect the old SSD will I have the ability to select which drive to boot from? What really important …

Member Avatar for rubberman
0
168
Member Avatar for themaj

Just a quick question here for VB.NET developing with Visual Studio. I have an existing project (Project A) and I want to use portions of it as a foundation for another related project (Project B). How can I safely copy Project A to another location, rip out unnecessary forms, code, …

Member Avatar for Santanu.Das
0
294
Member Avatar for themaj

A question for VB.NET - Access DB folks here, although some might consider a strictly DB question. Is there an order of operation when a SQL query 'does its' thing' relating to the 'WHERE" clause with multiple parameters? In other words, could you rearrange the elements [filters] of the WHERE …

Member Avatar for pritaeas
0
233
Member Avatar for laxminarayan23

i am creating a software for using acceess database but not configuratuion please help me

Member Avatar for themaj
0
71
Member Avatar for themaj

Having another brain fart on what I believe is a no brainer. I'm trying to read the contents of a DBF and write it to an ACCDB table; this is a daily event and the DBF has between 500-1200 records each day. I have successfully read the contents of a …

Member Avatar for ss125
0
280
Member Avatar for themaj

My current VB.net project involves a 2003 Access db and I have now upgraded one of my machines to Access 2007. Before I upgrade the other I'm wondering whether there are any significant issues with my present VB.NET code that might render it 'broken'. Are there any connection issues I …

Member Avatar for Begginnerdev
0
247
Member Avatar for themaj

I have a database table that is a catalog of each day of business (DOB) for my 3 'stores' ranging over a year. Other than the Store ID and DOB, all other data here is irrelevant for this discussion. The data entry of this table is not necessarily in chronological …

Member Avatar for Reverend Jim
0
296
Member Avatar for themaj

Need a little help on this since it seems to be vastly different than VB6. I have multiple forms and would like to set the Startup Position of secondary forms (form2 & form3) slightly lower, and to the right of the primary form (form1); similar to the 'cascade' effect in …

Member Avatar for Luc001
0
501
Member Avatar for themaj

I am trying to insert new records into an Access DB and getting some weird stuff. I get the data from a DBF table and load that into a dataset table and DataGridView with no problems. Then I loop through the ds.table and insert it into the DB with this …

Member Avatar for Reverend Jim
0
201
Member Avatar for lkallas

Hello! I am developing an application for my employer. I am not a programmer but I do it as a hobby. The story is as follows: we have a store that sells lawn tractors and riders. Every lawn tractor has a serial number, product code etc. I am trying to …

Member Avatar for Reverend Jim
0
174
Member Avatar for paoi00

i had a problem with this codes.. this codes will retrieve image from database that will based on the employeenumber. Dim CN As New OleDbConnection(cnString) CN.Open() daImage = New OleDbDataAdapter() daImage.SelectCommand = New OleDbCommand("SELECT * FROM EmployeeProfile ", CN) dsImage = New DataSet("dsImage") Dim dataTable As DataTable = dsImage.Tables(0) If …

Member Avatar for Pgmer
0
1K
Member Avatar for vivekanandaan

Dim conn As New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = e:\wms\wms\wms.mdb") conn.Open() Dim userDetailsAdapter As New OleDbDataAdapter("select * from daily_trans", conn) Dim userDetailsTable As New DataTable userDetailsAdapter.Fill(userDetailsTable) Dim returnRows() As System.Data.DataRow = Nothing returnRows = userDetailsTable.Select("cons = " & TextLine) If returnRows Is Nothing Then MsgBox("Can be saved") Else MsgBox("Primary Key") End If …

Member Avatar for Pgmer
0
86
Member Avatar for themaj

Can someone tell me how to add an additional item to a combobox that is bound to a datatable? I have populated the ComboBox with data from table sSQLCbo = "SELECT region.ID, region.name FROM [STORES] ORDER BY store.ID" Dim ds As New DataSet da = New OleDb.OleDbDataAdapter(sSQLCbo, con) da.Fill(dt) con.Close() …

Member Avatar for Pgmer
0
490
Member Avatar for themaj

I'm trying to read a DBF file into a DataSet and then write a selected number of columns to a MDB. I've been successful reading the DBF into the Dataset with this code; Public Sub sReadDbf(ByVal dbffile As String) mydbfConn = New System.Data.OleDb.OleDbConnection mydbfConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ sAlohaPath …

Member Avatar for themaj
0
189
Member Avatar for themaj

I have a DBF file with 1400+ rows and 32 columns and I need to write this to an Access DB table. The Access table was created by modifying the original structure of the DBF table in which I removed 12 unnecessary columns. I have been successful at loading the …

Member Avatar for kRod
0
707
Member Avatar for themaj

Can you Close or Exit an application from within a Sub or what would be the 'best practise' for Exiting when the app has failed a logic test? My app checks for the existance of various files in a Sub Routine off the Form_Load and writes to a log along …

Member Avatar for themaj
0
5K
Member Avatar for themaj

I have a dataset (GrindItems) with 4 datatables successfully populated from dbf files. If I understand the concept of a dataset, I no longer need an open connection to the source db and I should be able to query my dataset. My first question is whether I need a Connection …

Member Avatar for themaj
0
2K
Member Avatar for themaj

Can anyone please advise me on which version of Microsoft .NET Framework is needed for an XP SP2 (32bit) machine to run a VB.NET app developed on Microsoft Visual Basic 2010 Express? Feel a tad stupid about not checking :(

Member Avatar for M.Waqas Aslam
0
297
Member Avatar for themaj

I need to start my VB.NET app through a batch file and pass an argument to it. The app uses the argument (a dated directory;Ex: 20120530) to process the data files there, output a CSV and a Log file and then close the app. The app does not need any …

Member Avatar for themaj
0
366
Member Avatar for themaj

Trying to figure out the best way to do create a CSV export file from my source files and need some input. I'm trying to build a CSV export file for import to an Accounting System where there are 3 different tables mapped to a single field in the main …

Member Avatar for themaj
0
267
Member Avatar for themaj

I initiate OpenFileDialog from a btn and once the correct file is selected at OpenFileDialog1_FileOK * ,I want to load Form2 to do some file checking routines. Private Sub OpenFileDialog1_FileOk(sender As System.Object, e As System.ComponentModel.CancelEventArgs) Handles OpenFileDialog1.FileOk dbfFileFolder = System.IO.Path.GetDirectoryName(OpenFileDialog1.FileName) dbfFileName = System.IO.Path.GetFileName(OpenFileDialog1.FileName) dbfFileNameShort = System.IO.Path.GetFileNameWithoutExtension(OpenFileDialog1.FileName) If dbfFileName = "GNDITEM.DBF" …

Member Avatar for Reverend Jim
0
2K
Member Avatar for Reverend Jim

Please read through the following suggestions before posting in this forum. Questions in this forum are answered by people who generously volunteer their time. Following these guidelines will increase the chances of getting a quick and accurate answer. 1. Use Search to see if your question has been asked and …

Member Avatar for themaj
17
1K
Member Avatar for themaj

Situation: need to read a CSV (txt) file that has no header and has 4 fields (all numeric), the number of lines will vary. Sample data: 160827,00003,000000075,0000025 84144,00001,000000050,0000050 161060,00002,000000050,0000025 40015,00002,000000100,0000050 61955,00002,000000100,0000050 etc etc I want to read this file into a DataGridView for proofing and later insert all these lines …

Member Avatar for themaj
0
9K
Member Avatar for themaj

Back on my form with a ton of financial data entry textboxes but I want to have the data formatted at runtime, as I enter the data. I have a format declared as Public Const cFmtCurrency = "##,###,###" ' don't need decimal for the local China currency What would be …

Member Avatar for themaj
0
338
Member Avatar for themaj

I have a Function for checking the input in a textbox and only allowing Numeric & Backspace; everything works fine so far. My form is for financials and it has about 20 textboxes; they all receive Numeric only data; there is NO alpha data on the entire form required. Note …

Member Avatar for themaj
0
152
Member Avatar for themaj

Haven't been around here in a long time but have returned to hear your thoughts and suggestions regarding my problem. I had been dev'ing projects in VB6 until around 2006 when I stopped all my development. Mainly it was a change in responsibilities but it was also because I had …

Member Avatar for codeorder
0
139
Member Avatar for amby

i want to convert string into byte....this can be done in vb.net..can somebody help me in doing this in vb6.0..here the simple code.. Private Sub Form_Load() Dim str1 As String Dim i As Byte i = CByte(Val(str1)) Text1.Text = i End Sub but this code still not able to convert …

Member Avatar for boopathi33
0
308
Member Avatar for mariegomez84

Hi, everybody! I'm working in Visual Basic 6 (NOT for excel application). I'm quite new in this and I'm trying to plot some curves in a graph. The point is that when I plot the curve the second time, the curve for the first time is still there!!! And I …

Member Avatar for mariegomez84
0
927
Member Avatar for mark0420

can anyone help to create a program that is school-friendly. and can anyone plz make me a project just simple program that can make me famous in our school plz

Member Avatar for technogeek_42
0
136
Member Avatar for themaj

Hope there are some good gurus out there that can lend a hand to this discussion. 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 …

Member Avatar for themaj
0
205