Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-09-2013, 06:33 AM   #16
newcomer
Newly Registered User
 
Join Date: Jan 2013
Posts: 9
Thanks: 2
Thanked 0 Times in 0 Posts
newcomer is on a distinguished road
Re: Using a listbox to delete a record

Sorry, my bad.

I can get the record using a normal query window.

newcomer is offline   Reply With Quote
Old 01-09-2013, 06:56 AM   #17
spikepl
Eledittingent Beliped
 
spikepl's Avatar
 
Join Date: Nov 2010
Location: San Serriffe
Posts: 6,144
Thanks: 77
Thanked 980 Times in 958 Posts
spikepl is a jewel in the rough spikepl is a jewel in the rough spikepl is a jewel in the rough
Re: Using a listbox to delete a record

http://allenbrowne.com/ser-36.html
spikepl is offline   Reply With Quote
The Following User Says Thank You to spikepl For This Useful Post:
newcomer (01-09-2013)
Old 01-09-2013, 02:41 PM   #18
newcomer
Newly Registered User
 
Join Date: Jan 2013
Posts: 9
Thanks: 2
Thanked 0 Times in 0 Posts
newcomer is on a distinguished road
Re: Using a listbox to delete a record

Yeah, that's what I was suspecting when I changed the criteria field - a date formatting issue. VBA always expects dates to be in american format.

Anyway, with this new criteria field (a text type one), everything works fine, once this field also has unique records. From now on, I'll have to use:

DELETE * FROM <table_name> WHERE <field_name> = #" & Format(Regional_format_Date, "mm\/dd\/yyyy") & "#

Thank you both of you, pr2-eugin and spikepl. Your help was more than precious.


newcomer is offline   Reply With Quote
Reply

Tags
access , button , delete , forms , listbox

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Locking/Unlocking records, oncurrent, getting value from previous record? spieh Forms 4 10-15-2008 12:28 PM
From Subform: Delete record after Requery and Save Mmattson Modules & VBA 4 10-09-2008 11:21 AM
[SOLVED] Deleting record using Main/Subform while maintaining record position driftin Forms 6 11-23-2006 02:17 AM
Delete record deletes other records DazJWood Forms 2 05-12-2006 12:15 PM
Dispose a unique field in more than 1 column for each page (in a report) brunces General 4 09-28-2004 08:21 AM




All times are GMT -8. The time now is 06:11 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World