Search results

Need suggestions on which SQL class to take. My works willing to pay, one of these classes is $3k which is kind of putting them off but they are still willing to go it if I really want it. What I do: LOTS of reporting. I hit all kinds of databases with all sorts of queries. We've got Oracle...

See... this is why I come here... lol Thanks

That sort of works but I have multiple duplicate dates. Thats why I had the CDate(Int([Dateof])) How can I just show unique dates with your meathod? I tried substituting my formula but it didnt work

I have a list of stuff that I have to querry on a Linux based server. Each file is named by date, and the stuff I want could be on the date listed in my report or on either the prior or 2 days after due to GMT and other wishy washy stuff. So what I want is to have a list of dates + 1day prior...

I finally got it. There were only about 8 different formats they could come in so I finally just got 8 if/then statements together and made it work.

I have a bunch of memo fields and none have the same info in them. But in all theres a point in which the the memo states something like: Incident date: 05/14/2010 9:32AM GMT or Last seen: 2010-05-14 17:45 Z etc. So the date format could be any format really. And where it is in the text is...

That gives the the number of characters from the start. I want the line number.

I think I got it. with the STR and mid functions But I have a new question, is there a way to search for a LINE of text? Like: Red 2 blue 3 green 5 orange 6 Search for blue and then return the entire line that has blue in it as a text variable?

But, if you notice, these values are tab sepperated. wouldn't it be easier to parse it out that way?

I need specific parts of this memo field and another memo field. In this one I need the phone number. In another field I need an IP address. I know how to do this in a scripting language I use, but I'm a VB noob. So I think if you get me started I can prolly figure out the rest.

I need some help parsing a paragraph. If someone could give me some quick example code I'd appreciate it. This is an example of what will be on a memo field called "Txt_26" on my form. And I just want each data set in a sepperate part of an array so I can pick out the IP, phone, etc...

I looked arround and found stuff that gives offsets or GMT... What I really need is something that will spit out CST... like CST() I can not believe Access doesn't have this already built in. lol

Ok, I'm having a locked record problem. It occures to me, the simplist solution to my problem would be to excluded locked records from my dataset. Is there a way to exclude locked records in a query? Me.Locked = No or something?

I have an Access database that's split into front and backends. Every once in a while the back end gets messed up and only a compact and repair will fix it. When this happens, I notice that the lock file is still in the folder. I think what is happening is someone is shutting down their...

ok, now I'm REALLY confused. I removed the DoCmd.Close thinking maybe it was closing the wrong form. now the code opens the Main form twice. It's not opening the Frm_Fake at all. ALSO: My if statements arent working right for some reason. I have the Debug printing the recordcount is 1, and the...

I tried this, it doesn't seem to work. This is exactly what I'm using: Private Sub Form_Load() Me.Requery Debug.Print Me.Recordset.RecordCount If Me.Recordset.RecordCount < 1 Then DoCmd.OpenForm "Frm_Fake" DoCmd.Close End If End Sub The debug code does print 0 as the record count. But...

I dunno how to count records in a Query with VB. Could you point me to some example code I can modify?

So I have a forum based on a Query. The Query is read only, nothing I can do about that, it is very complex and the order in which the records are displayed is important, so there's nothing I can do. When the Query reaches 0 records the form blanks out... loses all it's controls. Even subforms...

I figured it out I think... If Me.random_field <> 0 Then do the button stuff end if

So I have buttons that "Go to the next record" and that "Complete the record" (put a time stamp in the record that it's been worked) The problem is that the form is based on a querry, and once all records have timestamps there are no records for the querry. So when you click the "Go to next...