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!

Search results for query: *

  • Users: AC5FF
  • Content: Threads
  • 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?

    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...
  3. 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...
  4. 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...
  5. 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...
  6. AC5FF

    Selective Criteria in a Query

    I'm just not sure why this is giving me so many problems. I would think it would be quite easy! I am running a query from a selection on a form. I want to be able to select data based on what shop works a product. Here is a copy of the SQL. The problem I have is in the WHERE section...
  7. AC5FF

    Multiple table query only returns partial data

    I'm stuck and I'm hoping to find a good answer here... I have a query set up that needs to pull data from three tables. Table "Quota" Table "Product" and Table "Work" Quota tabe contains product ID, Month (date field), and Contracted Product Table contains productID, costs, part#,etc Work...
  8. AC5FF

    How to query multiple tables.

    I'm stuck and I'm hoping to find a good answer here... I have a query set up that needs to pull data from three tables. Table "Quota" Table "Product" and Table "Work" Quota tabe contains product ID, Month (date field), and Contracted Product Table contains productID, costs, part#,etc Work...
  9. AC5FF

    Import/Transfer Table Data

    I've read through a lot of posts about transferring data, but none seem to be able to help me. I'm hoping I can find a little expertise here.. I have a table "MASS" that has 16 fields. This table used to be updated daily via a macro that pulled in data from 5 different TXT files. Those TXT...
  10. AC5FF

    Can I query data from external GUI (webbased)?

    When running a query and/or form from MS Access is there a way to take data from that query; i.e. a part number, and then using a web-based search page find information on that webpage and import it back into the form I am looking at in Access? I've tried using macros and haven't been...

Part and Inventory Search

Back
Top