Search results

Hi Guys, I have been trying to create a junction table to remove the need to use multiselect fields (as they are not very transferable to anything else!) and have got a bit mixed up as to how to do it and whether I need to have a unique ID for the junction table and how the foreign key...

HI Guys, I have a problem that occurs when you create a new record and start typing in the name field. If you change your mind and delete what you have written so that there is no longer any text in the box if you try and do anything else the Invalid use of Null error message comes up. How can...

Hi Guys, I have a strange problem with one of my forms that only occurs sometimes. I have a few fields in the top of the form with buttons and a set of subforms below them in a page tab layout so that you can click on different pages. The problem I have is that sometimes when you go into the...

Hi Guys, I have a form that has supplier names on it and I have now created a supplier ID as a primary key. Before I changed this the records were in alphabetical order. But when I created the ID they were sorted based on the supplier ID. I managed to change the form record source to a query...

Hi Guys, I have the following code in the beforeupdate event for a supplier name. It works if I try and put a new supplier in with the same name (and undoes the entry if it is a duplicate) but if I want to edit the name by perhaps putting a capital letter in then it gives the error message..is...

Hi guys, I have been using the search box at the bottom of my form next to the record selectors to do searches for records. I would like to find out whether it is possible to make the search box search the subforms on the main form as well as the main form fields? Thanks! VB:)

Hi Guys, I have searched the forum for the answer to this question but have not found the solution yet. I would like to get rid of as many macros in my database as possible and rely on the VBA. I have a button to delete a record on my mainform, which I have put the following code: Private Sub...

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

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

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

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

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

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