Appending queries

Resolved · Low Priority · Version 2003

Thu 19 Mar 2009, 16:30 Delegate Rick said...

Rick has attended:
Access Intermediate course
Access Advanced course

Appending queries

When I tried to run an append query I selected my table to take entries from, but the table I wanted to append them too was not available on the list. When I reversed the process, switching the tables around it worked perfectly. Numerous attempts and fiddling later, I could not work it out.

Sun 5 Apr 2009, 08:06 Trainer Rajeev said...

RE: Appending queries

Dear Rick

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

This problem could be because of several reasons and I have researched on the web for a while now to see what could be the best possible reason for this problem.

I managed to come across the following link. I know that the thread to this link is quite long but it provides you with many possible solutions that could rectify the problem. Just keep on pressing the RE: thread to see the reply to the post. If you have problem understanding how to navigate through these posts then please let me know.

http://www.eggheadcafe.com/conversation.aspx?messageid=31880830& ;threadid=31880830

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Mon 13 Apr 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.