Search results for query: *

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

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('') )...

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('') )...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[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]

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