• Member Avatar for cgeier
    cgeier

    Replied To a Post in I could really use some advice

    Also, what happens when two or more users have the same first initial and same first 4 letters of the last name? example: * Michael Richardson * Matthew Richards Or …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Memory Issue- or app issue?

    You could probably write your own installer in less time than it takes to troubleshoot the one you are currently using--considering you have to wait for response from someone else.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Binding

    Call "Refresh" method. labelName.Refresh()
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Memory Issue- or app issue?

    In that case, I recommend that you contact "InstallSimple" for support. You will have to work with them to identify the issue.
  • Member Avatar for cgeier
    cgeier

    Began Watching Memory Issue- or app issue?

    I have a quick question- I have an app that is downloaded a lot and used lots without issues. Recently an officer from the US Forest Service downloaded it, and …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Memory Issue- or app issue?

    First of all there should be a way to exit the program without having to kill the process (in my opinion). There are two versions of .NET 4--client and full …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Text Files

    I recommend you use an XML file (or a database) instead of a text file. You are using characters that could possibly be in the username or password ("-", "*").
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Thanks in advance

    PerplexedB: You can't do the following: int positionSeparator = line.IndexOf("-"); if (line.Substring(0,positionSeparator) == name ) { It will throw an exception for any line that doesn't contain a "-". `positionSeparator …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Text Files

    To answer your original question: foreach (string line in lines) { string trimmedLine = line.Trim(); if (trimmedLine.StartsWith("-")) { int ID = line.IndexOf("-"); if (line.Substring(0,ID) == lines[i]) { if (trimmedLine.StartsWith("*")) { …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Text Files

    The error isn't occuring on the line that contains "-". It is occuring when a line does NOT contain a "-". You didn't post enough of the text file. You …
  • Member Avatar for cgeier
    cgeier

    Began Watching Text Files

    namespace Project { public partial class Chapter_Login : Form { public Chapter_Login() { InitializeComponent(); } private void btnLogin_Click(object sender, EventArgs e) { StreamReader Chapter = new StreamReader("Chapters.txt"); Chapter.ReadLine(); string[] lines …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Text Files

    [String.IndexOf Documentation](http://msdn.microsoft.com/en-us/library/k8b1470s.aspx) **Return Value**: *The zero-based index position of value if that string is found, or -1 if it is not. If value is String.Empty, the return value is 0.* …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Remote Access

    If you host it on your computer you will need as static ip address. Or a domain name that will always resolve to your current ip address. If using a …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Remote Access

    You'll want SQLEXP_..._Enu.exe and SQLManagementStudio. Although SQLEXPWT... may contain SQLEXP... and SQLManagement...
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Remote Access

    For VS2010 you will need to use Sql Server Express 2008.
  • Member Avatar for cgeier
    cgeier

    Began Watching Remote Access

    Hello, I wrote a program in vb2010 to assist in the organisation of my music school. It's fairly simple (as am I), uses a text file to store data, and …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Remote Access

    How do they access the program now? Taking turns using a single computer? Does each teacher have his/her own text file or do all of the teachers use one text …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Syntax error in INSERT statement

    Below is a link to an example using named parameters with OLEDB in Access 2007. [Access 2007 OleDb with parameters example](http://code.msdn.microsoft.com/windowsdesktop/access-2007-oledb-with-2fed4cc1) [2007 Office System Driver: Data Connectivity Components](http://www.microsoft.com/en-us/download/details.aspx?id=23734) The "Create …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Syntax error in INSERT statement

    Here's a copy of the project. It uses .NET 4.0. 1. Build it. 2. Run it. 3. Click button to create database (CreateDB-Access). 4. Click button to create table (CreateTbl-Access). …
  • Member Avatar for cgeier
    cgeier

    Began Watching Select Query fails to retrieve from multiple tables in Access

    Hi, I am new to VB programming. I am using Aceess 2010 database with VB 2010. I have one main table which stores information of company details. The details are …
  • Member Avatar for cgeier
    cgeier

    Began Watching Database path not working properly

    Hi guys, I just faced a silly but annoying problem.I was building a database application with vb.net and access. Things were going great but at the last moment,it started to …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Database path not working properly

    It's difficult to know what your code is doing unless you post your code.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Syntax error in INSERT statement

    Although...I also have success with using named parameters with OleDb using the following: Imports System.Data.OleDb Public Module AccessDB Public dbName As String = "Inventory" Public connectStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\" & …
  • Member Avatar for cgeier
    cgeier

    Began Watching Syntax error in INSERT statement

    Hi all, Hi i have got a problem with the system i am creating on VB using Microsft Access. I have this error that keeps coming up when I debug …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Syntax error in INSERT statement

    [Using Parameters with an OleDbCommand or OdbcCommand](http://msdn.microsoft.com/en-us/library/yy6y35y8(v=vs.90).aspx) *...The .NET Framework Data Provider for OLE DB and .NET Framework Data Provider for ODBC do not support named parameters for passing parameters …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Connecting MS word to print a form in vb.net

    Create your report as a Word document using "Microsoft Word Object Library" (Microsoft.Office.Interop.Word).
  • Member Avatar for cgeier
    cgeier

    Began Watching NullPointerException when inserting item into a linked list

    I'm trying to create a sorted linked list without using Collections. I don't want to use Collections since I'd like to learn how to work with Linked List manually. I'm …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Connecting MS word to print a form in vb.net

    [How to automate Word from Visual Basic .NET to create a new document](http://support.microsoft.com/kb/316383)
  • Member Avatar for cgeier
    cgeier

    Began Watching Storing data in database

    I have created three tables used dataset to generate fields when i enter data it does get stored but when i close application and then reopen data doesn't show.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Storing data in database

    Please post your code.
  • Member Avatar for cgeier
    cgeier

    Began Watching Loading default value into datagrid

    I'll be completely honest, I haven't googled this very much as I have no idea of how to put it. So a nudge in the right direction will be most …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Loading default value into datagrid

    How is the second form opened? Does the first form open the second form? If so, create a constructor in the second form and pass the data in the constructor. …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in DB issues when dropping DB and inserting test data

    "Show" is not modal (ex: adminFrm.Show()), and execution continues after the form is opened. "ShowDialog" is modal, and further execution does not continue until the form is closed (ex: adminFrm.ShowDialog()). …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in DB issues when dropping DB and inserting test data

    The following changes will disable the timer while using the Adminstration form, and re-enable it when the Administration form is closed. Private Sub AdministrationToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in DB issues when dropping DB and inserting test data

    Rather than changing the database name in the connectStr like this: Dim lConnectStr As String = connectStr lConnectStr = lConnectStr.Replace("Database=" & dbName, "Database=master") lConnectStr = lConnectStr.Replace("Catalog=" & dbName, "master") Using …
  • Member Avatar for cgeier
    cgeier

    Began Watching DB issues when dropping DB and inserting test data

    Hi All, Having a few issues with some DB functions in my code at the moment. This code was developed by another user who kindly helped me out, and I …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in DB issues when dropping DB and inserting test data

    I added some functions to 'SQLExpress.vb' to check if the database exists, to check if a table exists, and modified "DropDatabase" as described above. **DatabaseExists:** Public dbName = "ShiftRota" Public …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in DB issues when dropping DB and inserting test data

    When clicking on "Drop Tables", you need the offer the user the opportunity to cancel, in case the user accidently clicked the button. **Issue:** The error "Error (Open Connection): Error …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in DB issues when dropping DB and inserting test data

    Your original error was occuring in lines 26-31 above. You had the following: Dim paramName2 As SqlParameter = New SqlParameter() paramName1.ParameterName = "@finish" paramName1.SqlDbType = SqlDbType.DateTime paramName1.Value = finish sqlCmd.Parameters.Add(paramName2) …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in VB.NET 2010 Developed apps not working on win7

    Other than installing your program in %ProgramFiles%, you should not be writing to %ProgramFiles% (or HKEY_LOCAL_MACHINE in the registry). Use one of the following directories to store your data: Dim …
  • Member Avatar for cgeier
    cgeier

    Stopped Watching Syntax error in INSERT statement

    Hi all, Hi i have got a problem with the system i am creating on VB using Microsft Access. I have this error that keeps coming up when I debug …
  • Member Avatar for cgeier
    cgeier

    Began Watching Find and replace in text File

    Hello, I need a litle help here. I am creating a program that finds a specific sentence in a word path and replaces it with a given value. Specific sentence: …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Find and replace in text File

    Something like the following should work: 'path from original file Dim source As String = "C:\temp\regextest.txt" 'path new file Dim destination As String = "C:\temp\regextest2.txt" Dim newText As String = …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Display Week Ending Date

    Dim dt As DateTime = DateTime.MinValue dt = DateTime.Now.AddDays(7 - Weekday(DateTime.Now) + 1) Console.WriteLine(dt.ToString("MM/dd/yyyy"))
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Syntax error in INSERT statement

    Numerical values don't use quotes--only for text values. Remove single-quotes from Quantity, Min Shelf Stock, and Purchase Price.
  • Member Avatar for cgeier
    cgeier

    Began Watching Display Week Ending Date

    How do you display the week ending date (Sunday) in VB10? When a form loads, I want to display the upcoming Sunday date in a label. In VB6 I used …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Display Week Ending Date

    Dim nextSunday As Integer nextSunday = (DateTime.Now.AddDays(7)).Day - (Weekday(DateTime.Now)) + 1
  • Member Avatar for cgeier
    cgeier

    Began Watching reading all store in outlook

    hi all i've been strugling with this error. could someone help me. below is the code stremail = "some@email" For Each store In outlookapp.Session.Stores strchecking = store.DisplayName outlookfolder = store.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox) …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in reading all store in outlook

    Try posting more of your code. What version of VB .NET? What version of Outlook?
  • Member Avatar for cgeier
    cgeier

    Began Watching Syntax error in INSERT statement

    Hi all, Hi i have got a problem with the system i am creating on VB using Microsft Access. I have this error that keeps coming up when I debug …

The End.