Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. caoamo

    App Start Behavior

    You could provide them with 2 different short-cuts, labeled appropriately. In the Properties page of the short-cut, just add the appropriate command line argument to the end of the "target" string.
  2. caoamo

    Database Decimal field changes in Crystal

    lbass I was having a boar of a time trying to format my decimal fields to drop insignificant trailing zero's but keeping the digits if they were significant. Your formula worked like a charm. Here's a star! Thanks!
  3. caoamo

    Button Access Key Behavior

    Does anyone have any advice for this situation? I have researched everywhere I could think of. Surely someone has ran across this before.... Thanks in advance!
  4. caoamo

    Button Access Key Behavior

    Hi all, I have a form which has several buttons on it. Each button has a unique access key set in the text property. (i.e. E&xit). The access keys work fine when alt is pressed, as they should. The problem is, that whenever any button on the form has focus, the access keys for ANY button work...
  5. caoamo

    Chart based off of a cross tab problem

    Hi, Crystal XI... I have a chart that is based off of a cross-tab report which counts the total of claims for each month by type. The cross-tab looks like this: Month HMO Traditional Total Jan 5 2 7 Feb 2 1 3...
  6. caoamo

    New to vb.net, need to close a form...

    The reason why the app closes, is by default, applications are set to exit when the start-up form closes. There is a setting in the applications configuration file that can be changed to application exit on all forms closed. Barring that change, you could also use your main form as the...
  7. caoamo

    Please check this for me

    How about putting your Timer_1 Tick code within an infinite loop in another Sub, and then calling that sub on another thread. Then just have the thread sleep for 1 second at the end of each iteration of the loop? Imports System.Threading Module Module1 Sub main() Dim timer as new...
  8. caoamo

    Every VB form need its own connection?

    OK, I missed the fields in your select statment. Still, Mydata will only pull the first column of your results, which is why you get "Smith". MyDSName is initialized, but never filled via a DataAdapter. You should be filling the dataset just like you do on form2, with the line: DA1.Fill(MYds...
  9. caoamo

    Every VB form need its own connection?

    I don't see anywehre in form1 where you fill the MyDSName dataset...Therefore it won't contain anything, thus the null reference exception. As a side note, according to msdn, using cmd.ExecuteScalar() only returns the item contained in the first row and first column of the resultant data from...
  10. caoamo

    Easy one about Me.Hide()

    Thanks, have a star :) One question...Why the preference of using Visible = False over Me.Hide()? Is it a performance issue?
  11. caoamo

    Easy one about Me.Hide()

    Excuse my ignorance, as I'm still fairly new to VB.NET.... I want to hide my start up form while the form gathers some data from the users computer. Why won't this work for hiding the form when the application loads? Private Sub frmResults_Load(ByVal sender As Object, ByVal e As...
  12. caoamo

    Service Account getting locked out

    What about data transfer limits? Perhaps the server limits data xfer per account on a daily basis?
  13. caoamo

    Format() doesn't seem to work

    How about Regular Expressions? I'm not that good at them myself, but perhaps someone else with a little more experience could provide some insight as to if Regex might be the way to go?
  14. caoamo

    Using Shell to do Windows/file based tasks

    Ahh, thanks for the correction, E&F.
  15. caoamo

    Using Shell to do Windows/file based tasks

    Err, got side tracked. the last line(s) of the code should be: Return files.join() End Function Or you could keep the MessagBox statement if you didn't need to return the value...
  16. caoamo

    Using Shell to do Windows/file based tasks

    Try having a look at the System.IO namespace. I think you'll find a number of useful methods to do what you wish. Here's a quick example. It's totally untested, but should work. 'Reference to System.IO namespace Imports System.IO 'function to print show all files in the current directory 'as...
  17. caoamo

    top / Left to X Y cordinates

    In addition to Rick's suggestions, I would drop the timer event, and set a boolean flag variable. Set it to true in the MouseDown event, and then in the Form's MouseMove event check the flag, and set the picturebox's location to the mouse's location. Set the flag back to false in the MouseUp Event.
  18. caoamo

    Data Access Layer with DataSet

    My initial thoughts are you are creating your connection in a sub. The connection will only have local scope for that sub. Try this: Public Function dbConn() As MySqlConnection 'comment this out if conn exists as a class member Dim conn As MySqlConnection Dim connStr As String...
  19. caoamo

    DB schema help

    Thanks for your reply. It certainly would make the joins easier with your approach. As is, I would have to programatically determine which tables to join based on the type of entry. A single SQL statement would be tricky. I was shooting for normalization, but I am no expert and probably could...
  20. caoamo

    DB schema help

    Hello all. I am creating a small backend DB for an application. The tables required number only a few, but I have some doubts as to the best way to set it up. I want to record a User ID and PW, along with journal entries, appointment information, and financial deadlines. My initial set up looks...

Part and Inventory Search

Back
Top