Recent content by damo

The other way about Skip, Access 2000 to read from 2.0, but via code, cannot go in and manually link tables. Im just about to try using the SQL 'IN' clause, see if that works...

That WOULD be okay, but it's a runtime app, the user doesn't have Access 2000 to allow me to go in and link to the tables, so it's got to be connected within the system... cheers for the app you sent by the way.

And me please! A2K. Ta.

Can anyone help here? Im looking for some code to connect an Access 2000 app to tables in a version 2 app to retrieve some similar fields. Ive declared a DAO connection and recordset, but Im not sure whether to set the record set to a new DAO or ADO. Ta in advance.

If you're using Access 97 or 2000, there is a tabs control in the toolbox which you could drag onto your form, add the required number of tabs (pages) the cut and paste your existing fields and controls onto the pages.

Can anyone give me a bit of code I can put in the on-click of a button to open a networked Access 2 application from an Access 2000 one? Thanks. Damo

Hi, Im just looking for a bit of code to open a Word97 document from Access 2. Thanks.

I got it a couple of hours ago, but thanks anyway. I did it like this (for Access 2): Function MySave () Dim mYdB As Database Dim MySet As Recordset Dim MyNumber As Double Set mYdB = CurrentDB() Set MySet = mYdB.OpenRecordset("tblFileName", DB_OPEN_dynaset) MySet.lockedits = False DoCmd...

Thanks for the reply, They open it from an option on a menu bar, it opens in Print Preview, with another active menu bar from whichg they can then print. Im not bothered what format It gets daved as, I was thinking either .TXT or RTF. Damo.

Hi there, Ive a client who wants to save reports to a file on their network on the print command. The reports are standard letters done using Access reports rather than Mail Merge. Can anyone advise me of the best way to code this? Ta.

Ive a problem picking dates up from a form directly into an SQL string (a report is based on this string). It's a between 2 dates report, and for some reason both dates are giving errors if the date is > 27/09/2000. Ive used this type of this type of thing before in building SQL strings but have...

Could someone remind me how to add more than one line to a message box please? Ta.

mail this guy: rdhicks@mindspring.com he gave me the solution to the exact same problem yesterday, I just dont have a saved copy to send.

I have a networked system, and all the users have different screen resolutions. They also insisted on maximised forms, which obviously look different on each screen. Does anyone have a bit of code which can set them all to 800x600? (if possible) [This message has been edited by damo (edited...

Any idea how to change the icon on the top left of forms within Access 2 to whatever I want? Ta.