Search results

I'm trying to set up an Access Projects database against an existing MS SQL 7.0 Database in France. I have the logon, password and IP address of the database but I can't seem to get a connection. Is this enough information to set up the connection or do I need more. Thanks in advance.

Does anyone know if the "Fit To Page" option used in printing Excel documents can be invoked when printing Access reports, or is there another way ?

Raskew - good info. I understand better now. Jon K - the CDate function would solve my problem but it can't be used in a query, it's a VB function which will take ME more time to implement. Is there an equivilent function that can be used in a Query ?

I'm trying to compare two Date/Time fields which are both long dates. Each field in a different table. The comparison takes the time into concideration and makes the query run time unnacceptable; the tables are large. I've tried using the Format() function to translate the Date/Time to a text...

Yes, I mean "link tables". In my case I know the tables that have to be linked but I want to re-link them automatically every time the application is started. I only know the manual way of linking which is File, Get External Data, Link tables, Pick database and the files will be shown for...

I have an application that has a number of tables attached from a remote database. Periodically the attachement is lost and the application fails. I would like to drop & attach the tables every time the application is started. Does anyone know what functions or code that can do this ?

Thanks, I can do that, couldn't see the wood for trees.

I'm checking the input to a ComboBox within a form for validity and if not valid I want to clear the box and flash up a message. What code do I use to clear the input box ?

Thanks rich - According to the Properties for the Combo, all the parameters are set. Or am I missing the point ?

I've set up a Crosstab query with one Row one Heading and One Value field. I've added another field against which I want to add a criteria that looks at the value in a Combo box on a form, which is active. As suggested in Help for this field I have the Total section set to "Where" and nothing...

I've used the DoCmd.TransferSpreadsheet function in VB to create the Excel document in the correct column order based on the Query. Thanks for your help.

I'm saving the output of a Report to Excel but the order of the columns bears no relation to the report or the query behind the report. How do I set the order of the columns ?

Help ! Can anyone tell me how to get the multiple items selected from a list box, which has Multiselect set to Extended, into a query which is used by a report.

Chris - thanks, I couldn't see it !

I'm getting the following error "The object doesn't contain the Automation object 'strLoggedOn'" when running the VB line "DoCmd.RunSQL "INSERT INTO Time_Log (Name) VALUES (strLoggedOn)"". Does anyone know what the problem is ?