Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: camidon
  • Order by date
  1. camidon

    Using SQL to count non existant records!

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

    Using SQL to count non existant records!

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

    GetString returns garbage

    ...MyScreen.moveto 41,15 Sendkeys "zd succ job " Sess0.Screen.WaitHostQuiet(g_HostSettleTime) MyScreen.Paste Sess0.Screen.WaitHostQuiet(g_HostSettleTime) MyScreen.moveto 41,35 SendKeys " lev *{ENTER}"
  4. camidon

    GetString returns garbage

    ...JobName = Sess0.Screen.GetString(CurrentRow,CurrentCol,8) MyScreen.moveto 41,15 Sendkeys "zd succ job " + jobname + " lev *" When I run the macro, it assigns something strange to Jobname instead of the actual value. I ends up making jobname something like "zd succ job lev...
  5. camidon

    Force Access to print in the bottom Margin

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

    Force Access to print in the bottom Margin

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

    Stopping Macro from code

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

    HELP ME! I'M STUCK IN MY CAREER!

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

    Keeping Subreport Groups Together

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

    Keeping Subreport Groups Together

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

    Notify Opens off the screen

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

    Help with Functions (new user)

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

    Install just Query Designer

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

    NMAS and NT Synchronization problems

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

    More help opening TEXT files..

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

    More help opening TEXT files..

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

    More help opening TEXT files..

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

    More help opening TEXT files..

    ...adding carriage returns and combining files!" The data that I'm supposed to be getting back should look like this: ST TRANSACTION SET HEADER ST*837*0021~ BHT BEGINNING OF HIERARCHICAL TRANSACTION BHT*0019*00*0123*19981015*1023*RP~ REF TRANSMISSION TYPE IDENTIFICATION REF*87*004010X098~...
  19. camidon

    Opening a File Help

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

    Opening a File Help

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

Part and Inventory Search

Back
Top