Solution of ISSUE "Master Catalogue data cannot run for MQUAD"
Displaying 1-3 of 3 result(s).
avatar
Posts: 4294967279
Joined: 1/1/70
Solution of ISSUE "Master Catalogue data cannot run for MQUAD"
» MRC Admin » February 2, 2015 2:31:01 PM +07 » 0

One of the problem occur from MQURD need format of Date (dd/MMM/yyyy) different from format of Date in Master Catalogue (dd/MMM/yyyy: hh/mm/ss). Therefore we should adjust format of date from All Series of data into MQURD, We can do in one time by editing in following folder “D:\MRCSKB_042012\TSData” 

1.Open file “Master_CataloguePrecipitation.mdb” from folder  “D:\MRCSKB_042012\TSData”

2.Select  “Create”  then “Query Design”

3.Close Pop Up Window

4. Select “SQL View” 

5. Typing this formula    update tblMaster_CataloguePrecipitation set [Date] = Format([Date], 'dd/MMM/yyyy')

6. Click Run  “!”

Please note this will update everything in the table and it’s not rolled back at all !!

avatar
Posts: 5
Joined: 1/1/70
Solution of ISSUE "Master Catalogue data cannot run for MQUAD"
» My Emilly » November 20, 2018 3:55:09 PM +07 » 0

I like your blog post. Keep on writing this type of great stuff. I'll make sure to follow up on your blog in the future.

https://color-switch2.com

avatar
Posts: 1
Joined: 1/1/70
Solution of ISSUE "Master Catalogue data cannot run for MQUAD"
» Angela Kinsey » December 15, 2018 1:39:19 PM +07 » 0

Hello, My boss asked me to look into a different access solution to control PLC's. I prepared some ... 2 ·  Make My Essay  Rockwell IO-Link: following the master... I Fancy practicing a cellular solution to avoid any company network problems. ... Phoenix Contact offers mGuard Secure Cloud as a free service. The site ...

8 guest(s) and 0 active member(s)

In the past 15 minutes
0 anonymous member(s)

locked topic Locked topic
sticky topic Sticky topic
global topic Global topic

Board Statistics

Total Post: 565
Total Responses: 555
Total members: 1781
Visitors today: 230

Concact Us

Contact Form


© 2014 Mekong River Commission