Search results

Thanks, I just tried it but now when I try to save the query I'm getting a message "Number of query values and destination fields are not the same." Just a thought could it be that this is a concatenated field?

I have a piece of code to import a record into a Database, part of it is to update an existing table that populates a combobox. The problem I am having is that I get a message "Duplicate output destination 'txt_FullName'. If the item wasn't in the list I could understand it happening, but its...

So this is basically concatenation? Im assuming that after update with then bring them all together in the listbox?

OK i will explain, the form is to allow a user to add items to combobox on a separate form.. The items fall into four categories, Cadaver, Drugs, Explosives and Money. On the form for adding items there is a list box that is Alpha numerically sorted. I want all the items grouped to make them...

What second block of code please?

I just put it in the on change event and it didn't work, hence my asking!

What event should this be put on please? PS Thanks for your patience!

I'm basically trying to prevent anything being written outside of the brackets. The phrase "Cadaver () is put in the textbox automatically I want the user to be able to add text between the brackets. From the comments it would appear that I'm going about this the wrong way.

Thanks you, what about if I wanted to search for a wildcard after my brackets I thought that If Me.Breed Like "Cadaver ()*" might work but doesn't!

Im trying to sort out a wildcard problem that keeps creating a type mismatch. If IsNull(Me.Breed) Then MsgBox "|Please choose an odour type", vbOKOnly Me.btn_Cadaver.SetFocus End If If Me.Breed = "Cadaver (" * ")" Then Me.Breed.SelStart = 9 Else...

Do I still need to make it an Append Query?

I am running an Append Query [qry_AppendToWeatherFromGP] to update some comboboxes as part of an import function. My query is: INSERT INTO tbl_Weather ( Weather ) SELECT tbl_DetectionImports.Weather FROM tbl_DetectionImports; The function is: Private Sub btn_SaveImport_Click() On Error...

Sorry for the delay, been out all afternoon! The combobox row source is: SELECT [tbl_TypeOfHide].[Hide] FROM tbl_TypeOfHide ORDER BY [Hide];

Yup, the data is text. Ive added a couple of screen grabs, in picture 1 you can see the name "Trecenydd Ind Est" in the Venue. In picture 2 I have exposed the combobox and its empty as I hadnt added anything to it, except this imported record. Likewise with the field called Hide, when I...

I have a function on my database that allows a user to import information into their database from another user (after saving the excel spreadsheet to a folder on their machine) (this database is stand alone and not on a network). My problem is that the database contains a number of comboboxs...

Solved it, added an ID but didn't export it, then on the import it just auto adds so can use the ID t find the correct record.

I have a Listbox that I want to use to go to a record on a subform. I know that it cant be done with the wizard. The records that I am looking at don't have an ID so I want to look at both a date field [TrainingDate] and a Time Field [TrainingTime]. I have set the querry up and the list gets...

I get what you mean Bob, I'm not sure how to add the detail afterwards with code though!

I thought that I had solved this but it seems not! I have a textbox called Odours, there are four buttons below the textbox btn_Cadaver, btn_Drugs, btn_Explosives and btn_Money. On licking one of the buttons a value will be put in he textbox i.e. pressing the btn_Cadaver will put the value...

Thanks but no, thats not what I need ed, I have found what I was looking for Me.Odour.SelStart = 7