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...
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...
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
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...
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
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...
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
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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.