Search results

  1. DavidT_macktool

    VS.net 2003 Pro reinstall

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

    Database Diagram - Cascade relationship

    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. Keys: Setup Operations: PartId, OperationNumber Setup Fixtures: PartId, OperationNumber, FixtureNumber Setup Photos: PartId...
  3. DavidT_macktool

    Variable length text

    G10L41T20P0C15D1.2S1I0E1.2H4.7262K0.J0Q1450N00000001 G10L41T21P0C19D0.87S1I0E0.875H5.9386K0.J0Q884N00000001 G10L41T22P0C2D0.53S1I0H7.3233K0.159B0J0Q236N00000001A0. G10L41T23P0C15D0.25S1I0E0.25H7.2087K0.J0Q0N00000001 G10L41T24P0C15D0.75S1I0E0.75H7.4646K0.J0Q5253N00000001 Above is an example of...
  4. DavidT_macktool

    Drawing on a jpg file in a picturebox.

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

    mouse click event on Image

    Project requirements: 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...
  6. DavidT_macktool

    Security for MS ACCESS

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

    Get Excel data when there is not a 'SHEET1'

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

    How to handle serial numbers with leading zeros.

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

    Need help with Select statement

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

    SQl before edit

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

    Need some ideas for limiting updates...'

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

    Run from MS Small business server

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

    Date form - check for null

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

    Day of the Week function

    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 end if We pay overtime on weekends. How do I...
  15. DavidT_macktool

    Delete statement

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

    ComponentOne Filtered DataGrid to Crystal Report

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

    paste datagrid rows

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

    Inputbox integer:

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

    Display a foreign field in grid?

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

    Total the qty column in a datagrid

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