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 strongm 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. stillwillyboy

    IF condition in table or UI?

    In my jobs table, I have fields for Cust#, Job#, Step#, (which is just an ID number for data entry), StepCode (which is a two letter code determining how the step is paid), Units and some other info I am wanting it so that the user MUST enter some number of Units if the StepCode is PR and...
  2. stillwillyboy

    complex expression Q

    Denis/Boris, "Percent" and "Std" are keywords. DOH! Thanks.
  3. stillwillyboy

    complex expression Q

    Denis, Where in my procedure do I put the code? I keep getting a Syntax error message near “Percent”. I get the same error when I use Boris' code. This is what I am trying: SELECT dbo.tbl_TEST_TimesheetFile.Units, dbo.tbl_TEST_TimesheetFile.HoursWorked...
  4. stillwillyboy

    complex expression Q

    I am trying to achieve the following calculations and have the calc’d numbers appear in my query pane. Units/HoursWorked = UnitsPerHour ‘appears as desired PrevailingWage/STD = PieceRate ‘appears as desired UnitsPerHour/STD = Percent ‘doesn’t work UnitsPerHour *...
  5. stillwillyboy

    Aspx files won't open. Using VWD.

    ca8msm, Thanks. i did post the same Q and it was on the site for a while, but now it's not. I don't know what's going on. How do I do a system restore? What impact will this have on my system overall? Thanks.
  6. stillwillyboy

    Visual Studio in VB Express?

    I have VB Express 2005. Do I also have VS Express? When I select New Project, the Visual Studio templates do not appear. I put the VB disk in to do a reinstall and it told me that all of the options were loaded. I am wanting to use Visual Studio with ASP. I am also trying to get my Visual Web...
  7. stillwillyboy

    Aspx files won't open. Using VWD.

    I didn’t find a group for Visual Web Developer, but this is ASP related. I have been using VWD for a week or so and all was going well. Then I received an error message, but now cannot get it to reappear. It went something like: “An error was encountered when loading the document….Will be...
  8. stillwillyboy

    View test page in browser not working.

    I have installed the Visual Web Developer software. I had previously installed SQL 2005 Express and VB 2005 Express. I am running Win2K. When the setup for the web developer ran, it did not ask if I wanted to install the .NET Framework, the MSDN 2005 Express or SQL 2005. This seemed correct to...
  9. stillwillyboy

    Do I have Visual Studio to use with ASP?

    I am wanting to learn ASP. I have installed VB Express 2005 and SQL Express 2005. I have found on my PC the “Microsoft Visual Studio 8” folder with the subfolders: Common 7, Microsoft MSDN 2005 Express Edition – ENU, Microsoft Visual Basic 2005 Express Edition – ENU, MSDN Express Library, SDK...
  10. stillwillyboy

    Direction/help needed with forms and menus

    I'll give both a try. Thansk.
  11. stillwillyboy

    Direction/help needed with forms and menus

    I’ve looked through past posts and maybe I saw the answer, but I am not sure. I am wanting to use multiple forms that use the same menu. In other words, the menu items would be the same across the top of the form for ALL forms (including a “StartUp Form”). This is pretty basic Windows stuff...
  12. stillwillyboy

    Adding New Records and Tabbed Pages Q

    The client number is four digits (1000, 1234, etc.). I set the Compile Option Strict to “ON”. It was Off. I still get the error message: “InvalidCastException was Unhandled.” With the added line of “Conversion from string "" to type 'Integer' is not valid.” I tried changing to CShort from CInt...
  13. stillwillyboy

    Adding New Records and Tabbed Pages Q

    The following code is for the “Add Client Information” form. (There will also be a separate “Change...” and a separate “Delete…” form. If I can just get the Add, I think I can get the others.) Each of these forms will have three tabbed pages: “Basic Data”, “Additional Info” and “Work History”...
  14. stillwillyboy

    Every form own connection? -- Take 2

    After spending way too much time on wondering about the issue of if individual forms needed their own connection to a server and doing a bunch of reading, I have come to the conclusion that yes they do. Each time a connection is made, something is done with the data retrieved (something is...
  15. stillwillyboy

    Every VB form need its own connection?

    First, thanks for your help and patience. I understand what the error " ‘<<<receive error message “Value of type System.Data.DataSet cannot be converted to String” is telling me. I do not understand why it is telling me this. I thought that the function GetData was supposed to retrieve the...
  16. stillwillyboy

    Every VB form need its own connection?

    Caomao/Dan, Not working yet. What should I use in place of “senddataback = cmd2.ExecuteScalar“? It seems to me that using “Public Function get_data(ByVal SqlGetData As String) As DataSet” in both forms (or all forms for that matter) defeats the purpose of Class programming, but I’m sure I’m...
  17. stillwillyboy

    Stupid Q - Show grid lines on form in VB 2005?

    Close the form designer and reopen for effect to happen.
  18. stillwillyboy

    Stupid Q - Show grid lines on form in VB 2005?

    Tools/ Options / Windows Form Designer/General Layout mode = SnapToGrid ShowGrid = True SnapToGrid = True Had the same Q myself. Bill
  19. stillwillyboy

    Every VB form need its own connection?

    I have corrected two lines of code. I had the LastName and FirstName in the wrong order. The corrected code is: LastName = MyDSName.Tables("tbl_ClntBasicInfo").Rows(0).Item(1) FirstName = MyDSName.Tables("tbl_ClntBasicInfo").Rows(0).Item(2) When I run the code and get the error message and...
  20. stillwillyboy

    Every VB form need its own connection?

    I’ve adjusted my code to try and reference a “real” DB with “real” information. I have checked the DB name, the table names and the field names. I have checked the column references (1) and (2) for each table. 1 & 2 are the LastName and FirstName respectively in the table “tbl_ClntBasicInfo” and...

Part and Inventory Search

Back
Top