Search results for query: *

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

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

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

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

Hi, I have some code that retrieves the date/timestamp of a file and saves it into the variable showfileinfo, any ideas how can i get this formatted into a date/time field.? Function IsFileModifed(filespec) ' This Checks The file as specified in Filespec and checks the modified time then...

Hi, I am using MS access as a front end, and have a query thats meant to delete the MySql table contents. Sometimes it works sometimes it doesnt. when it doesnt it gives me ODBC 3146 runtime error. Any ideas on what could be wrong?? Is it a setting within the ODBC client setup or some sort of...

Hi, I have a query within vba, it querys my SQL server. Now the query works fine, but is there a way to stop the login box appearing, by setting the connection settings/logins/passwords within vba? I normally use php, so this is all new to me. any help or pointers would be great. Function...

hi, I have year/month data held within a sql server, its held like YYMM, What im trying to do is to run a macro that runs this query that will automatically detect the current year and month eg 0409 for this month. Im pretty sure it would be Date() command but not sure of the syntax, can anyone...

Hi, I have a table, one field has data inserted with a prefix eg K 10292. Is there an easy way to remove the "k" via VBA?? or am i looking to do an update query? I did a search on the forums but couldnt find the answer, i can do it within excel but need to complete within access, any ideas?.

Hi, I have this code that gets the files last modified date, all i want it to do is instert this into a field in a table. I think the error is quite straight forward but cant see where ive gone wrong, just need antoher set of eyes i think. I wanted to use update but i got a bit confused. any...

Hi, I have a question, which im not sure is possible, heres the situation. I have imported a text file into a DB no problems, what i want to do is every 15 mins check the text file to see if its been updated. If it has been then run the import script again. Any one have any ideas on how this...

Hi, Im trying to import a text file automatically into access, but I want to strip the top 3 lines of the text file. eg. Heres the original text. 5 lines only. <Start of File> 13;Company Name SOD ;Address 1 CAR041 BacklogOfOrders DATE: 01.10.2003 Branch DocumentCode DocumentNo...