Recent content by vince99

What I am looking to do is automate my daily products inventory. I have a daily excel file that conatins all my products. The products are listed by upc and quantity. I have another sheet that has the same products upc and a status of 1 if its available and 0 if its not. What I want to do is...

is it possible to have a macro go in and change the text in an excel file? I have a very large file and I need to replace some of the text with a number. For example, column 2 is a list of companies. What I need to do is change the list of companys from text to a code, depending on the...

Great .....

Does anyone know how to remove the header information form email massages when printing them? I have looked at all the options in Outlook and can not solve this. Any help is appreciated.... Thanks Vince

thanks

How can you set access to calculate fractions? when I enter .5 into a filed it returns 0... thanks for the help

no I am not, now what I am experiencing is that if I go anywhere near that record it crashes my computer... what is going on?

This is the text that is in the table,,, OF@〉

Also, when I try to delete the record, it tells me that the search key was not found.... Any Ideas?

I have no idea on what is happening, when I try to change or add or cut and paste the data I get this error message... the file is to large

I have completed my database...... This is what is happening...... I have entered data by utilizing the form that I have built. When I go and look at the table the form is built off of, I see all sorts of weird text. It lloks like alien language or something..... anyone know why this is...

When I select a report to print, the first page has all the data on it, but it also prints 3 blank pages... any idea why this would happen? Thanks

I have created a report and I have referenced it on a form when the user clicks the button, the report is generated... how can I have the report automaticly print? Thanks Guys

Is it possible to run a report on a form and return only data corresponding to the record I have open and not all the information in the form. The form is based on a table: What I want to do is be able to create a report based only on the open record (the record I am looking at) and nothing...

I have two queries that return an amount.... I want to setup a query so that It will subtract amount 1 form amount 2... Any Suggestions on what I should do? Thanks