Search results

that sucks Columns represent names, rows are dates, it's an attendance database.

Here is my problem. I have a table with a lot of columns. I want the user to be able to select which column he wants to display in a query/report, how do I do that? Is there some kind of way to do a command SELECT [table].[like [user input]] either in SQL or Query Design, so that a form would...

my bad, actually its not an input query, forget about that. its a simple query that shows one row of a big table, and I want to just show it, so that users don't have access to change it, and I wanna do it in a nice format

How would I create a report from the query? This is the input query, that allows users to create new records, but not edit or delete. It's based on a table, which I change sometimes. So I don't want to create a report and put a bunch of fields/columns in there, and then when I add or delete...

It would be the same thing as saying acReadOnly, like I said the problem is that I have a lot of columns in this query and just one row, so the row displays going from left to right on multiple pages, which is not the best way to view it

because I don't want users to be able to change any values, I just want to show them what's in the query, it's a security issue

I need to display the results of a query on screen when somebody clicks a button on the form. So I put code in the event of the click that looks like this: Private Sub Command20_Click() On Error GoTo Err_Command20_Click Dim stDocName As String stDocName = "HHC Report"...