Listbox conaining querylist??

[eliotchs]

Hi,

I'm looking to create a form which has a listbox of all the queries in the DB. I
then want the user to choose a query from the listbox, and the query will update
a field with the current date

Any ideas where to start?

Thanks


Joe

I think I got the SQL for the update part,
I need the part to choose the query from a listbox..
Thanks
Joe

[ajetrumpet]

alrighty Joe,

look in your MSYSobjects table, which is a system table. Look under the NAME field to find one of your query names and use the TYPE field to identify all of them. after that, it's simply an sql statement.

[eliotchs]

Hi Adam,

Thanks, I got that in a listbox..

now how can I setup a command onclick of a button

to runsql that would run it

I got this under onclick..

Dim SQLText As String
SQLText = "UPDATE [" & Me.lis4 & "] SET [" & Me.List4 & "].submitteddate=date()"
DoCmd.RunSQL SQLText



Thanks
Joe

[ajetrumpet]

docmd.openquery me.listboxname

OR

docmd.openquery(me.listboxname)

[eliotchs]

sorry,

I didnt explain it right..

What I wanted was to choose the query from the listbox then update "Datefield" with current date

thanks again..
Joe

[ajetrumpet]

What I wanted was to choose the query from the listbox then update "Datefield" with current date

that doesn't make sense, sir.

update a field with the current date? you don't need a query for that. is that ALL you want to do??

[eliotchs]

yes , but I want a user to choose the query to run the update query..
via a form ..

Is there an easier way?

Thanks

[ajetrumpet]

choosing a query is not really even relevant. why don't you just assign the box a value in code?

me.datefield = date()

but if you want to actually provide the illusion to your users that they need to do something that requires thought to get this done, try something other than a list of query names. That just doesn't make sense. more than likely you'll confuse the heck out of your users if they start thinking they need to be using a query for a sophisticated task when this date assignment is all that's really happening.

that's not really honest anyway. and not very good practice either, IMO.