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 strongm 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. jon182

    Subform help, really simple!!

    ok sounds promising!! ill give it a go thanks for the help
  2. jon182

    Subform help, really simple!!

    thanks for reply yes but doing it that way only allows me to select one query at a time, i want to view multiple queries in the subform
  3. 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...
  4. 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...
  5. 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
  6. jon182

    dlookup help please

    Hi thanks for replys I have a table with post codes in it, once the post code is selected i would like to display the full address on the form Jon
  7. 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...
  8. jon182

    Zooming into map

    any1? ;(
  9. 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
  10. 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...
  11. jon182

    Query to sort Post Codes for newsagent

    well its going to take a lot of thought, its turning out to be harder than i thought with the introduction of holidays and looping round routes!!! Thanks for the input B827 Jon
  12. 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...
  13. jon182

    changing the record source

    ahhh that's it, thanks Paul the Microsoft Help file isn't very clear!! thanks again Jon
  14. 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
  15. 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...
  16. jon182

    okay, here goes. i have 4 tables l

    thanks for the reply the tables are linked together without referential integrity
  17. 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