Recent content by CJBIRKIN

Ignore the above i've found this it is much better! This is the main site link http://vbnet.mvps.org/index.html?code/network/internetgetconnectedstate.htm Scroll down the page a little way and there is a small header on the left marked related for this specific link to how to find and...

Deleted due to terminal C***ness. Chris

Hi, Namliam kindly gave me some code to test for the name of the server that a pc is connected to. Unfortunatley our computers don't need to be connected to the network for us to log in. They still use an NT server login screen with name, password and domain name. They seem to store all...

Hi Namliam, Works like a charm! :D Cheers Chris.

Hi all, Is it possible to test if a computer is connected to a network? To make it clear i will have no prior knowledge of what is on the network. The only fact is that it will be running a windows server application. Any help greatfully recieved. Cheers Chris

Hi Tim, That sounds like a good idea. Here is the code that will do it. http://www.applecore99.com/api/api007.asp Option Compare Database Option Explicit Private Declare Function apiGetVolumeInformation Lib "kernel32" Alias "GetVolumeInformationA" _ (ByVal lpRootPathName As String...

Thanks Mile, I'll try the winsock ax first. Cheers Chris

Hi all, Tried a search but can't use IP as it's to short so here goes. Is there a way of getting the IP address/some other unique identifier of a computer through VBA? Cheers Chris

Hi Parker, The name of the game here is Mobile Db. I've designed my system so that a user (Nurse) can collect data whilst visiting a patient, later they will sync the database with one on a server. There could be many mobile db's. The idea is that they will synchronise the db's in the evening...

Yikes! I knew things were complex with networking but this... Anyway, i've decided to do it by the tradtional route now! i.e. Laptop connects to network and pulls information from server. The problem is that the laptop DB (mobile db) won't know where on the network the server db is. The...

Hi Parker, any idea how to do this? :D Chris

Hi Is it possible to connect to a computer on a network that is not a server i.e. I wish to "push" data onto a laptop from a database on a server. I know this is not the usual way round but it is for security reasons. Cheers Chris :confused:

Hi, Shot in the dark here but is this correct i.e exactly what you have written; Application.FollowHyperlink "Mailto:" & [ControlName] i would suggest that [ControlName] is the name of the control i.e Me.TXT_EMAIL_ADDRESS. for a text box on the current form (you can use Me.) called...

Hi, For my latest DB i am developing an easy to use synchronisation routine. Part of the system updates FK fields. Currently i'm using a SQL Update query. Ideally i would like to simplfy this in the following way. 1. Pass Table name and Primary key field name to function. (Can do that.) 2...

Hi Pat, Thanks for the advice, Basically i am creating a synchronisation tool for a database that i am working on. The inbuilt synchronisation wizard was just to complicated for the users to figure out the conflicts that were occuring. Consequently i have 2 databases containing the same...