Search results

I will have multiple users on this Form and so I need to refresh each instance to a new table dynamically

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...

Go back and read to post from the beginning mate

Hello Kevlray I cannot see the option to choose an RDO connection. I have double checked and i do have the SP option ticked.

Hi I have a stored proc that populates a table and does not require any parameters. How would i get the proc to execute through crystal with a OLE BD connection.? and obviously display the table data in a crystal report.

thanks for getting back mate

I also found out that crystal does not like connecting accross 64bit machines. and only like 32 bit This seems to be the case with me. Thank you for your reply Regards Rob

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.