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?

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.

...' If there is only 1 field then create this sql string IntCountFields = 0 Then If IntCountFields = 0 Then StrSQL = "SELECT TBL_OBS_L.* FROM TBL_OBS_L WHERE(((TBL_OBS_L.OBS_L1)='" & StrFullPath & "'));" Else ' if there are 2+ nodes then create this sql StrFullPath = Nd.FullPath...

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)

...Dim conn As SqlConnection = new SqlConnection(connString) Dim selectQuery As string = "Select assigned_to_group_, COUNT(*) AS tcktOpen FROM HPD_HelpDesk WHERE status >= 4 and DATEADD(dd, Create_Time / 86400, '1/1/1970') >= '" & nmStart & "' GROUP BY assigned_to_group_ Order By...

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

That was the problem Exactly.. Thanks

OMG don't I feel dumb. Yes that was exactly it Thank You very much.

...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. Select count(*) As Machine FROM machinehistory_scan INNER JOIN inv_machine ON machinehistory_scan.id = inv_machine.id AND inv_machine.location = 'Oaks IDF1 -...

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