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!

Register Log in
  • Congratulations Chriss Miller 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. robert693

    Use Split() function to separate multiple values in a string separated by a semicolon

    How can I get the results to print out to new rows instead of within the same text box?
  2. robert693

    Split a database field delimited by a semicolon

    If I have the following code, how can I use it to separate values in a field in my database? declare @xml xml, @delimited nvarchar(max), @delimiter nvarchar(10) set @delimited = N'a,b,c,d,e' set @delimiter = N',' set @xml = N'<root><r>' + replace((SELECT @delimited FOR XML PATH('') )...
  3. robert693

    I would like to separate string delimited by semicolon into separate records

    If I have the following code, how can I use it to separate values in a field in my database? declare @xml xml, @delimited nvarchar(max), @delimiter nvarchar(10) set @delimited = N'a,b,c,d,e' set @delimiter = N',' set @xml = N'<root><r>' + replace((SELECT @delimited FOR XML PATH('') )...
  4. robert693

    I would like to separate string delimited by semicolon into separate records

    I have a query with a field that has an output of a string delimited by a semicolon. For example: Jimmy;Joe;Mary;John. I would like to separate each name into separate records: Jimmy Joe Mary John. The string can be of any length. So there can be one name in one record, and there could be 10...
  5. robert693

    Use Split() function to separate multiple values in a string separated by a semicolon

    Thank you! It split the string. Your help is very appreciated!
  6. robert693

    Use Split() function to separate multiple values in a string separated by a semicolon

    HI, I want to create a formula that will split a field with different values separated by a semicolon, such as "Jimmy;Bobby;Joe;Patty" and have it read out as: Jimmy Bobby Joe Patty The field can have one or many values separated by a semicolon. So, there may be one name, or ten. I tried to...
  7. robert693

    Select only the lastest record

    Hello, I have a report with an ID field (Command.ID) and a date field (Command.CommentDate) as well as several other fields. The ID field can be null. Each ID can have multiple Date fields. I want to pull only records with the latest date field. So for: ID Date 201 01/01/2015 201...
  8. robert693

    Print to form

    This is the code that I have used to print a matrix to a form. It is really straight forward, I just need to know how to change the appearance of the matrix that then prints. Private Sub Form_Paint() Dim i, j, s As Integer Cls For i = 1 To 8 For j = 1 To 12 s = Matrix1(i, j)...
  9. robert693

    Print to form

    This is the code that I have used to print a matrix to a form. It is really straight forward, I just need to know how to change the appearance of the matrix that then prints. Robert
  10. robert693

    Print to form

    I would like to print a matrix to a form but when I do the rows are spaced alright but the columns are spread out about an inch apart from each other. The matrix will not fit on the form well enough to be read. I have tried various things to correct this but none worked. Any help would be...
  11. robert693

    Operations on a matrix

    I have a 20 x 30 matrix in a two dimensional array. I have to do mathmatical operations on it where each element of the matrix is multiplied by the corresponding element in the next row. For example if it were a 3 x 4 matrix 2 3 5 1 7 5 8 2...
  12. robert693

    Matrix Multi-dimensional arrays

    I have a project whre I have to use a 20 x 30 matrix of numbers and do mathmatical operations on the elements. The matrix is in a file at a website. I would like some tips on how I could load this matrix into my program, without having to manually enter each element, and also some tips on how to...
  13. robert693

    Arrays

    I am creating a C project that simulates CPU Scheduler algorithms. The algorithims that are simulated are Round Robin, Shortest job first, Priority, and first come first serve. I have a simulation of 55 jobs that come in. I have randomly created numbers for the burst, quantum time, and priority...
  14. robert693

    Can combo box values be applied from another field?

    I have a form that is based on a query. The query is based on a two tables, Contact and Survey. There is one more table called Institution. Institution has a primary key, who's value is a number and another field called Name. The primary key of Institution is a foriegn key in Survey table and is...
  15. robert693

    Form and query don't work together

    I have a form based on a query. The query is based on three tables. One is a table that hold info on hospitals and universities. Another is one that holds info on contacts at those institutions. The third joins the two and holds additional info from a survey that the contact sends in. I have a...
  16. robert693

    Form based on a query not working

    I have a form based on a query. The query is based on three tables. One table is called Institution, it holds information about universities, hospitals and other institutions. Another is called Contact, which holds information about contacts from the institutions. A third table joins the two and...
  17. robert693

    Help with a variable

    I already posted this query in Access Other Topics but it seems more apropriate here. I converted a database from 97 to 2000 and I haven't been able to get a variable from the 97 database to work in 2000. It is: Dim Tb1 as Table. I have tried Dim Tb1 as DAO.Table and Dim Tb1 as ADOX.Table but...
  18. robert693

    Help with a variable

    I converted a database from 97 to 2000 and I haven't been able to get a variable from the 97 database to work in 2000. It is: Dim Tb1 as Table. I have tried Dim Tb1 as DAO.Table and Dim Tb1 as ADOX.Table but nothing I have tried works. The module concatenates names and addresses from a table and...
  19. robert693

    Converting a database from 97 to 2000

    [b]I converted a database from Access 97 to 2000. I need help with rewriting the code for 2000. For example a variable I declared in 97 as Dim Tb1 as Table does not work in 2000? I guess I have to learn more about the ADO/DAO conversion! Any help in this are would be greatly appreciated![b]
  20. robert693

    Check Box Help

    I have a check box called FullTime in a form that one checks if an employee is full time. If an employee is not full time then a label and a text box appear with further information. They only are supposed to appear when the check box is not checked. I used this in the form current event...

Part and Inventory Search

Back
Top