Recent content by Pilly170

Hi, I have 2 Eva 4100, in 2 locations, connected on a IP network and over an 100mb fibre connection,the connection is only using a max of 6mb/s. Im getting this error Problem Found: CUST: CA warning: BZ-EVA-01: Excessive data exchange retry rate on the inter site link Any ideas on this...

Forget that.... error was the export spec not recognising the BRanch .. THanks for your help

I tried but still the same error... Unknown field Branch

Hi, I have a sql table with the following fields. ProdNo , Manufacturer , Manufacturer_ProdNo, System_Text1 , Category , Stock , Price and an access table Custno, ProdNo, Price , Branch My function is this, it imports the SQL table into the access table. Function Update_XML_Tables(Custno...

Think i have it working after the previous help Function Update_XML_Tables(Custno As String, Table As String) Dim XMLupdate As String XMLupdate = "INSERT INTO XML_Upload_Pricelist ([CustNo], [ProdNo], [Price]) " & _ "Select '" & Custno & "' As CustNo, Actebis_ProdNo, Price " & _ "From " &...

Thats right. then when i move onto the next table, it will do the same. There for i will have 1 table with all the information I need, customer, product, price. for example the table inserting to will contain: Custno Product price 10076 12235 2.99 10076 15547 8.99 10076...

This is what i have at the moment as a test Function Update_XML_Tables(Custno As String, Table As String) Dim XMLupdate As String XMLupdate = "INSERT INTO XML_Upload_Pricelist ([CustNo], [ProdNo], [Price])Values ('" & Custno & "','Green',2.99)" DoCmd.SetWarnings warningsoff...

I was going to specify it when calling it eg a macro Runcode FindPrice_Customer ("14427") Where 14427 is variable for the customer I can create the table with the required schema, but i need to add the customer number into every record. so for example the fields are custno,prodno, price...

No, its free download... just google it. The code was to put in access. I use a form opening to call it.

Hi, Can anyone point me in the right direction. I want to write a function that imports 2 fields from a linked SQL table. fields =(ProductNumber, Price) and import it to a access table but insert a field "customer number" which is defined in the Function header eg Function xyz (custno as...

I used the ClickYes program, ran it in suspended mode. then when required used the code below on a forms events, which in turn unsuspended it allowing me to send. Option Compare Database Private Declare Function RegisterWindowMessage _ Lib "user32" Alias "RegisterWindowMessageA" _ (ByVal...

The contents. the table name is dealer_(variablename)

Hi, Im trying to make some VBA Sql queries, this below one works ok. Function Delete_Table_Mysql_XYZ() Dim DelMysql As String DelMysql = "DELETE mysql_dealer_10076.*, * from mysql_dealer_10076;" DoCmd.SetWarnings warningsoff DoCmd.RunSQL DelMysql DoCmd.SetWarnings warningson End...

so if i had for example - my server is 192.168.200.6, login is phil password is test. Database is Misdata. So how would my query fit with the code you've given me? and also how do i run it??? Ive seen so many examples but cannot get my head around it.

I knew it was simple. i been having a mare today. thanks.