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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by AC5FF

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

Part and Inventory Search

Back
Top