Searching for keywords on Jobs / CVs (Resumes) can never lead to anything but grief. Ask any job applicant or recruiter who has been stung by keyword search systems. If you are, say, looking for a job application that needs SQL and C#, how would you reject some sentence like "I have never used SQL and I hate C#" or distinguish the relative merits of an applicant who says "I have 20 years experience in C#" from one who says "I have not used C# but I would like to learn it".

There's a secret error somewhere in your secret code. You should fix that. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

I usually use a view to service this type of requirement. Craft the view to supply only the required data eg date, starttime in 15 minute groupings and the number of people falling into the slots who are clocked on. End time only represents a person not clocked on and is irrelevant to the graph. Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP

Michael Clinton wrote: Can the system handle multiple users filling out web form and populate pdf template and save the populate pdf into a different directory. Almost certainly, although it's hard to tell without seeing your code. I do something very similar using PDFSharp without any problems. So long as you're using FileShare.Read when you open the file, other threads and processes should be able to read it at the same time. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

The WebBrowser control is stuck in IE7 mode unless you change the registry on every PC your application runs on: Web Browser Control & Specifying the IE Version - Rick Strahl's Web Log[^] You could try using something like CefSharp[^] instead, which uses the same framework as Google Chrome. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Absolutely No, @Michael this is not possible as you need to code to save the PDF document in db. This can be done on submit button click.

lol... no, that's not a common problem as far as I know. Can you post the relevant code here? P.S. This question should be in the Visual Basic forum. :) Pete Soheil DigiOz Multimedia http://www.digioz.com

Ok, I got it to work. What I did was saved query result into a dataset and then using string functions to get my data out and then create a datatable and added each row with data from the dataset. Dim accessConnection As OleDbConnection = New OleDbConnection("Provider=MSIDXS") Dim accessCommand As New OleDbCommand(query, accessConnection) Dim newjobsDataAdapter As New OleDbDataAdapter(accessCommand) Dim myDataSet As New DataSet() Dim newjobsDataTable As New DataTable("newjobs") newjobsDataAdapter.Fill(myDataSet, "newjobs") Dim dataTableRowCount As Integer = newjobsDataTable.Rows.Count Dim myDataTable As DataTable = myDataSet.Tables(0) Dim tempdata As String Dim spc1 As Integer Dim spc2 As Integer Dim spc3 As Integer Dim spc4 As Integer myDataTable.Columns.Add(New DataColumn("ID", GetType(Integer))) myDataTable.Columns.Add(New DataColumn("JobID", GetType(Integer))) myDataTable.Columns.Add(New DataColumn("JobTitle", GetType(String))) myDataTable.Columns.Add(New DataColumn("Keywords", GetType(String))) myDataTable.Columns.Add(New DataColumn("Location", GetType(String))) myDataTable.Columns.Add(New DataColumn("Rate", GetType(String))) For i = 0 To myDataTable.Rows.Count - 1 myDataTable.Rows(i)("ID") = i + 1 tempdata = myDataTable.Rows(i)("characterization") spc1 = InStr(myDataTable.Rows(i)("characterization"), ",") spc2 = InStr(myDataTable.Rows(i)("characterization"), ". Category") myDataTable.Rows(i)("JobID") = Convert.ToInt32(Mid(tempdata, 1, spc1 - 1)) myDataTable.Rows(i)("JobTitle") = LTrim(Mid(tempdata, spc1 + 2, spc2 - 8)) spc1 = InStr(myDataTable.Rows(i)("characterization"), "Description") spc2 = InStr(spc1, myDataTable.Rows(i)("characterization"), "~.") myDataTable.Rows(i)("Keywords") = LTrim(Mid(tempdata, spc1 + 13, spc2 - spc1 - 12)) spc1 = InStr(myDataTable.Rows(i)("characterization"), "State") spc2 = InStr(spc1, myDataTable.Rows(i)("characterization"), ".") spc3 = InStr(myDataTable.Rows(i)("characterization"), "City") spc4 = InStr(spc3, myDataTable.Rows(i)("characterization"), ".") myDataTable.Rows(i)("Location")