Need count of updates after UPDATE query

Is there any way to get the count of updates after running this?

strSQL = "UPDATE ..."
currentproject.connection.execute strSQL
0
Utf
2/15/2008 8:04:00 PM
access.queries 6343 articles. 1 followers. Follow

1 Replies
704 Views

Similar Articles

[PageSpeed] 17

On Fri, 15 Feb 2008 12:04:00 -0800, mscertified wrote:

> Is there any way to get the count of updates after running this?
> 
> strSQL = "UPDATE ..."
> currentproject.connection.execute strSQL

Look up the RecordAffected property in VBA help.
-- 
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
0
fredg
2/16/2008 12:11:30 AM
Reply:

Similar Artilces:

Need help configuring Symbol LS9208 scanner with RMS
I just finished installing the OPOS driver for the scanner and I try to configure it on the Microsoft OPOS Servce Objects but it has been unsuccessful. Please help. Thanks! ...

WAMU absorbed by Chase
I had an investment account with WAMU - now with Chase. Money can't update it anymore. I have set up online access with Chase on their website, so have a user name and password. But can't figure out how to change the WAMU investment account in Money (Plus) so it knows the account is now with a new institution with a new name and password. Frustratingly, Money Plus Help on this subject refers me to web pages that say "this topic cannot be found". I cannot even figure out how to turn off automatic update for this one account. Don't want to turn it off for all of t...

MS Money Premium Plus
I purchased and upgraded my Money Premium 2007 to Money Premium Plus two days ago. Everything went well until the second time I logged on. I connected to the banks to update my accounts and now in the upper right hand corner it shows it is updating accounts. It has done this for about 10 hours (despite me restarting Windows Vista Ultimate and restarting money). When I close the program it continues to run (in the background) and requires a manual Ctrl + Alt + Del (terminate process) to end. Any help would be great as I cannot accept and update transactions while it is updating the ...

need urgent help!!!!!!!!!!!!!!!!!
hi i wanted to be able to add or upload images from the form? i have a field called image which is a data type OLE Object, i right click on the field click on the insert object option on the menu an a bitmap image is linked having browsed for it and clicked on the link check box. i want to be able to add images from the form not go to the datasheet view? can you help me please!!!!!!!! also i wanted to have a button assigned to a text box in the form in which you input the image path( where the image is located) and a click of a button the image is displayed in the datatype OLE object f...

Dissapearing Query
Hi all, I am working with a multiple parameter search query. The form I am using to conduct the search displays the results in a subform. I have gone through and really combed through the SQL to make sure there are no blatant spelling errors or incorrect references within the code. Anyways when I open the form that it is attached to, I keep getting the boxes described in this website http://allenbrowne.com/bug-13.html .. The form is open, and I even changed names of fields in the table in case SQL was choosing to be picky about what I named my fields. Is there anything else that would caus...

Microsoft update patches
Anyone know why there isn't any or at least explain why when I scan my computer at Microsoft update site nothing shows up ? snooker416 wrote: > Anyone know why there isn't any or at least explain why when I scan > my computer at Microsoft update site nothing shows up ? Maybe you are up to date? Maybe you installed a beta release of a service pack, never uninstalled it and replaced it with the full version? You did not give enough information. Start button --> RUN --> type in: winver --> click OK. Come back and type - verbatim - what the picture at...

need help calculating percentage
I am selling some personal items that are listed on a spread sheet. In one column I have the listed retail price in the other column I have the price I am selling at. The third column, I want to show the percentage of the discount example retail $75 - selling for $30 - discount is $ ? I know this can be done, I just can't figure it out on my own. I would really appreciate your help. Rene' Rene, I think this will do what you want retail in A, selling in B1 in C1 put =(A1-B1)/A1 -- Paul B Always backup your data before trying something new Using Excel 97 & 2000 Please p...

need to shorten up document so I don't go to next page
I have a rental agreement that I have added text to and now i cannot get it all on 2 pages as I don't know how to remove some of the spacing between sections so that I can shorten it up enough to get it on 2 pages. It is a read only document in word and I am able to add text but not sure how to remove some of the spacing . If it is a read only document then you cannot do anything, end of story. If you could edit it you just have to delete line feeds that are surplus. But to get good answers you should ask in a WORD newsgroup because here most people have expertise in MS Publisher,...

counting mail messages
We are running Exchange 5.5 on an NT server. We use Outlook 2002. Is there a way that we can count incoming and outgoing messages? Performance Monitor has counters for this. -- John Oliver, Jr. MCSE, MCT, CCNA, Exchange MVP Microsoft Certified Partner "Marilyn" <anonymous@discussions.microsoft.com> wrote in message news:D43B15F9-54DE-49F5-9412-CE1A93A739F8@microsoft.com... > We are running Exchange 5.5 on an NT server. We use Outlook 2002. Is there a way that we can count incoming and outgoing messages? John, I see what you are talking about in Performance Monitor...

windows xp sp3 update cannot display this page
i cant update any computer in my house. for some reason when i try to update it pulls up a second window(insted of active x bar) and stops and says internet explorer cannot display this page. What am i doing wrong? I even have an older computer here that for giggles I would try to get it updated (xp no sp). and it does the same thing. I am confused. Thanks What browser (exact version) you are using. -=- Thank you "Budman" wrote: > i cant update any computer in my house. for some reason when i try to update > it pulls up a second window(ins...

Update: Microsoft Dynamics GP Customisation Training
Registrations for the Singapore Training courses are closing soon and we need a few more attendees to ensure that the classes run. Please note that the GP Customisation tools (Dexterity, Report Writer and Modifier with VBA) will be used for the core Microsoft Dynamics GP client for at least ten more years. Training opportunities for these tools are rare worldwide and even rarer in the Asia Pacific region and this is an opportunity that should not be missed. Having knowledge of Dexterity and Modifier/VBA allows the consultant or developer to better support and customise the Microsoft Dy...

Need a seperate discussion group for Visio 2010 Beta
I am struggling to find any on-line support for Visio - It's not even listed under any of the major categories. -- Neville ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=7338203e-5b61-...

Need Help, Outlook 2007 problems!! :(
something is very wrong with my OUTLOOK - all of incoming messages are going into one of my folders (can't find a rule that would make that happen). Someone said he received 65 emails from me yesterday (I didn't send him 65 yesterday) but... when I went to log out last night there were messages in my OUTBOX that should have gone out days before - HELP????!!!! I just heard from someone else that they received a bunch from me that I didn't send and many are repeats - things are also going to JUNK that never used to go to JUNK. I don't want to lose my data. Please help me. Thank...

Counting Ranges
I would like to count a range if all the numbers in that range meet a stated criteria. For example I have 50 columns (so 50 ranges) and I want to see how many of these cloumns contain numbers that are all above 75. e.g. Column 1 has 76, 76, 78, 90 so that would be counted, Column 2 has 77, 76, 94, 83 so that would be counted also, Column 3 has 72, 76, 77, 79 so that would not be counted and the total would be 2. Hope that is somehow understandable - I am a bit of a beginner! One way... Assuming the 50 columns are in the range A1:AX4 and each column contains 4 numbers. ...

Need to upate union query statement every month
I have 47 union queries that collect data for 47 pumping stations on monthly basis; then plots each query result. Every month a table is added to the list of individual union query. I got tired of adding the union select statement manully to 47 queries and started to write a little module to handle it. Using Visual Basic scripting, I know how to create a table or a query in a database; I know how to add records to existing table, etc. But I don't know how to add a sql satement to an existing union query using visual basic coding. I have tried variours DoCmd actions and Variou M...

Table record count
Is there an easy way to get the number of record in a temporary table without iterating through? yes i just did that Declare @RowCount Int set @RowCount = (Select Count(*) from "YOUR TEMP TABLE") why not use countrecords() function - assuming dexterity here of course. patrick dev support -- This posting is provided "AS IS" with no warranties, and confers no rights. "Phil M" <PhilM@discussions.microsoft.com> wrote in message news:13090613-04BC-4960-8466-31A411FEC3E7@microsoft.com... > Is there an easy way to get the number of record in a temporar...

I need to restore it from a Drive Image to recover email. #2
What is the file name of the Outlook Inbox (Office XP)? ...

HELP
If anybody can help with this problem in Excel 2003 I will SURELY appreciate it! I have a list of 10,000 names in list #1. Each piece of information is broken down into its own column (First Name, Last Name, Company Name, Company Address, etc.) as it was exported out of Maximizer Enterprise in Lotus Notes. I imported this information into Excel. List #2 is a list of 5000 of the same names, but these names are those of list 1 that do NOT have email addresses. These are the people we postal mail information to. What I have to have is list #2 subtracted completely from list #1, which will leav...

Money 2005 duplicates entries on update
When MS Money 2005 updates my Technology Credit Union Visa account, it duplicates all of the entries, but the balance is correct. If I manually delete the duplicates, the account balance is incorrect. This behavior seems incorrect to me. How would I delete the duplicates without affecting the balance? How can I get MS Money to not duplicate the entries. If I perform a manual update, the entries are not duplicated. In microsoft.public.money, chuck c wrote: >When MS Money 2005 updates my Technology Credit Union Visa account, it >duplicates all of the entries, but the balance is co...

10.1.2 Updater Error Message
Hi, Got a new G5 computer and installed Office X on it. I then loaded SP1 and 10.1.1 and they went fine. Now when I go to run 10.1.2 I get the following error message: 11002:2-15 and then it bombs out. Any ideas on what could be causing this error. Thanks, Peter Nehem P.S- Anti-virus software has been disabled and also tried it out in safe mode. ...

count a character
How can we count the number of times a character is appearing in a cell, i.e. if I enter a text in a cell, how many times "L" is appearing in it? thanks in advance Try this... =LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),UPPER("L"),"")) Case being equal: L and l are the same -- Biff Microsoft Excel MVP "hsg" <hsg@discussions.microsoft.com> wrote in message news:4DF0E642-9BB0-49B1-8FF0-3269E6CF9F42@microsoft.com... > How can we count the number of times a character is appearing in a cell, > i.e. > if I enter a text in a...

Count by highlighted color
I want it to count if the cell is highlighted in yellow. Is that possible? Hi see: http://www.xldynamic.com/source/xld.ColourCounter.html and http://www.cpearson.com/excel/colors.htm -- Regards Frank Kabel Frankfurt, Germany Brandy wrote: > I want it to count if the cell is highlighted in yellow. > Is that possible? Not as easily as you think. Out of 16 million colors hope that means the one that actually is yellow. #FFFF00 It is not a good idea to do this. Much better would be to use some criteria on the worksheet. And you could filter on value with Filter or AutoFilter, ...

Update from Recon button in Cashbook Bank Management
The Update from Recon button should have a prompt linked to it to allow a user to cancel the process if the button is hit in error. Currently if a user hits the button the update occurs and this can lead to errors in the application. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the ...

NEED Help With Office Document Imaging Software
I use a software which uses Microsoft office document imaging software to open the pictures.? I want every time when I open a picture, it should open in a new window. Right now it opens in the same window of Microsoft office document imaging software. Change your file association. Win XP http://support.microsoft.com/kb/307859 Vista http://articles.techrepublic.com.com/5100-10878_11-6172036.html -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "SheLady" <SheLady@discussions.microsoft.com&...

Updates to M2005
In the past versions (and also in M2005, I bet), MS has quietly and secretly (I think the word is appropriate) updates Money without telling us when the changes were made and what the changes entailed. Everytime we sync accounts, we would get a msg saying "Your Call was successful" under Money updates. I hated that. I'd rather know when the updates have been released, what they cover, and then decide whether to apply the "patch". Like many, I am waiting for the 1st major update to M2005 before buying, installing, and trying M2005. Will we know when such major...