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

    Subform help, really simple!!

    Hiya At the moment i have 4 queries, i can use the subform to view the contents of one query in a form, right clicking on the subform in design view and selecting properties, then source object the following is shown. query.BS12 4FL BS12 4FL is the name of my query How do i use the same form...
  2. jon182

    Help with option compare database

    What i want to do is when a paper is selected from a combobox in a form, the price of the paper is displayed in a textbox below it. The text below is what i have so far, it doesn't work and i can't see why! It is entered in 'event'/ 'after update' Combo36 is the name of the combobox being...
  3. jon182

    Using vbscript to centre on map in html document

    Hi i have a html page with a picture of a map divided into squares. What i would like to is when the hyperlink is clicked the appropriate square is centred and maybe zoomed on the screen. Im sure there is a way to do this so please help me!! Regards Jon
  4. jon182

    dlookup help please

    i have the following tables with customer details filled, address, county, town, and post code. I would like to use the dlookup function in a form so that when the post code is entered the town, county and address are automatically filled thus avoiding errors. The tables are all linked...
  5. jon182

    Zooming into map

    I have a map which is divided into square sections, A1, B1, C1 etc On the left are hyperlinks that link to the appropriate square. I would like so that when a hyperlink is pressed the appropriate part of the map would be zoomed into view onto the screen Jon
  6. jon182

    SQL help with linking form fields

    I have the following tables town, street, postcode, which are linked. What i am trying to do is in a form when someone enters the post code, the street and town for the post code would be displayed. Or if someone enters a town, only the streets + Post codes for that town are displayed. Im...
  7. jon182

    Query to sort Post Codes for newsagent

    I am working on a database for a newsagent, for a project. A feature of the database is going to be an autoroute planner, which decides what routes the paper deliverers go on. I was thinking about using the houses post codes used by Royal Mail in a query so the houses that come between say...
  8. jon182

    changing the record source

    How do i change the record source for the form. ive done as the ms help file says and right click on combo box and select propertiers, but it's not listed. Please help Jon
  9. jon182

    problem with form selection

    I have the following tables town, street, postcode, which are linked. What i am trying to do is in a form when someone enters the post code, the street and town for the post code would be displayed. Or if someone enters a town, only the streets for that town are displayed. Im sure there is a...
  10. jon182

    okay, here goes. i have 4 tables l

    okay, here goes. i have 4 tables liked together, town building postcode street these tables include relevant info, e.g postcode has many postcodes... What iw ould like to do is in a form using a combo box use the postcode to search for a property, and then the other info linked with postcode...

Part and Inventory Search

Back
Top