Recent content by IqbalS

oops missed the link, although the orginal query itself is still not updatable... And there it is the query was snapshot too and so would have always not been updatable. And updating the indices did indeed enable access to work it out - and made it a bit faster too! Bananaman thanks for all...

The query cannot be changed. The form's recordsource is the query and I haven't been playing with the recordsource anywhere else! I have a backup which is as it should be - the only relevant thing i've changed is the indices on the tables its referring to. I've managed to lock the form down...

Ah right, how about doing a check if the recordset.recordcount = 0 then show a messagebox and display either the last filter or a standard sql statement. I hope that helps

Thats the catch, the query is still not-updateable and so the form shouldn't be either. Opening the query I cannot change the values as expected. However opening the form based on the query you can edit the values furthermore these values are actually saved in the table?!

Someone explain this one! The query and therfore form by design has until now been non updatable and its been working great. Somehow the form has become updatable even tho the properties have not changed, so allowedits etc is all set to no. I have noticed now that the openform command was set...

Have you tried to change the sql to remove the like? that way when you search for Ken then only Ken and not Kenneth should come up! Hope I didn't miss the point Cheers

Hi all, Has anyone tested which method is faster to open up. I currently have a form which when I open I am filtering it by adding to the where condition on the docmd.openform method. I noticed that the form opens quickly however it takes some time to limit it to the result required. I did a...

ahh ha, i'm being a little dumb. just need to switch it around a little: - instead of validating on the close of the form i'll consider: 1. click button 2. open form to select dates 3. close date form & return values to first procedure 4. check value returned -> if null then exit sub else...

I'm stuck again :( I've made this lovely form to be modal and when it closes its takes its values and happily continues the procedure. The only problem is if someone was to close the form without the filling the values - (it continues with no dates!) I can disable the close button but there...

Thanks for your reply, although I couldn't get it working to start... the argument works if the view is not acdesign, works great. Thats a much better solution than what I had brewing...!! Thanks again

Hi I was wondering whether anybody could help me - I have built a little form where the user can select dates and it stores the value. What I need is some advice on how I can make it that on clicking a button it opens the date form (which i'll set to popup and modal), let the user fill it out...

Dennisk, thanks for you reply. I finally managed to get something working, would anyone beable to advise me a little further - i'm not particularly good with recordsets as i've not really needed to use them much before. Just tested this on a separate form: Dim db As DAO.Database Dim rs As...

Hi, firstly thanks to all the useful information and advice already posted on this forum! I was wondering whether anyone could help me with a problem. I have a main form consisting of a subform which is filtered to show specific results, and it also needs to show specific figures at the top i.e...