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 TouchToneTommy 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: vince99
  • Content: Threads
  • Order by date
  1. vince99

    How would I do this ....

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

    Can you change text with a macro?

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

    Outlook 2000 Printing

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

    How can you set access to calculate .5

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

    Guys, I really need help with this one......

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

    When I print 3 blank pages come out, HELP?

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

    Print Button on a report

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

    Selecting Report Data Help Please?????

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

    Subtracting Query results.....

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

    Can you do this in a query?

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

    Can you run a query on a form

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

    Can you do this with access 2000?

    Is there a way of adding a drop don box to a query in order to select criteria? Thanks
  13. vince99

    How can you add a drop down box to a query

    Is there a way of adding a drop don box to a query in order to select criteria? Thanks
  14. vince99

    Can You Do This With Access

    I have created several queries and I would like to know if there is a way to put them in a drop down box so a user can select which query to run..... Also, is there a way to do this: Lets say you have a list of products ( a - z) I want to create a drop down box in which I can select a product...
  15. vince99

    help with forms please...

    Hello, I have created a form on which users can enter a variety of data. The Form consists of 5 different pages. I need help on printing the form. What I want to do is have a print button on each form that will print out the current form being displayed (Maybe I can select which data I want...
  16. vince99

    Help With Forms Please...

    Hello, I have created a form on which users can enter a variety of data. The Form consists of 5 different pages. I need help on printing the form. What I want to do is have a print button on each form that will print out the current form being displayed (Maybe I can select which data I want...
  17. vince99

    help with printing please

    Hello, I hope you guys can help me out with this one: I have created a from where users can enter data. Once the form is completed I would like the form to be printed. I used the built in tabs to build the form, and when I print, everything on the form shows up. What I was looking for is a...
  18. vince99

    Search Form

    Is there a way to edit the search form that the wizard creates for you? What I want to do is add items that can be searched in the drop down box. Any Ideas? Thanks
  19. vince99

    How do you select which query?

    How can you select which query you want to run by using a drop down box? Thanks In Advanced
  20. vince99

    vince99

    DropDown Combo Box For A query help? Is there a way to have a drop down box for a query? What I want to do is set up a select query and have the user decide from a drop down box what he wants to search for. When the query is started, I would Like the user to select a field, lets say email...

Part and Inventory Search

Back
Top