Search results for query: *

Thanks for the replies guys. I'm using a CR 8.5 Environment so I believe I can use SQL expressions. Not sure about that though. I'm just pulling this info out of one table, however because I'm actually querying a view which already has the names that I need included in it. So is there a way...

As strange as this sounds, I need to count some records that I know don't exist and return 0 I have a list of people who are doing projects, some of them have done several and some have done none. I want to create a query to list those users but I need to return a row for all of the guys who...

It's something that will change positions. I after you posted this I found a solution though. Here is the code that saved my day: Dim MyScreen as object Dim MyArea as object Set MyScreen = Sess0.screen CurrentRow = MyScreen.Row CurrentCol =...

I'm trying to use the following code to automate the process of checking for successors to mainframe jobs which have failed. Here is my code: Dim MyScreen as object Set MyScreen = Sess0.screen CurrentRow = MyScreen.Row CurrentCol = MyScreen.Col...

How can you do that and have it display a different record in each control? Will that really work?

I have a report that has to print 3 records to a page in order to support a pre-printed form. In order to print the last record on the page, I need to be able to print in the margin. Does anyone have any idea as to how to force Access to print in the margin so that my pre-printed forms will...

I've got a macro that pretty much runs all day long. All it really does is press <Enter> for me every 5 seconds to refresh my screen and then checks some other screens every now and then. The problem is that sometimes I need to stop this macro so that I can perform some functions. Is there a...

Always refuse to sign ANY non-compete. If they won't hire you if you don't sign it, then you don't want to work there. My wife and I both have refused to sign them and have still gotten the job twice in the past. If the company wants you bad enough, they will quitly throw the unsigned paper...

Okay, here is some sample data. I'm using CE 8.5. I'm connecting via ODBC connection. Here is the data that I'm working with. tbl_Tickets: Ticket# OpenDate OpenedBy 38384 01/01/2004 Bob 38383 01/02/2004 George 38382 01/03/2004 Bob tbl_WorkOrders OpenDate...

I have two subreports on one report. I would like to know if there is a way to keep the groups on those subreports together. Like if a group appears in the first subreport, I would like it to keep the same group from the second subreport with it. Is this possible? I'm open to suggestions if...

Resolution doesn't affect this problem. Notify keeps changing the notify list position registry key HKEY_USERS to a very small negative number like -32000 0000 -32860 0860. It's obvious why it is off the screen but when Notify opens up, it always changes it back. Any ideas? Chris

I'm attempting to create a variable that will allow me to perform some calculations on it later, but I want to zero out this variable at the beginning of each group. Where do I need to place my formula to zero out the variable? I tried this in the suppress section of the group...

I'm working on a project which requires me to be able to write complex queries. I want to use the query designer to do this but I don't want any of the other tools such as Enterprise manager or anything like that. Is there a way to install JUST the Query Designer on my PC? It it just like one...

I have started using NMAS authentication and have noticed that on any clients that have the 4.9 client with NMAS enabled, that when they are prompted to reset their password every month their Novell and NT passwords don't synch up correctly. I can resolve the problem by unchecking the NMAS...

Okay, both of you guys were correct all along. And I'm officially the biggest idiot in the world. I was pointing to the wrong source files and as a result was concantenating together a bunch of ZIP files!!!! Thanks, Chris

Well, I agree with you on the encoding of the file, but I'm still having the same exact problem with the exact same output. I don't know what could possibly be my issue now.

I still get garbage.. Slightly different garbage, but still garbage. It now comes out looking like this: PK =¥»¡–ï;ä`á—»ÒÝléζ ªûˆ§<ÿùÜ*ÞcHrÎí™î‹>챕ê§þ –ßsðž~JÌ PK
  K™p0l¾2 ¯ 
¶ pmsp5440.clmUT ~¥W@Ux PK

G O PK...

Okay, I have some some text files that I'm trying to edit and then string together. I've altered my code a little and was trying to get some additional Ideas. Here is what my code looks like now: Option Explicit Const ForReading = 1, ForWriting = 2, ForAppending = 8 Dim FileObject Dim...

I'm still getting the same garbage. I'm not sure what this could be now.. :(

Sure, the data SHOULD look like this: NM1*87*2*KILDARE ASSOC*****24*581234567~ N3*2345 OCEAN BLVD~ N4*MIAMI*FL*33111~ What I'm getting looks like this: t¢–Ó<¤‘å*ˆc «õúa&Yú¯©Vú!ÚᦫçKš^Á‡ÓâË^nÚ-ÈÆ6Û27õx2Ái...