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

    Excel lookup formula

    Hi Guys, I'm looking for one of two solutions. I have a spreadsheet that has peoples names in column A, but this one cell contains the whole name (Mr Bob Jones). I need to remove the "MR" part of the name, so I can conduct a vlookup on just the name and surname. I've tried doing a text to...
  2. voltarei

    Word 2003 - Drop Down Lists & Text Entry Combined

    Hi All, I'm trying to create a form that has drop down lists and blank table cells for text entry, but when I activate the drop down lists by protecting the document, the ability to enter text is taken away. Any ideas on how to do both in the same form? Many thanks Phil
  3. voltarei

    Conditional Expression on a form

    Hi All, I have a form that is used to take card payments, and I would like it to calculate the charge amount based on the type of card used. The fields on the form are: Card type - combo box Net amount Charge Total amount I thought I could use an IF expression to say that "If the card type is...
  4. voltarei

    Using a count function on a report

    Hi everyone, I have very basic knowledge of Access, so please bear with me. I have a database which is used as a small questionnaire. The only information collected (in one table) is Employee Name, Employee Number and then the answers to Question 1 to Question 30. Each Question field is linked...
  5. voltarei

    Sending Reports by e-mail with images

    Hi all, Whenever I send a report by e-mail, any images or lines/boxes that have been added do not appear. The only items that appear are the bound and unbound fields of the report, and text boxes. Is there something I can change in the properties to make sure that images remain on an e-mailed...
  6. voltarei

    Can anyone explain this error code please?

    Can anyone translate the following into plain English for me? I sort of get the gist, but I need it clarifying. It appears when I try to enter an ID number into a form field. "The current field must match the join key "?" in the table that serves as the 'one' side of one-to-many relationship...
  7. voltarei

    Getting form fields to populate table fields

    Hi all, Having trawled through the forums to no avail, I wonder if anyone can tell me how I can get the fields on a form, to populate a table. I have a very basic database that tracks customers and their orders. I have a customer details, product details, travel costs, and employee details...
  8. voltarei

    Parameter Query Text Box

    Hi All, Is there a way that I can change the text box on my parameter query to a combo box, so rather than type in a parameter, the user can select one from the drop down list? Many thanks Phil
  9. voltarei

    Multiple uses of a query field on a form

    Hi all, I'm trying to design a form that allows users to enter a part number, and have the description and price populate automatically. I have designed a query from 3 linked tables (Customer, Staff, Products) which works wonderfully if there is only product to be entered. If I try to use the...
  10. voltarei

    Hyperlink error

    Hi all, Can anyone tell me how to resolve this error: Unable to open "www....." Cannot locate the internet server or proxy server. The error message apperas when I try to click a hyperlink I have created on a form. Any ideas? Phil
  11. voltarei

    Switchboard on open event

    How can I get my switchboard to appear maximised upon opening. Currently it opens in standard view. This is the on open code: Private Sub Form_Open(Cancel As Integer) ' Minimize the database window and initialize the form. ' Move to the switchboard page that is marked as the default...
  12. voltarei

    Can I query the reults of a query?

    Hi all, I have designed a form to display the reults of a parameter query where the user inputs part of a word to find an item from a stock list. Because the stock list is so extensive, there can be too many results to scroll through quickly. Can I somehow run a second query on the results from...
  13. voltarei

    Bookable Diary On Access ??

    Hi All, Does anyone know if Access has the ability to include a diary which allows you to book meetings etc, with the ability to review the diary and amend if necessary. If so, any help on how to build one into my database would be appreciated. Phil
  14. voltarei

    Only display result if criteria is "yes"

    Hi everyone, Is it possible to format the text boxes on a report (populated by a query) to only be visible if the word in the text box is "yes"? Many thanks Phil
  15. voltarei

    Switchboard

    Last one tonight I promise. Is there any way of having more than 8 items per switchboard? Phil
  16. voltarei

    Update a Form

    Me again, I have a form that contains order data, taken from a parameter query so I can view a particular order and update it's status if necessary. I have found that if I set the forms properties to "Data Entry - Yes" so I can make changes on the form, it does not appear when opened. If I set...
  17. voltarei

    Auto-number Parameter Query

    I'm trying to run a parameter query, using the Order ID field as the data to search for. The Order ID field is an auto-number field, and when the query runs, it returns no records. Is there a way around this? Many thanks :->
  18. voltarei

    Access Command Buttons

    Hi, As a new Access user (I know I started late !!), I would like to know if it is possible to have one command button on a form that will open up a seperate form and close the existing one when clicked so that the user doesn't end up with a load of open forms on screen. Many thanks

Part and Inventory Search

Back
Top