Search results for query: *

I'm using the DSN-less method in my forms but how to do it in a report? To connect of the forms I use - Driver{SQLServer};Server=sqlserver;Database=projects;Uid=;Pwd= Is there a way to set this up to work on a report? If there is, I could have the query connect and have the report on based...

I'm trying to avoid having to set up a DSN for each person using the front end. It was working great until I tried to create reports. Is there a was to create a access query that uses ADO and isnt dependent on linked tables?

I'm able to connect and query the db just fine. The problem is getting the textboxes on the report to have values based on the query. Seems like it is impossible to assign the text boxes values manually or to base the report on a query using a dsn-less ado connection.

This should be easy. I should be able to assign the text boxes on the report values based on the query. I cant figure out how to assign the control source or value of the textbox manually?

I created an access front-end to a sql server database and I'm stuck trying to generate a report via a event procedure. I purposely am not using linked tables and instead connect to the DB using a ADO connection string. I cant figure out how to base a report on a query where the tables are...