Recent content by Kiwi-Wombat

Again I owe you thanks Worked well

Hi again I tried to expand on this by making MyTableField a variable as well. I assumed that I could just enclose varField in quotes but it never finds the item even though it exists. Dim db As DAO.Database Dim rst As DAO.Recordset Set db = CurrentDb Set rst = db.OpenRecordset("MyTable"...

Tried it last night & worked great Thanks

Oh OK. Is that because it is a string variable as opposed to an integer?

Thanks for that

Thanks frostysnoman & pbaldy. I realise I was not specific enough with my query and also that I had an error in the code I had typed. I did search using a variable. I have edited the post to explain myself better and corrected the code. Would either of you of anyone else like to hazard a...

Hi I am having problems with FindFirst. I am trying to search for a word in a specific text field in a table. The text field is not a key field but is indexed. Prior to calling the following code, varSearch (a string) has been assigned a value by user input. Assume that value is "England"...

In a listbox (DisplayResults) when a user selects an item you can use code to find that item e.g. -------------------------------------- Set rs = Me.RecordsetClone rs.FindFirst "[WordsID] = " & Str(Me![DisplayResults]) Me.Bookmark = rs.Bookmark...

I have been given an answer in another forum and I'll post it here for anyone that needs it code:--------------------------------------------------------------------- Dim db As DAO.Database Dim rst As DAO.Recordset Dim SelectedList As String Dim...

I am not sure I can describe it any other way. If my code is not clear to anyone please let me know and I'll upload a sample

I want to assign a Listbox to a variable (the listbox name not the contents) e.g. Dim SelectedList as as ListBox Select Case whatever case 1 SelectedList = ListBoxName goto OtherCode case 2 etc End select OtherCode: SelectedList.Requery The error message I get is...

Sorry - I meant to say 4 separate tables with a listbox for each Thanks for your answer, all clear now. I saw CurrentDb and immediately thought of a table rather than the actual .mdb file

Not sure I understand If the code is on the form which has no source, and there are 4 separate databases as queries on the listbox sorurce which is the CurrentDb?

HI folks I see this code commonly Dim db As Database Dim rst As Recordset Set db = CurrentDb Set rst = db.OpenRecordset("yourTableName") To what does CurrentDb refer? Does it refer to an actual table that is open or is it an object like 'Recordset' and 'Database'? I previously posted a...

I was about to ask that one as well. I hope someone has an answer