Search results

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...

Hi, Did this in the end DoCmd.TransferDatabase acLink, "Microsoft Access", "C:\chris's stuff\OUTREACH\SERVER\MOD-1.00-HUB.mdb", acTable, "TBL_PATIENT", "TBL_PATIENT_HUB", False Then dropped it when i'd run my sql. Chris

Hi, Can someone tell me if this is possible. I want to use a table in an unlinked database in an sql. It is possible i could link the table to the database but i would rather not. I've tried the following but i get an error saying TblHub is not recognised. Am i mistaken in thinking that the...

Hi, DCX & Bretto; I've found away of doing RSA encryption using VBA, the only problem is the limit to the 2 primary numbers used to create the Public and Private key pairs. Bretto, thanks v much for the site i'm going to have a play with it. I'll post back if i can get this to work, should...

Hi, I've written an encryption algorithm that requries the multiplication of 2 large (32+ character) integers. say IntA and IntB My problem is i need to retain the indivdual characters that are created by the muliplication of IntA and IntB, the programme uses the 1.0^X notation as soon as i...

Have a good Christmas Chris It is Christmas Eve and this chap is on a rooftop about to jump off. His wife is leaving him for another man, he has lost his job and he owes thousands of pounds to the bank. Just as he finishes his prayers and closes his eyes, ready to jump, Father...