Search results

Hello there. I want to open a form and change the Record Source via a dynamic variable. Dim Table as String Table = "Statistics"+replace(Environ("Username"),".","") DoCmd.OpenForm "FrmStats", acNormal, , , , acHidden Form!FrmStats.RecordSource = Table DoCmd.Close acForm...

Hello there I have created a database connection using a dns file. When i choose a table and stored proc. I am asked to enter parameters, then i get the following message. "database connection error : 'cannot obtain message from server". I am using a logon within the odbc connection...

Hello i am trying to connect to another sql server via crystal reports XI which sits on another box on my domain. Im not sure what to put in the connection string. Could someone give me an example please.