Search results

  1. J

    How can we disable import of table link by VBA

    I set my table on server and front end with table link on user machine with vba log in code. However someone still can make blank database and import my table from server and table link from front end. I user this code to hide table on server, and it's work (cannot see through Tool>Show...
  2. J

    How to remove double quote from text field for Export to .txt at field length fixed

    I have to upload my Access Data to Oracle Core System. They need .txt with field length fixed for uploding format. I fix length by this function in query: - Trans Amount: Right(String(17," ") & [TETHB],17) - for number Currency: Right(String(3," ") & [THB],3) - for text Once I export with...
Top Bottom