Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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
  #11 (permalink)  
Old September 14th, 2007, 10:25 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Ah see, I didn't dismiss anyone's efforts. I was only trying to contribute. I frequently learn many things about Access from other posters contributing, and if you will look at my posts, you will see they are always deferential and I always thank people for what I learn, and ask others to chime in to help out with a more elegant solution than the ones I post.

It was in fact you who dismissed my best practices suggestion as too cumbersome for subsequent editing, when you state yourself the poster was looking for "a quick easy way to build an insert". So that would be an INSERT statement and not a SELECT statement, I suggested. In point of fact, you can do it either way, but the SELECT statement adds a lot of application overhead in an enterprise environment. I was just offering a suggestion so the poster would have as much information as possible. And the poster chose your suggestion as best suiting his needs anyway.

Anyway, I was slammed down by you for it, not the other way around. I have been having a chuckle at your assertion that Top Access Experts roll out the entire recordset when they could do an Insert statement instead.

That being said, I continue to learn form your posts, and everyone's posts here, regardless of the level of experience. That is the idea.

I won't apologize to the other posters since I think they get a chuckle out of the "spat", but I apologize to you if you think I have been out of line. I only meant to contribute.

mmcdonal
  #12 (permalink)  
Old September 14th, 2007, 11:21 AM
Registered User
 
Join Date: Oct 2006
Location: Leigh, Lancashire, United Kingdom.
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Mmcdonell

Apology accepted and retunrned. It would be nice to think that the forum are having a chuckle. Lets move on and continue to help where possible. I am sure that I will learn far more from you and all the other TOP ACCESS DEVELOPERS than you will from me.

Heres to moving forward.
  #13 (permalink)  
Old September 14th, 2007, 11:58 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I hope my post on the issue, respectfully submitted, has shown my point of view. For 99% of the work we do here, it is a non-issue, so to each his own. Silly of us to have gotten out of joint on the issue. But I think it indicates a healthy appreciation of the niceties of developing and coding.

mmcdonal
  #14 (permalink)  
Old September 14th, 2007, 11:59 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

We seem to have forgotten about Brendan's issue. Is it resolved?


mmcdonal
  #15 (permalink)  
Old September 17th, 2007, 09:49 AM
Friend of Wrox
Points: 912, Level: 11
Points: 912, Level: 11 Points: 912, Level: 11 Points: 912, Level: 11
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2005
Location: Dublin, , Ireland.
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your replies I need also to add to Listid and listitem time into the listbox. I am having a problem adding the time to the sql statement.
Thanks

Brendan Bartley
  #16 (permalink)  
Old September 18th, 2007, 06:42 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

If you use the wizard to create the list box, then you can add the time column as part of the initial query. Otherwise it is mostly like setting up a combo box. Do you need the INSERT statement? That would be:

Dim dtTime As Date

dtTime = Now() 'I am assuming you wanted date and time.


sSQL = "INSERT INTO ListSource(ListID, ListItem, ListItemTime) " & _
        "VALUES(" & iIndex & ", '" & sString & "', #" & dtTime & #)"

Did that help?


mmcdonal




Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting all listbox items Lucy_H85 C# 2005 2 December 1st, 2009 05:36 AM
unselecting items in a listbox Durkee VB.NET 2002/2003 Basics 9 October 8th, 2007 03:01 PM
UNSelect Items in ListBox mmcdonal Access VBA 7 June 21st, 2007 08:09 AM
Moving Selected Items from a list box to excel AlanAtMars SQL Server 2000 2 August 19th, 2005 02:02 PM
Saving Listbox Items antonducabre VB.NET 2002/2003 Basics 1 July 16th, 2003 12:46 PM





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