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

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.

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

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


mmcdonal

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

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