Search results

Tim, Thanks for your advice.

Is it pretty stable though? The kind of sizes I sometimes deal with could mean this running for a few hours. I don't want it to crash 50k from the finish line!

OK thanks, PC Anywhere looks like a good investment then, but probably not until I get broadband! What size is the backend software (will it email)? I suppose the only real solution for big files is burning a CD then. One last thing, what about using MSN Messenger (or similar) for transferring...

I was thinking of maybe trying PC Anywhere, does anyone else use this? What's it like over a dialup connection?

I'm talking about .mdb and .mde. Generally how you deal with transferring database files (the whole thing) to and from clients.

Can you people please tell me how you send and receive databases to and from clients? I have been working with a mixture of email (which is ok for small stuff) and CDs for the big stuff (though this is a pain as the royal mail are awful). Just wondered whether there is a better way?

Oh yeah, missed that, thanks.

Followed the link but could only find one tool for A97, I need it for Access 2000. Do you know of anywhere else I might this info?

Great stuff, thanks for your help.

Don't want to edit just download. Could you explain how that works please?

Nevermind, I just found this on the MSDN Access Developer Centre: "Microsoft Access 2000 does not support importing or linking data from a remote FTP or HTTP server. "

Anyone?

Thanks a lot.

Can anyone tell me how to connect to a text file database on the web, from a local Access database and copy records into a table?

So all I have to do is encase each msgbox with eval() and it will work?

I've just converted a number of databases to XP. No real problems except that annoyingly where I have used '@' to bold the first line of message box strings in A97, this does not appear to be supported in XP. Is this correct (i.e. it is not supported)? If so, does anyone know of an XP...

Just me then? It only seems to happen Using -> DoCmd.OpenReport rptName, acViewNormal The printer settings are all fine and the report will print perfectly from print preview, but not directly using the above command. Looks like a bug to me! Any advice would be appreciated.

In the SQL that drives your report you just need to reference the combo (or whatever other control) that you used to select the contact. Place this reference under in the criteria section of the contact field.

What version of Access are you using? Is conditional formatting not an option?

OK, so you search for a company, (this updates your form with a company record) and you then want to select a contact's details? If you want to populate a combo with all of the contacts for a company when your form updates, you just need to change the combo's Row Source property. You can do...