Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5
This is the forum to discuss the Wrox book Beginning Visual Basic 2005 Databases by Thearon Willis; ISBN: 9780764588945
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old July 25th, 2006, 08:47 AM
Authorized User
Points: 406, Level: 7
Points: 406, Level: 7 Points: 406, Level: 7 Points: 406, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2005
Location: Florida
Posts: 88
Thanks: 4
Thanked 0 Times in 0 Posts
Default Deleting A Record

I am trying to delete a record from an Access database following the example in Chapter 7 and having a problem with the data types.

The Parameter field that I am trying to use is an "Auto Number" and a Long Integer in Access. The source for the parameter is a Text Box When I try to write the code in VB the pop-up doesn't list a long integer and I can't complete the code. I have tried (without success) several alternatives,

Have you any suggestions?

  #2 (permalink)  
Old July 31st, 2006, 07:12 PM
Thearon's Avatar
Wrox Author
 
Join Date: Dec 2003
Location: Fuquay Varina, NC, USA.
Posts: 396
Thanks: 0
Thanked 8 Times in 8 Posts
Default

A Long Integer in Access maps to an Integer data type in the OleDbType enumeration. The maximum value for this data type is 2,147,483,647.

Thearon


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems deleting a record donrafeal Access VBA 0 January 18th, 2007 06:19 PM
Confirm before deleting record jgrasso BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 March 30th, 2005 12:03 PM
updating and deleting record PinkyCat Classic ASP Databases 4 March 16th, 2005 05:50 AM
Deleting a record AND the images? jonpanky MySQL 0 January 4th, 2005 12:13 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.