Search results

Have you tried using the ip address rather than hostname. I had the same error but not when using the ipaddress of the server

My system needs to connect to another database (MySQL) to periodically pull some data across and update some tables in my Db. I'm looking for some advice as to the best method to accomplish it programatically. Thanks.

To ping mulptiple machines you would have to write some loop into it. I'm thinking you could read ip addresses from a query maybe and then loop the code?

Here's a copy of the code I used which is contained in the onclick event of a button. Private Sub cmdTestIP_Click() 'On Error GoTo err_handler Dim strComputer As String strComputer = Me.txtLocalIPtest If Not SystemOnline(strComputer) Then 'Display A Message MsgBox "Local IP...

I think my error may be down to the point at which the code executes?

My Db is split and uses the user level security with the built in Admin account disabled. -Split Db Front end / Back End -Back End Db is encoded -Access user/group level security being used I am just trying to get functions to work but they require an external link via a system or file DSN...

Both of those cause the Db to close. I dont think the <> is the right thing for NOT is it?

Have tested with the correct computer names but the database still quits? If sHostName <> "ComputerName" or sHostName <> "AnotherName" Then DoCmd.Quit

Am I correct in the <> is the syntax for "if it's not this" Thnks for the replies, will test and post back

Hi all, I'm using this bit of code on my splash form to ensure that the Db can only be used on computers which I have authorised it for. 'Checks the computer being used is authorised to be able to use this database Dim sHostName As String sHostName = Environ$("computername") If...

Hi, i could do with a bit of help with the following: I have attached the database so that you can see what I am doing. In my main table I have a couple of fields which rely on being able to compute the values of another table linked by quoteID but am coming up against mental brick wall. any...

Hey! Managed to do something resembling what I need. Loads more to know but your help enabled a real LEAP forward. Many thanks for offering a pointer to the solution as asked for. REAL HELP. Thanks.

no, thanks for the tip. i will investigate bindings and soforth.

Have searched for answer but cant see. I have a form with three dropdown's, each assigned to their own query. On the form I have a 'Close & update' button. I want to create some code which, on button press, will take my selection and pace data into another table with corresponding field names...

Reply Thanks for the info. I seem tobe working form the opposite end, I know what I want and working on develpoping the knowledge as i go along. thankx though.

New to Access! I am creating a quotation database where a new company name will be entered. In 1 form a pick list of products which I then want to go into another table associated to the company name which can then be queried and displayed in a report for printing the quotation. I have created...