I reinstalled VS.net 2003 Pro after a hard drive crash. Now it appears the Data Adapter Configuration Wizard is using double quotes instead of brackets for field names with spaces...example.
""Field Name"" instead of [Field Name]
This appears to be stopping the wizard from regenerating...
I cant get the second tier of a relationship to work. Here is the structure:
Setup Operations -> one to many -> Setup Fixtures -> one to many -> Setup Photos.
Setup Operations: PartId, OperationNumber
Setup Fixtures: PartId, OperationNumber, FixtureNumber
Setup Photos: PartId...
Above is an example of...
Resolved...Drawing on a jpg file in a picturebox.
I have simplified this project down to its basic function:
Load a jpg file into a picturebox - draw graphics on it - save it.
I'm confused on how to create the file to be saved from the background jpg and the graphics I have drawn over the top...
After loading an image file into a viewer form - in this case a blueprint - i need to capture the location of the mouse click.
On the mouse click event I need to print the value of an integer variable on the image.
I also would like to draw a circle around the number I add...
Here is my problem.
MS SQL Server 2000 on a Microsoft small business server has my database and all the security handled. I utilze group membership to restrict access to specific tables. The 'OFFICE' group, containing all the big whigs and payroll personell, has access to the 'WAGES' table...
anybody know how to read in Excel data when the Excel Spreadsheet has had the worksheet renamed.
ExcelCommand = New System.Data.OleDb.OleDbDataAdapter( _
"select * from [Sheet1$]", ExcelConnection)
How would you update the above code to get the data if [Sheet1$] has been renamed to...
I need to store the serial numbers used on parts. We assign a series of serial numbers to some of the parts we make. We keep track of which number we use in a log book sorted by part number. Almost all of our serial numbers for aerospace parts take the form of a 4 or 5 digit number that is Laser...
I have a table like this:
ShopFloorID = autoincrement key field
ShopNumber = integer
ShopNumberOpen = boolean
PartID = integer
OperationNumber = integer
OperationComplete = boolean
ShopNumber can have Multiple PartId's
PartID can have Multiple OperationNumbers
OperationComplete = False if the...
SQl before edit - RESOLVED in code
Is there a way to set up a SQL backend stored procedure that will not allow a record to be edited if the date is before a specified date?
It is an accounting type issue.
I want to have a table with one date in it (accounting date) that represents the date...
I have an SQL table called 'SHOPNUMBER'
There is a boolean/bit field called 'OPEN'
There is a date/time field called 'CLOSING DATE'
Here is the logic for these fields.
OPEN is true if the job is in process or there are finished parts left to sell.
OPEN is false when all parts produced by this...
I have sucessfully deployed my app to MS XP computers throughout my shop. I have sucessfully deployed the app to the Small Business Server. All apps run fine when installed on the local machine. I would like to have certain pc's in the shop run the app from the server (so I do not have to...
I have a form that has a date/time picker on it. When a date is picked a variable is set to the value. (dStartdate = StartDate.Text)
The next time I call the SetDate form (from the same calling form) I want to have it start with the date last chosen. (StartDate.Text = dStartdate). If I call...
I have an SQL dataset of time card records. I need to compute direct labor based on the "hours" value in this dataset.
I need a function - simple if statement that does this:
if (time card date) = saturday or sunday then
hours = hours * 1.5
We pay overtime on weekends.
How do I...
Delete all records of a dataset with partid = #####
I have 3 tables all linked by "partid" - dsPart1, dsOperation1, and dsRequirements1.
I need to select a partid from dsPart1 and load all corresponding records from dsOperation1 and dsRequirements1. No problems here.
I need to remove all...
I have a ComponentOne TrueDBGrid with the filter bar active. I want to filter the grid by some column and then use the filtered data in a Crystal report.
My first thought was to create a temporary data set and fill it with the record id's by looping through the grid. So far so good. Here is the...
I want to copy several rows from the details datagrid and paste them into the same grid for a different part number.
I can select the rows and copy them to the clipboard, I can paste them into Excel, but my knowledge of the clipboard class is limited.
How do I format the clipboard so I can...
I am using an inputbox to get a "partid" which is an integer. What code do I need to check if cancel is pushed on the inputbox. There is a conflict between string and integer. Cancel returns a string which can't be checked if the inputbox answer is set up for an integer. Do you know how to work...
I have a ShopNumber table that has a field 'Part Id' in it. This field is a direct reference to an autoincrement field in the PartNumber table. This field is just a pointer and has no meaning to the user. What I need is to substitute the 'Part Id' for the corresponding 'Part Name' field in...
In an Inventory dataset I have an integer field "quantity". This field contains positive values when pieces are added and negative values when pieces are used. I am displaying the records in a datagrid and I want the "total pieces on hand" displayed in a label on the form.
How do I total the...