Search results

Hi guys I want a form "date" field set as "dd-mm-yy" format whenever a user arrive at field irrespective of what "region" setting his pc is In the "Format" of the form text box, if i choose "short date" it will use the pc short date format which may be eg dd/mm/yyyy. How to fix this...

Sorry guys for delay looking for clues. I double check all fonts in report is Arial. When i print to pdf it is Arial, only the report preview for one particular report is not arial. Anymore ideas, interesting never meet this before win10 v1709 & back

Is the setup options in optiona for forma & reports

Hi guys I have many reports created msaccess02 with default font as Arial but after win 10 update to 1803, Arial change to an Asian font SimSum, what do you think is happening?

It was a stand alone pc no networking moke, no issue on another similar pc no network win 10 Sent from my MI 4LTE using Tapatalk

Guys sorry to report using Folder.exist still slow on on particular win8.1 laptop. It might be just a bug in the OS due to whatever reason. Ping does work at all.

Mark Thanks for the pinging advice & arnelgp Thanks too, i will the folderexists instead of getfolder & see how the speed pans out.

Hi gurus I want to check if an UNC exist using Scripting.FileSystemObject .GetFolder("\\MYUNCPATH\MYFLD") If it does not exist it will flag error 76. In some pc, the response is fast but in some it may take up to 2 minutes before err is flagged. Is there another faster way yet easy. Hopefully.

Thanks guys for your insight & clarification on who's innerds. Cheerio!

Thank you Colin for interesting and informative exchanges with Doc & static, lots to chew, goood!. Just read moke your second link. I finally understand, in a 64 bit environment, the windows bowels (quote from Colin) is at the Wow8432Node, that is if i want play with registry. Perhaps if i...

Thank you moke for showing another way. The link is very useful.

Hi guys My Jet database used to have Max Lock file issue when the database grows. If so i change the registry as follows as example [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0] "MaxLocksPerFile"=dword:0001d4c0 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access...

Friend you are right about internal command. The chdir does not work on UNC, true?

Thats quick friend, will tinker with it. Thanks But do you know why we can't pushd in VBA.

Hi buddies i was trying to run Shell("pushd \\sharedfolder-in-network") but it fail to push even if i wait. Net Use Z: \\sharefolder also won't work. How can i can change an UNC to a drive in VBA so that i can do some file system action with shell eg with unzip.exe Appreciate some lights!

So I would imagine since no update of data, is it correct? Sent from my HTC_PN071 using Tapatalk

Hi gurus I use the following coding to BeginTrans > CommitTrans > RollBack to print a report from Tabloid from data in the BackEnd to a LAN printer. Due to my limited knowledge I would like to know the interaction between the Tabloid and the LAN printer Is there any point to use this cycle...

Yes friend for the caring in your advice 🙌 Sent from my HTC_PN071 using Tapatalk

Always appreciate all your feedback, 💜 Sent from my HTC_PN071 using Tapatalk

Hi guys I know many of you have warned me not to use Wireless connection to do Access but I have no choice and is prepared to live with the limitations of Begin/Comit. I have reduced the error on corruption of data in the shared main data. My problem now remaining is to send data to the LAN...