Recent content by charliemopps

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