Search results

Well, you'd never believe what the problem was..... The routine was fine...no problem...worked a treat. But I had added a clock display to the main menu screen which refreshed every second - thought I was being clever! Have now reset refresh time to 60 seconds and all's well...again. Dave Eyley

Thanks - Mile-o-phile. I take on board what you say but it doesn't explain why it's happening. I have noticed differences in the behaviour in Access XP and Access 97. I wonder if this is just another quirky difference. Dave E

Thanks for the responses... The Flag isn't the problem..and I write the routine for adding items to the list because I think it's more user-friendly. Seven out of ten times the routine works fine..and I mean when the form is open repeatedly adding new items, so there can't be any differences...

I've found what seems to be a problem. I have a form on which a user can use an unbound Combo box to select an item from the list. I don't use the 'Not in List' facility - instead I wrote a short piece of code that compares the entry with the table to see if it exists already and if not, it...

Having looked at the form, I wonder why they have to be listboxes? Why not have them as Combos, then when the user selects one or other or both and then hits the REFRESH button the code behind the button checks for one or both combos and produces the filter for the subform..... The combos can be...

Well, my guess is that you haven't told the report which record you want printed and there are 11 records in you table.... You should be using the statement - DoCmd.OpenReport "MyReport",acViewNormal,,"[PrimaryKey]=Forms!MyForm!PrimaryKey" This should limit the print to the one on the...

If the table (tblProducts) is only used for the RowSource for the Combo, why not make the RowSource for the Combo the table that holds all the details for all of the products.... This way the Combo list will be dynamic i.e. it will grow/shrink depending on the records in the main table...

I do this by having an abridged list of selected records in a datasheet. I pick one the fields, usually the one that sits on the left of the list. I open the form in Design mode and edit the ON Click property for the field. The code entered will be something like - DoCmd.Openform...

Tim, Worked a treat - thanks a lot. Dave E

Thanks Tim, I'll give it a try - it looks good. Dave E

Does anybody know of a way to check a Combo's Rowsource result to see if anything will appear in the combo before it's used. e.g. I have a Property database with Combos to locate the Space in the property - 1. Site 2. PropertyName - based on Site above 3. Block - Based on Property above 4...

Thanks Wh00t, I did get it to work in the end, but I'm still not sure how. I tried so many things for so long. It was something to do with the Format property and the Combos I was using to select the Yes/No option for the search criteria. Anyway, that's another problem done. On to the next...

Hi wh00t, It should be so simple - I have this Yes/No field called 'Leased' and I need to search on it as part of a string search. But when I put in the code like - Searchstr= "[Leased]= " & Me!Leased and apply it as a filter, it doesn't work. Yes/No fields aren't the same as text fields...

I am building a search string called PropSearchstr which is used as a filter for a subform. I have used this to filter by PropertyName, Status etc but I want to add a search field for a Yes/No field. The short routine in the AFTERUPDATE property for the Combo which selects either Yes or No is -...

An append query, once the floppy disc is in the same PC, would probably do the trick unless there were duplicate PKs involved. Once these were sorted out.......no problem. Cut and Paste wouldn't be that difficult either. Depends on the amount of data to transfer, I suppose. Anyway, Bigfoot's...

I would guess that the syntax of the completed SELECT statement is incorrect. Try looking at the BETWEEN date1 AND date2 bit. It should look like BETWEEN #date1# AND #date2# You should insert these # in the code. If in doubt, try to create the query using the Query builder, then switch to SQL...

Right Mouse Click on the column's data to be sorted and select the option. This should work in both datasheet and continuous forms view. HTH Dave E

One way to do this would be to - Create an empty database next to the one you're taking the table from. Import the table into the new database and save it to floppy. Take the floppy to the database where you want to merge the data. Open the receiving database in database view (ie no forms...

Have you tried - DoCmd.Requery(Forms!MainForm!SubForm.Form) Dave E

Can you post the db so that I can give it the once-over? If it's too big, can you just copy the bits we've discussed into a temp database and post it? There's got to be something simple going on here... If you can't do that, study the example again and copy the format exactly. If you tables...