ms access training - Random pop up prompt

The UK's most regular instructor-led training courses.
Training information: ms access training · Microsoft.access.courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Random pop up prompt

Marie has attended:
Access Intermediate course

by - delegate Marie [4 posts] (2007 Jul 19 Thu, 09:49) Reply

On our (very old) database we have a popup box prompting for a code relating to a very old query, that just pops up randomly when you're in the middle of entering data in a form. Does anyone know how to trace what's causing this and get rid of it? Clicking 'ok' gets rid of it and doesn't seem to affect the form at all but clicking 'cancel' stops it from displaying certain info on the form.

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Bayswater	0	FULL
2003	2008 Sep 3 Wed	Southwark	2	book now	£235	£240
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	8	book now	£110	£224
Full Schedule: See all 55 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Random pop up prompt

by - trainer Richard platinum contributer [785 posts] (2007 Jul 30 Mon, 12:13) Reply

Hi Marie

Your question requires us to see the database, and may require a consultant to work on it to remove the box.

You are welcome to discuss this with our enquires team on 0208 682 4973 to see how we can assist you.

Regards

Richard

RE: Random pop up prompt

by - delegate Marie [4 posts] (2007 Aug 2 Thu, 12:37) Reply

Thanks for response - I've actually identified the problem and fixed it, there was an old query running every time I opened up the table and this was generating the box.

· Why consider Access Visual Basic training?
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Microsoft Access 2007: New Features
· Access VBA Handling Errors and Debugging Code
· Access Database Optimization: First Normal Form

Access tip:

Label printing

You can create a report in Access for printing labels All you have to do is is click New under the Reports object and then select Label Wizard and follow the steps

View all Access hints and tips