Search results

  1. V

    Multi-Select LIstbox can it be searched easily?

    Would you use that concatenate code to fill in the postal area code in the datasheet view of the subform for services? How would you get that view instead of the great long list that would be stored in the original table???
  2. V

    Multi-Select LIstbox can it be searched easily?

    Ha ha, thanks! I started learning access a month ago, so learning lots but in a very unstructured way! It would be good to have a web based solution that would be the aim, would you use SQL and vba.net, am still not quite there with understanding what it all is about!?
  3. V

    Multi-Select LIstbox can it be searched easily?

    the ideal solution would be a map pop up but would take a few years before i could learn to do that i think!
  4. V

    Multi-Select LIstbox can it be searched easily?

    I suppose the main point is to ensure that the postcodes can be searched, ie if i do a search I want to search for a service and find out whether it is covered in a certain postcode or group of postcodes. It doesnt matter if the datasheet has a long list as long as it can be searched..because at...
  5. V

    Multi-Select LIstbox can it be searched easily?

    Hi, the maximum number of postcodes per service would be the whole country which I is 124, which I think is possible if a service is across the whole country...what do you mean by over-stretching the pop-up list?? Thanks again,VB
  6. V

    Multi-Select LIstbox can it be searched easily?

    Hi VbaInet, Thanks very much for the response. I have the services table as a subform (show in datasheet view) within a suppliers form so that the user can see what services the supplier has. If the postal area info is saved as option 1 then the table would be very long in the supplier form. So...
  7. V

    Multi-Select LIstbox can it be searched easily?

    Hi guys, I have a set of services that are repeated over postal areas. I would like to find out whether it is better for searching the database whether to have a multiselect listbox when the user enters the information or to have a line for each service repeated for each postal area. Option...
  8. V

    Subform in Datasheet View display only one column

    Thanks Trevor, it didnt seem to work, it showed the actual name instead of the label name...thanks VB
  9. V

    Subform in Datasheet View display only one column

    Hi Guys, I have a subform within a page of a form. I would like it to display as a datasheet type view so that it can be edited. I am using the form and its pages as a place to change the choices for my drop down menus. I have made the subform show in datasheet view but I would like it to only...
  10. V

    Unique outputs to a filter using VBA

    I think i have just also realised that the code does not work for multiple select as I do not get the string output with the waste type included when I select more than one type! How would i incorporate a for loop into the code without breaking it! Thanks!
  11. V

    Unique outputs to a filter using VBA

    Hi Guys, I have used the following code to create a filter to find information on suppliers based on 3 criteria, postcode, waste type and container. I have the output textboxes set to show the supplier and contacts. I have also changed the combobox to allow extended selections which allows a...
  12. V

    MAP in database

    I have used mappoint and it is not the type of thing that i need, i just need a map interface it doesnt have to be linked to actual GIS data.
  13. V

    MAP in database

    Hi guys, thanks for the info, all i need the map for is to perform searches based on the areas that the user clicks on, so i dont need any very specific GIS info. Could anyone tell me if the map that I put the link to could work in an access database as the UI to a query?? thanks!VB
  14. V

    MAP in database

    Hi Guys, I would like to find out whether it is possible to have an access database with a UI with an interactive map like the ones for sale on this website: http://www.fla-shop.com/country/uk/multi-level-postcode-uk-1-1-demo/ I called the website and they were a bit clueless as to the...
  15. V

    Child Table only on first page of tabbed form

    Thanks very much Stopher that worked!
  16. V

    Child Table only on first page of tabbed form

    No, I will be adding at least 3 tabs to the form
  17. V

    Question How do I get the short date using now()

    Thanks guys for the speedy responses!:D
  18. V

    Child Table only on first page of tabbed form

    Hi, I created a form using the wizard which automatically put in a table that were related to the forms own table. So I have a table of fields in my form. But I then decided that I wanted a tabbed form within the form that could be used to include more information. So I inserted a tabbed form...
  19. V

    Question How do I get the short date using now()

    Thanks Paul, that worked! Cheers vicky
  20. V

    Question How do I get the short date using now()

    Hi I have used the following code in my form to automatically update a date field when a user enters information or changes info on a form. Sub Form_BeforeUpdate(Cancel As Integer) Me.Sup_Update = Now() End Sub However I would like the date to be displayed without the time. Is this possible...
View older results
Back
Top Bottom