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!

  • Congratulations SkipVought 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: *

  1. solas989

    Horizontal not Vertical Report Variables

    That worked like a charm. Thanks so very much - a star for you!!! Guess i will add that to my idiot list :) solas989
  2. solas989

    Horizontal not Vertical Report Variables

    I did not even know that existed (and I did not even think of that to look there)! I think that might work - trying it now THANKS!!!!
  3. solas989

    Horizontal not Vertical Report Variables

    I have run my head into a brick wall and all that falls out is an "I.O.U." message. I need an odd type of report i guess. Background: This is a sample report (up to 30 different samples for the same object - not all will be used) that compares two different company samples of the exact same...
  4. solas989

    Printing

    I had a similiar problem with Access97 on a network of 500+ PC's. But my situation the way it looked on the screen was fine only some of the time, the other times it would look wierd as well. What we had to do was delete all drivers (printers) on the computer. Reboot the PC with out the...
  5. solas989

    SQL query

    If you are running this in VBA (which likely you are if it is mousemove) then you need to set apart the text field like a variable (at least this is what I do): select top 1 * from (Select top " & Me.[Text156] & " * from mytable order by myfield desc) as T1 order by myfield asc HTH
  6. solas989

    2nd Duplicate Field Truncating (Reports6i)

    On Reports6i, I have a formula column that concatenates addresses (such as Street, State, Zip etc) called CF_CONCAT_ADDRESS. This field is then reported in two different frames on the same page in the report (this is an invoice report). The first instance works wonderfully (at font size 10)...
  7. solas989

    error converting to MDE file

    I got the same message at one time. What my problem was there was a compilation error. You need to compile the database and see if there is an error - then fix it of course :) A MDE conversion compiles the database souce code (VBA) and makes a MDE (or "executable" [this is a...
  8. solas989

    Find Current Network Username

    I guess that is one of the benifits of working with WinNT and WinXP Pro that the environment variables exist since it is meant to operate on a network. Now I know that does not exist for Win9x series of OS's. Sorry it didnt help or work :( Hopefully you can get it to work smoothly under WinME
  9. solas989

    Find Current Network Username

    I do not know if this is the best way to do this but I use very simple code. I use the network name and machine name to log access to various areas in my front end so I can see where they have been if something gets a discrepancy. Here is my code: Dim UserName As String ... ... UserName =...

Part and Inventory Search

Back
Top