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...
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
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...
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
I have created a query that will return a total for a particular field that I have created....
I want to create another query (same as above) but I would like for the user to enter a date and only have the totals for that date returned....
This is how I built the query...
1) a query will...
I can create a report based on the query, but is there a way that when you run the query only the record that you are looking at is passed to the report?
is there a way to run a query on a form and let it return information regarding the record on the form that you are currently looking at an not all the data?
Thanks......
I have a better Idea...
is there a way to run a query based on the record currently being displayed?
If so, I can reun a query, select only the fields i want, and then print it.....
but I dont know how to run a query based on the open record and make it return only that record... and thoughts?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.