- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 7
- Posts with Upvotes
- 3
- Upvoting Members
- 6
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
31 Posted Topics
 | 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 …  |
| | 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, …  |
| | 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 …  |
 | Re: help @laxminarayan793 I think you should first read the "Please Read This Before Posting" above your post. Our forum members are really good at helping people solve problems but your post doesn't give anyone a clue of what you need. Yawn, |
| | 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 …  |
| | 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 …  |
| | 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 …  |
| | 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 …  |
| | 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 … |
 | lkallas, First of all you should stop and rethink your plan after reading Jim's responses. I did this exercise 5 years ago in VB6 and the initial DB design is very critical! It's really, really hard to back peddle after the DB starts taking on data. You need 1 (one) … |
| | You didn't say what the error message is but where in your code did you create a NEW datatable like: Dim dataTable As NEW DataTable = dsImage.Tables(0) |
| | Where exactly is the error; which line number? First try this: "SELECT * FROM [daily_trans]" |
| | 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() … |
| | 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 … |
| | 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 …  |
| | 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 … |
| | 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 … |
| | 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 :(  |
| | 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 … |
| | 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 … |
| | 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" … |
| | Here, here! Sorry, MSgbox("Here, here!!") |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 …  |
| | Can you be more explicit as to what your ultimately trying to do? What 'string' are you trying to convert....can you give example? Just curious but why do you want to convert the string? Try this and tell me what happens. If bad stuff, revert to above questions and reply. … |
| | It would depend on what 'chart' you are using....is it MSChart from the MSChart Control (MSCHRT20.ocx)? If so did you try: myChart.Data = 0 Let me know if that works for you :) |
| | mark0420, It appears that you're figuring this development 'stuff' out and moving forward. First it was a keylogger then a C++ game then a VB.NET game now it's a VB6 game By the time you get to Basica you'll be well on your way to actually learning about the development …  |
| | 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 … |
| | Just like Ryan said just enter the code for each CASE. In this case (yuk, yuk, yuk) I don't think your saving anything by using Select Case. Here's the first 3 CASES in code, I'm sure you can handle it from there. [CODE] Private Sub cmdGo_Click() Dim postA As Single … |
The End.