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 Mike Lewis 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: AC5FF
  • Order by date
  1. AC5FF

    Importing Data via a Macro

    I've got a DB I manage - built long before my time. One of its daily function is to import supply reports that are in TXT format. Unfortunatly, the format of the TXT files have changed on me and I now have to get this import to work again. What has me stumped is the 'Specification Name'...
  2. AC5FF

    Conditional Text within a report?

    PH Thanks! Your help fixed this right up.. :D Makes me wonder though why the DATE(),"ddd"="Thu" didn't work... Wierd...
  3. AC5FF

    Conditional Text within a report?

    I'm having problems getting this to work and I do not understand why. As far as I can tell everythign is written correctly - it just doesn't seem to want to work! In the report I am working on I list a set of work center test stations. The report itself works great and does exactly what I...
  4. AC5FF

    Query returns wrong data?

    Okay - So I went to the original query and tried to do the same thing. When I do I get an error saying 'You tried to exicute a query where "Element" is not part of an aggregate function' ???
  5. AC5FF

    Query returns wrong data?

    What the?!?!??!?!?!??! Okay - removed the GroupBy on the second query. (Didn't think I could do that with the 'Totals' enabled... At any rate, when I do that I get 474 records!!! When I look at the query results - most lines are listed 3 times! Some twice. wierd..... I'm totally out of...
  6. AC5FF

    Query returns wrong data?

    I am not sure what is happening here. I am trying to query a table (DyessD23) to count up how many documents are in a certain status (cur). For the most part the query works - but returns numbers that are WAY off. If I go through the table and count myself I come up with numbers nearly 1/2 of...
  7. AC5FF

    Locked DB?

    The DB is not SUPPOSE to be secured. At least no password requred to open it. As far as the MDW file ... how can I find out if I am using the correct one? I had the owning shop search the directory to where the MDB file is stored and they found a "secured.mdw.mdw" file. They sent that to...
  8. AC5FF

    Locked DB?

    No one, not even me can open it right now - regardless of the location. I have put the DB on my desktop to work on it so I definatly have access to the folder.
  9. AC5FF

    Locked DB?

    I have a DB problem that I'm hoping someone can help me with. For some reason - out of the blue - our DB has appeared to lock everyone out! When anyone tries to open the DB (mdb file) you will get the error "You do not have the necessary permissions to use C:\..... .mdb object. Have your...
  10. AC5FF

    How to adjust output window size?

    IT WORKS!!! Thank You
  11. AC5FF

    How to adjust output window size?

    Will give this a shot when I get back to work on Monday... Thank You
  12. AC5FF

    How to adjust output window size?

    Sorry... PremerePro2.0 I cannot find where to set the output settings (new user using a work computer w/this program). Every output settings that I have found either does not have the frame size or if it does it is dimmed out and I cannot change it.
  13. AC5FF

    How to adjust output window size?

    I'm sorry... I should have started that post with "HAPPY THANKSGIVING ALL!" :D
  14. AC5FF

    How to adjust output window size?

    I created some animated text the other day to use as a Avitar in the forums. However, the output animated GIF file is a 640x480 size and about 15.5mg. I cannot find a way to reduce the output size on the GIF file to a smaller size. Is that possible to do with Premere? Would another program...
  15. AC5FF

    Selective Criteria in a Query

    Update: Worked this a while this morning and was able to get everything to work as required!! THANKS TONS EVERYONE!! Quick question though: Golom posted something about area.name being a 0 or -1. Not sure where that came from. One of the things that tripped me up was the ANQ161 field is a...
  16. AC5FF

    Selective Criteria in a Query

    Here is the code that works for selecting "DAV", "REW", or "ALL" INSERT INTO [Enterprise Report Card] ( LRU, NSN, Repaired ) SELECT lru.Abbr, lru.NSN, Sum(IIf(work!status=4 And work!code=11 And work![tin date] Between DateSerial(Year(forms![enterprise report...
  17. AC5FF

    Selective Criteria in a Query

    Now; thanks to all for getting that portion to work. :) However, I have to add one more step to the process. I didn't bring it up earlier because I think I needed to get over this one hurdle before tackling the next. I have a 4th selection on the combo41 box: 161Boxes In this selection I...
  18. AC5FF

    Selective Criteria in a Query

    Golam I am trying to be professional here but this post of yours is making it quite tough.. :) (Any 'inappropriate' thoughts were directed at myself here!! :) ) That's IT????? You've got to be kidding me! Just replace the true portion of the IIF statement w/Area.Name? Worked like a CHAMP...
  19. AC5FF

    Selective Criteria in a Query

    What I am trying to achieve: I am using the combo box (combo41) for the user to select the data contained in a report. The user can select shop "DAV", shop "REW", or "ALL" for both shops. I am using the IIF statement in the WHERE clause to choose what is displayed on the report. If I put just...
  20. AC5FF

    Selective Criteria in a Query

    Leslie If I am reading your post correctly, yes... that's what I would like to do. I'm not sure if this is a suggested fix though. Do I want to put that 'where' statement as the "true" value of the IIF statement?

Part and Inventory Search

Back
Top