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 Chriss Miller 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. softbrix2

    Sql Max returning lowest -Negative as Max

    you are correct. my numbers are picking up as negative because of the -, but shouldn't MAX return the higher positive interger and not the lowest?
  2. softbrix2

    Sql Max returning lowest -Negative as Max

    thanks this should work but i manually search & replaced about 22k records, I'll try your statement tommorrow.. Tired :)
  3. softbrix2

    Sql Max returning lowest -Negative as Max

    I have a table that use to use 4 digits as part of the invoice. I've since did 9999 invoices and tried to change it to 99999. my invoice number is in format XXX-MM-9999 when change the max value in the database to 09999 to the select statement would get the max invnum then add 1 to it. Instead...
  4. softbrix2

    How to detect current logged in user from msaccess security

    I have a database with tons of customers, I want each sales person to only see the customers they entered and not everyone else customers. I'm using msaccess built-in security. How can i detect the current logged in user and filter the data base on that user. I can't use the enviro(username)...
  5. softbrix2

    Best Way to handle stock.

    ok i've looked at the office 2000 inventory control but I don't see how if calc total sold compages to total ordered/on hand.
  6. softbrix2

    Best Way to handle stock.

    I need to handle the stock on hand for each purchase made. 1 purchase can have muitlple products with each product have diferent qty. Currently I have a stock table that keep the stock on hand, in my order form after update of each qty field I do a subtraction from the stock table via mysql...
  7. softbrix2

    Help with Subtracting using form data

    thanks it work perfectly. I'll post another question in another tread
  8. softbrix2

    Help with Subtracting using form data

    DoCmd.RunSQL ("UPDATE products SET products.Stock =(products.Stock -1 WHERE products.ProductID=17") that works fine. Code below Don't Work. -----------------don't work----------------------- DoCmd.RunSQL ("UPDATE products SET products.Stock = (products.Stock - [Forms]![Orders]![Order Details...
  9. softbrix2

    Flash Impact Effect

    I'm trying to create a flash impact intro. I want to look similar to the ford commercial where they brand the ford logo in the steel body (built ford tough". I want when my visitor comes to the site my logo will stamp onto the face of the monitor, and create some vibration effect. this might be...
  10. softbrix2

    How do I completly Flatten a EPS file in illustrator CS2

    so is it fair to charge one price for a flatten jpeg/tiff/pdf and charge a higher price for the mastes editable file?. I'm asking because we are a small design company and would like to know the law/common rule used for stuff like this.
  11. softbrix2

    How do I completly Flatten a EPS file in illustrator CS2

    so your telling me that the client should have my master file withing paying for a master? I'm giving them 2 options. option 1, pay for the finished logo/label design flattened or option 2. pay for the master editable files. they choose option 2.
  12. softbrix2

    How do I completly Flatten a EPS file in illustrator CS2

    so there's no way to give them a non-editable eps? I thought most logos and such came in EPS format that you can't edit?. if possibe I would love to give them a eps file and a pdf
  13. softbrix2

    How do I completly Flatten a EPS file in illustrator CS2

    I want to give my client a flatten eps file that they can't edit. I tried flatten transparency but I was still able to edit the EPS once re-opened. How can I save a Eps or Vector File that's not editable at all, My files is currently in layers.
  14. softbrix2

    LOCKED FORM after repairing Database ( BE)

    FiXed it. The program I used to recover the database tables didn't recover the autonumber or the promary keys structure. I found an old copy of the BE and Import the new data
  15. softbrix2

    LOCKED FORM after repairing Database ( BE)

    no backup ava, the database seems fine but the FE somewhere go screwed. I can edit the subform but not the main form, so it could be the table
  16. softbrix2

    LOCKED FORM after repairing Database ( BE)

    Hello, my access database crashed, I recovered but now one of my forms are locked. I cannot add or change any thing on that form, I have a FE and A BE if I open the BE manually I can make changes to the data. but if I try to change it from the FE it doesn't work. I get error "you cannot go to...
  17. softbrix2

    No data report

    Hello, I'm using a modified invoice report from the sample invoice.mdb that comes with access 2002, If my order dosen't have any Product (only labor,) then my report cancel. how can I get it to print regardless os products or not. Please look at my joins cause I think thats where the problems...

Part and Inventory Search

Back
Top