Search results for query: *

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?

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

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

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

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.

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

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

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

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

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.

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.

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

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.

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

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

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

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