Search results

Thanks Mate, Works a treat

Morning All, I cannot find the answer to my question anywhere. I have an address field named 'ADDRESS'. I want to run an update query so that the first two words of the address are split into a new field named 'AddressSplit'. Therefore if the full address showed the following 'Ruby Cottage...

Morning All, I have a form that users access where they can deal with their own records. Currently the form shows all records for all users. I am trying to use code that will retrieve the users logon ID and match this to their name in a table. I want the form to use this to automatically...

BY the way I get a message stating 'Type Mismatch'

Hi, I have tried this but it doesnt seem to work for me. I want the button to show details based on the reference and suffix. Here is the code used Private Sub ViewDetails_Click() On Error GoTo Err_ViewDetails_Click Dim stDocName As String Dim stLinkCriteria As String stDocName...

I'm using 2003. If I ensure that the properties is highlighted forthe tab control there is no option for special effect. This only appears if you have selected the detail section of the form. This can happen even when clicking in the are of the tab control for some stupid reason

This doesnt work either. It changes the special effect of the form detail page not of the tab control. Thanks

Hi All, Could anyone help. I am sure I previously created a database where I used a tab control that was flat on the form. I have created anew database and cannot seem to find out how to get make tab control flat. It is raised on the form making it look a little stupid. Would be grateful...

Good Afternoon, I am hoping to get some help here. I have a table where one of the fields are a six digit sort code. I want to change the sortcode so that it is in the correct format. 12-34-56 rather than 123456. I have tried to just change the validation rule to Like "**-**-**" but this...

Hi, I'm new to using queries in Access and am stuck on trying to run a query from a table. I have thousand of records with fields such as customer name, Company Name, Company Country and Balance. What I want to do is run the query to count the number of Companies within a country. I use...

Hey Statsman, This has worked perfectly for me so thank you. I was just wondering. If I select an option for the combobox all my field updated which is perfect. What I need to know is if I make a selection and was meant to leave it blank. I can manually delete what is in the combobox but...