Search results

I had a quick scan through the records thinking along the same line but could not see anything. I deleted all the records out of both tables to prove that orphaned records could exist and the same error message appeared. Strange!!!!!!

Hi Jal, Thanks for the comments however I already have a workaround for the issue so I don’t really want to start changing the actual query structure. What I would really like to know is why after 2.5 years should I have to change the properties of the query and will it have any future...

Hi, I have been running a multi user application (30MB FE with 100mb BE) for the past 2.5years now without any problems until this morning. The application fell over due to a corrupt record in one of the tables (ARF table). I am 99% confident that this was due to a network card problem as...

Can you post your db on here, it will make it easier to find out what works and what doesnt.

Not sure if this is going to help you but try putting this into the event of the button on your main form. 'Set focus to the subform Me.yoursubformname.SetFocus 'Perform an undo DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70

But surely that is what you are trying to do. 'Execute the event of a button that is in a subform but not visible.' or have I mist the question?

You could try calling the code of the hidden button. Call Me.subformname.Form.mybutton_Click

Your welcome.

The combo box does not work properly in the Db that you attached. However the way that you have set your Combo box up is to display 2 columns, they are ID and Allocate to. Because of this you then have to reference you query to the column of the combo box. or or just set your combo box...

Below the message box there is button 'Go Advanced' click this will then allow you to add attachments to your post. You might want to zip up the file first.

Can you post a copy of your form and query?

If your form is based on this query then all you need to do is requery the form Try replacing with That is providing the select query is correct... If you could post a copy of the form and query it would be easier to check.

This is usually what I do...

Well if thats the case, If he doesn't want the op to use the close X button then I presume that he wouldnt mind hiding the Access toolbars as well. Set the 'CLOSE BUTTON' property to 'NO' Set the 'POP UP' property of the first form to 'YES' Set the 'Moveable' property of the first form that...

Why dont you just set the 'CLOSE BUTTON' to 'NO' on the format tab of the form that you described above? Or altenatively Paste the code form you 'Exit database button' into the 'On Close event' of the same form? or have I missed something in this post?

:) .

hi again, Read your post aging and I think I might have missunderstood.... Try changing the query so that the criteria are not on the same row so it is an 'or' query instead of and 'and'. G

Hi grifter6 Do a google for 'between' You will have create a query that will give you results from the 1st of the month to the last of the month and the best way to achieve this is to use 'between' G

Your welcome, I have made some slight modifications that I will post here when I get the chance.

Date and Time picker Hi Dulux, This is one that I posted a while ago created in 2003, not tried on 2000. http://www.access-programmers.co.uk/forums/showthread.php?t=139466&highlight=calendar I hope it is of some help to you. Garry