Search results for query: *

I have an access database, and one of the fields I need to filter and show only those records with 3 or less characters. Ie; most of the data would be 555-555-5555, but some are 555.. and those are what I need to see. how can you do this in access?

I am trying to find about using a TreeView within my Access 2k3 app to display hierarchy. Can someone point me to some examples or info on this?

Hello I am not sure if this is the right area for this question, and if it isn't please let me know and I'll move it. I was handed an Access application this morning, and it has a results screen that is just a grid view. I was informed they'd like to have this actually display the hierarchy...

Hello, I have default.aspx which holds a series of buttons, and IFrame tags. Once a button is selected it sets the needed IFrame to visible, and the rest to false. Which is working great, and leads me to my current question. is there a way to set the select button to show that is selected some...

Hello, I am using the below string to pull the date out of our database which is in unix format, and convert it to something the user can read. I used the following which works fine. DATEADD(dd, Create_Time / 86400, '1/1/1970') I found out yesterday that all of the records are 8 hours...

Hello, I have been working on several web based reports for a little while now, and just about ready to turn them in when I noticed all of the records display 8hrs ahead. After talking with Tech Support I was informed I can't connect to SQl Server. I must use the ODBC and connect through there...

Hello, Below I have a very simple page I am pulling 4 fields which list in DataGrid. What I need to do is turn the Status into a list Box so that can select what the status should be. is this possible? any examples I could be pointed to? most of what I found is just adding an edit, or delete...

Hello, I have this query, and in short I need to take all of the oaks, and combine them into 1 count. If take out the join, and just use inv_machine it works. If I leave it as is, and just search for one of the oaks it works, but when I try more than one it sits there a while and times out...

Hello, I am in need of pulling a couple of fields from a table on insert and put them into another table so that I can do searches and inserts without touching the main table. I created the trigger below for this purpose, but for some reason it stops the insert all together. If I set this to...

Hello, I have series of pages I have written (Reports) that use a couple of list boxes to narrow the searches. I'd like to set it up so I basically have a menu of the reports on the left and when select the top populates with the list boxes and the report in the main portion. Is frames the...

I have the following sql statement wich works fine, but it returns the date as 12/20/2004 00:00:00 I need to strip the time off, but haven't been able to make this happen. SELECT DATEADD(dd, Create_Time / 86400, '1/1/1970') AS 'Date Open', COUNT(*) AS tcktOpen FROM HPD_HelpDesk WHERE AND...

I have an asp .net page I have created that does a bunch of sql, and generates a graph. I have a couple of select boxes. That I would like to have displayed and stay put. the graph i'd like to have pop up as is it was in a frame. I remembered there use to be like iframe or something to that effect.

I managed to get this working in query analyzer, but having problems using it in my page. How would I format this properly? SELECT DATEADD(dd, Create_Time / 86400, '1/1/1970') AS 'Date Open', COUNT(*) AS tcktOpen FROM HPD_HelpDesk WHERE (Assigned_To_Group_ = 'Customer Service...

I was wondering if anyone might know how I can take this code, and turn the datagrid into a graph? I haven't been doing this very long, and fighting it the whole way. Managed to learn some cool things along the way though. also the breakdown of what I wish to acomplish is if * just a bar that...

The date in the database is in Unix time format, and I need to group by that field for the whole day. and display the result in a readable date format. I am not sure how to do this. select create_time as 'Date Open',count(*) as 'tcktOpen' from HPD_HelpDesk where Assigned_To_Group_ = 'System...

I am doing some time conversions, and need to search my database based on these. As a test I put them at the start of the page. I can do response.write(unxStart.tostring) just before my sql statement which is in my getTicket Sub, and it gives me what I need. But if I put @unxStart into the sql...

This is the last issue on my plate and it is driving me insane so any help what so ever would be highly appreciated. I have a page I wrote that needs to allow for a list box that allows the user to select Daily, Weekly, Monthly. The Time / Date Field in the DB is UTC, and I need to check...

I have an if statement to check if something is null, and if so I want to set the value for example to * This just a test I was working with. How do I set the MySelect.Value to *? If MySelect.Value ="" Then Response.Write("No Value Present <BR>") MySelect.Value=("*") response.write...

Just trying to do something simple. Basically I want to check and is if my select box value is null, and set it too * If MySelect.Value Is Null then MySelect.Value = * how do you do this in .Net I know Null is no longer valid?

The SQL Server DB I am going against holds Unix Time, and I need to be able to search against this field to get all records for that day, weekly, monthly this get's me the current date time, and shows the Unix value, but I strip the time off so I can just use the date to search by. Dim...