Search results

I've just googled "SSH Tunneling map network drive" and come up with the following, perhaps this will help: http://www.damtp.cam.ac.uk/user/jp107/xp-remote/ssh-map/

Hmmm. I've not used SSH connections before but they obviously behave differently than I guessed they would. Have you got shared folders on the remote machine? How do you normally access the files remotely?

Re: I Wanna learn Microsoft access from scrach.... Welcome to the forum! I would begin by thinking about what your need is to create a database. Then google relational database design and read up on how a database should be structured - to start with, you should have a table for each 'topic'...

Not sure there is a limit, except for the 2 gig file size and the 32768 object limit (if import specs are treated as objects, that is) You could always try creating 32768 import specs :)

Welcome to the forum! I bet we're mostly self taught on here, as long as you don't get stuck in a rut and are always looking for ways to build on your skills it's the best way, I reckon!

Depends where you're displaying the results really - could you just use a calculated control? If you're displaying total spent and remaining balance in two separate controls in the same place, could you not just do control1.value - control2.value as the control source for a third?

Hi, welcome to the forum! It sounds like the form is just looking at the records that already exist in the table. The only way to stop that from happening would be, as you've said, to navigate to a new record, where all the fields would be null....

You might be able to use the DLookup function for this

The only thing I can think of is to change the cycle property of the form to current page, but I've never tried this before...

Could you just put the code in the option group's on click?

Can you see it in the network broswer in windows?

You've just got your query joins to the risk description table round the wrong way, that's all. Show all records from that table.

Well spotted....!

OK - so I guess it's something PC-specific then. What's the exact error massage and error number?

Morning! Looking at your database, I can't see what you're trying to achieve. What is it you want to see exactly? What you need is a table that will contain data that the users enter, rather than basing it on a query, as you have at the moment. So - 1. Create a table that contains fields for...

Bugger. I was pleased with that routine too!

OK. So you want to filter the subform (that's the one in continuous view) based on the values selected in the combo box? Here's how you do it. In the on lcick event of your search button, you need the followingsubformname.form.filter="[Province]='" & me.cboProvince &' AND [District]='" &...

I don't use macros in Access, but I believe it is a macro action as well as a VBA one. The Timer event is located in the properties of a form in Access.

Can you be a bit more descriptive? You didn't mention a filter button to start with. How is your form set up? You could attach a picture....

Yep - so depending on the programID, you'd have a number of different forms being opened? I would store the programIDs and form names in a table. Then, in the event you're going to use to open the forms, have a query like "SELECT ProgramID, Formname from ProgramsAndForms WHERE [ProgramID]=" &...