Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display in warning

Status
Not open for further replies.
JeffreyMorrison

JeffreyMorrison

Programmer
Jul 25, 2002
10
CA
I'm running a number of queries(select,append,delete,and maketable)from a macro. I turned of the warning messages by using:
Docmd.setwarnings=false

What I need to to is assign these procesed record numbers that appear in these warnings boxes to a variable.

I run my queries by using these statements:

stDocName = "Query1"
DoCmd.OpenQuery stDocName, acNormal, acEdit
stDocName = "Query2"
DoCmd.OpenQuery stDocName, acNormal, acEdit

Any help that can be offered will be greatly appreciated!!!!
 
Status
Not open for further replies.

Similar threads

2009luca
  • Question
put value in input box web page
Replies
0
Views
197
2009luca
2009luca
sal21
  • Locked
  • Question
scrping in listbox in a web page
Replies
0
Views
596
sal21
sal21
Andrzejek
  • Locked
  • Question
Hyperlinks in Word cut at #
Replies
2
Views
444
Andrzejek
Andrzejek
R
  • Locked
  • Question
reversed words in english leading new english words
Replies
10
Views
585
Chriss Miller
C
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
1K
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top