Search results for query: *

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

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 *...

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

When using VB 2005 and a SQL 2005 DB, does every VB form need its own connection to the DB or if one form in the project is connected, are all forms automatically connected through the one form? TIA Bill

I am trying to join three tables and pull some info. With the following code, I keep getting an Exception error stating Incorrect syntax near '.'. The exception error is pointing at the line: m_daDataAdapter.Fill(m_dtClients) (Please note that there are proper line continuations in my code...

When using VB 2005 and a SQL 2005 DB, does every VB form need its own connection to the DB or if one form in the project is connected, are all forms automatically connected through the one form? TIA Bill

I am trying to join three tables and pull some info. With the following code, I keep getting an Exception error stating Incorrect syntax near '.'. The exception error is pointing at the line: m_daDataAdapter.Fill(m_dtClients) (Please note that there are proper line continuations in my code...

I am trying to “convert” some code in Sam’s Visual Basic 2005 Express book. I am trying to connect to a SQL 2005 Express db. The code in Sam’s is for connecting to Jet. I’ve looked at some of the other connection Q’s and replies on this site, but being a newbie, well….. Here is my code with...

In a sales report showing invoices, debits, credits and related numbers and dollar amounts, I need to move the debits and credits to the bottom of the sheet and then delete the empty row that held the debit and/or credit. I can get the item moved, but then the cell (row) that received the...

Hello, I just purchased a Sams Teach Yourself MS SQL Server 2005 Express Book. It came with a CD for the VB Express and SQL Server Express. I put the CD in the tray and began the setup. I asked that everything be installed from the CD (at least I think I did). The install seemed to go OK, but...

I am wanting to use VLookup during the process of data entry to verify that a record exists. I have tried the following but it always goes to the MsgBox. I have verified that the client number that I am entering does exist on the sheet ClntInfo in the named range ClientInfoAll. What am I...

I am using Input Boxes for entering the employee number, job number, hours and units (if units are needed) onto a sheet. I’m trying to use a GoTo statement to skip over the entry of units if the job is straight time, as opposed to piece work. When entering the employee number, job, hours and...

I have the work date, employee number, name, and some other info with headers all starting in A1. Work Date Numb Name Hrs 04-03-06 1234 Bob 6.0 04-04-06 1234 Bob 6.0 04-05-06 1234 Bob 6.0 04-06-06 1234 Bob 6.0 04-07-06 1234 Bob 6.0 04-03-06 4567 Joe...

I am needing to insert two rows after a change in an employee number. I will then need to do some calculation for each employee, i.e. adding up hours and pay. Example: 04-03-06 1234 Bob 6.0 04-04-06 1234 Bob 6.0 04-05-06 1234 Bob 6.0 04-06-06 1234 Bob 6.0 04-07-06...