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...
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...
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 *...
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.
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...
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...
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...
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...
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...
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...
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”...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.