Recent content by chuckh70

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?

Thanks for all of the help. Was out of town for a few day's but back working on this crazy thing. It atleast makes since now. I will post back with my results.

I found this nice example, but all I did was confuse myself more. Still not sure on how to grab the data and bind it. Option Compare Database Private Sub cmdCollapseNodes_Click() 'Collapse all node For Each Node In MyTreeView.Nodes Node.Expanded = False Next End...

Thanks for all the info. Normally i'd spend the next few days tearing through this, but unfortunately I am on a very tight schedule. I went through and set up a test and I got it basically working when I had code data to it. How do I get the data from the database to popluate this...

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

Perfect. That was just what I was looking for thanks

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

Got it thanks a bunch.

Perfect thanks all.

ok this works thank you, but I noticed another slight problem. my dateadd strips it down to just the date so the new date add just takes it from midnight and makes it 4 p.m.

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

tells me it requires 3 arguments? Thanks for the help by the way.

So I could just wrap it around my current date add? Something like DATEADD(hh,DATEADD(dd, Create_Time / 86400, '1/1/1970')-8)

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