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 Rhinorhino 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: *

  1. voltarei

    Excel lookup formula

    Thanks everyone - xlhelp's formula works a treat. I'd never even thought about find and replace macropod, but will try this too as it may be something to remember for future. Thanks Phil
  2. 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...
  3. 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
  4. 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...
  5. voltarei

    Using a count function on a report

    Hi both LameID and TheAceMan1 and thanks for your suggestions. I did warn you that I was very basic at this, but I have tried both your ideas, and not had much luck with either. I think the problem that I am having, is that there are 30 fields in my table, all of which can be populated with an...
  6. 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...
  7. voltarei

    Sending Reports by e-mail with images

    Thanks both for your advice. I will definately look into Snapshot
  8. 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...
  9. voltarei

    Can anyone explain this error code please?

    I'm using Autonumber to generate the original QUOTE ID in the quote table. The quote table and the Invoice table are linked by Quote ID (Primary key to foreign key), and using them I have created a query that gives me the fields for the single form. (where the error occurs) In the instance...
  10. voltarei

    Can anyone explain this error code please?

    Hi AceMan, Since I made my post, I've been trawling the web to find a solution, but to no avail. I understand what you're saying (which seems to be the general consensus elsewhere), but I don't understand why the database thinks there is no record. The main table "Quotes" contains the...
  11. voltarei

    Can anyone explain this error code please?

    Thanks for that. I have tried deleting the links between the tables, but that just prevents the form from working altogether, as it cannot locate the records it needs. The set-up is as follows: A main quote table that has QUOTE ID as it's primary key. This is linked to another table that I use...
  12. 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...
  13. voltarei

    Getting form fields to populate table fields

    Many thanks for the advice. In addition to the "calculated" fields on the form not populating the table (due to them being unbound as you suggested), there are two other fields that also remain blank in the table, although populated on the form. I have a table called Products containing Product...
  14. 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...
  15. 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
  16. voltarei

    Multiple uses of a query field on a form

    Hi, Thanks for the replies so far, however I'm not sure I understand !! Maybe my initial description was not full enough, so I'll tell you how it all links together. I'm actually using 4 tables: Customer: Includes name & address data, with a Customer ID as the primary key Staff: Includes name...
  17. 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...
  18. 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
  19. voltarei

    Switchboard on open event

    Simple really !!!! Many thanks
  20. 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...

Part and Inventory Search

Back
Top