Search results

Hi, Thanks for response, I've managed to get the issue resolved now. Interestingly I'm using access XP and those old command were from using the wizard to create a command button. I got it working by simply doing a me.parent.requery Thanks again Tom

Hi, I hope someone can give me a hand with this problem as I've been struggling with it for days and haven't got anywhere. I have a form with a subform on it. The subform has a few command buttons. The buttons modify some of the data on the main form and I need the have the data on the main...

Thankyou all for your help, I've redone the problem form now and it seems so be working but when I've got a chance this evening I'll definetly try out the spaces on blank lines theory and give my code a general tidy up. Big thanks to ghudson too, the movesize thing was just what I was looking...

What I'm aiming for is for the information in the pop ups to display details for the record on display in the main form. So, don't I need to requery the popups when I change a record on the main form? How do I cause a "docmd.requery" to be carried on a different form to the one that caused the...

I've moved evrything over to a new database now (except for the problem form) and redesigned the problem form with a few less subforms. I've got a few buttons that pop up subforms on request and it all seems to be working now, fingers crossed. The solution isn't ideal as the pop-up forms (which...

I think I get what you mean however the database I'm using isn't live yet so it only has a small amount of test data in it. I've tried deleting ALL records from my database and still get the same symtoms. The problem form has about 8 sub forms on it, could that be the cause of the problem? Tom

Hi, Thankyou both for your help. I tried the decompile switch but it didn't make any difference. I'm going to try copying the rest of the database to a new one and see if that helps. How would such a corruption come about and how can I guard against it in the future? Thanks again Tom

I'm a bit not too brilliant with access events but I'd try putting in in the afterupdate event, just cut and paste the code into the VB thing that comes up. Let me know if you need more help. Tom

When I try to save the "Main customer details" form from design view access says it has encountered a problem and needs to close. I'm unable to finilise the design of this form and unable to finish this project. If someone could just tell me whether they can reproduce the problem or not then I...

I want to create a form filled with summary statistics from various table within my database. The statistics are all counts and sums. For me to do this do I need to create a seperate query for each SUM fromeach table then combine them all using another query or is it possible to SUM and COUNT...

I'd recommend looking at the sample database which is included with access XP. There a report in that which which returns data between a user specified date range. It should help you with the design of the form for users inputting the date range. If you customise this to allow the user to enter...

Thanks for your help regarding this, however I'm still unable to resolve either of the two issues. The line: If IsNull(Me.Restricted_membership_purchases_subform.Form![membership type purchased]) Then is evaluating to false whether [membership type purchased] is null or not. And I have been...

Thanks , that clears it up nicely for me. Thanks again for your time Tom

Hi, I have a form, with a sub form on it, and the sub form has two subforms of its own. I want the main form to only display one of the sub sub forms depending on a field on the main form. The code I'm using is below. The problem I'm having is that when I change records or load the form it says...

Thanks Hi, Thanks for your solution, it was very helpful in helping underdstand how queries work. One small problem I had was put the "True"'s on the the same line in the criteria section. It seems to only work properly if they are on different rows. Many thanks Tom

How do I design a query that returns all records that have one or more null fields in them. Or one that returns records if one of a predetermined subset of the fields is null? I can't for the life of me work out how to do it so any help would be welcome. TIA Tom