ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð°Ý¦¹¥\¯à¦³¨ä¥Lªº¤è¦¡¸Ñ¨M¶Ü?

¦^´_ 11# singo1232001


     ­×¥¿¤@°ïbug
¥i¥Hª±ª±
excel ¸òacces ¶·©ñ¦b¦P¸ê®Æ§¨¤U
Åܰʬö¿ýv2.zip (226.46 KB)
1.±Ò°Ê¶×¤Jaccess¬ö¿ý  
2.±Ò°Ê¼ÒÀÀDDE
3.¬d¸ß¸ê®Æ¥i¥H®Ú¾Ú»yªkªí¬d¸ß ¦C¥X¤£¦Pªº¸ê®Æ

TOP

¦^´_ 29# ­ã´£³¡ªL


         ·PÁ«e½ú¦^´_¡A¦ý§Ú¶}³o©«¥D­n¬O·Q¤F¸Ñ¤£°O¿ý­ì©l¸ê®Æ¥h¨D®tªº¤è¦¡¡A¦ý¬Ý«e½úªºµ{¦¡¦n¹³¤]¬O­n±N¸ê®Æ¨Ó·½°O¿ý¤U¨Ó¦A¥h°µ¹Bºâ
¥t¥~¡A§Ú¦³¸ÕµÛ­×§ï§Úªºµ{¦¡¡A¦ý¥X²{°ïÅ|ªÅ¶¡¤£¨¬ªº°T®§¡A¯à½Ð«e½úÀ°¦£¬Ý¬Ý¬O­þ¸Ì¥X°ÝÃD¶Ü? ´ú¸Õ.rar (27.44 KB)

TOP

¥»©«³Ì«á¥Ñ Andy2483 ©ó 2024-1-9 11:12 ½s¿è

¦^´_ 30# ÂŤÑÄR¦À


    ¥i¯à¬O¼Æ¾ÚÅܰʤӧֹBºâ¤£¤Î
¹ê»Ú»Ý¨D¬O´X¬í­n°O¿ý¤@¦¸?
¶¡¹j®É¶¡¨ì¤~¹Bºâ

Option Explicit
Private Sub Worksheet_Calculate()
If Val(Format([A1], "SS")) Mod 3 = 0 Then'¶¡¹j3¬í
   Call RecordPrice
   Call Price
End If
End Sub
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2024-1-9 12:34 ½s¿è

¦^´_ 31# singo1232001


    Åܰʬö¿ýv3.zip (271.37 KB)

¦]¬°excel ·|¥d
©Ò¥H¹ï©ódde §Ú³£¥u¥Îaccess (´Nºâ¥Î¤Warraylist  ¤@¼Ë¥d)
¥ýª±ª±¬Ý³oª©¶W¦nª±

Åã¥Üµ§¼Æ¨ºùØ ¥i¯à­n«ö¨â¦¸

TOP

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2024-1-9 12:39 ½s¿è

¦^´_ 33# Andy2483


    dde §Öªº®É­Ô«Ü§Ö 1¬í3~5¦¸
ºCªº®É­Ô«ÜºC 1¤ÀÄÁ2~3¦¸

¥­§¡ ¤@¤ÀÄÁ20~30¦¸
¤@¤p®É800~1500¦¸
¤@¦­½L¬ù3000~5000¦¸

TOP

¦^´_ 35# singo1232001


    ÁÂÁ«e½ú
¸r¼}«e½ú¥i¥H¦³«Ü¦h³nÅé¥i¥H¾Ç²ß,«á¾Ç¤£À´DDE,¥u¬O¶X¦¹¾÷·|¦h¾Ç²ß
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 33# Andy2483

»Ý­nÀH®É°O¿ý¡A§Ú¥D­n¬O­n¬ö¿ýf14-f18¡Ak14-k18
¦³¨ä¥Lªº¼gªk¥i¥H¦³¦P¼Ëªº®ÄªG¶Ü¡H

TOP

¦^´_ 37# ÂŤÑÄR¦À


    ¦nÃø!²qµÛ§ï§ï¬Ý
´ú¸Õ_20240109.zip (27.46 KB)
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2024-1-9 20:40 ½s¿è

¦^´_ 38# Andy2483

­è­è¸Õ¤F¤@¤U¥i¥H¹B§@¡A¦ý¤£ª¾¹D¬ö¿ýªº¶q·|¤£·|¦³»~®t¡A­n©ú¤Ñ´ú¸Õ¤~ª¾¹D
³o­Óµ{¦¡½X¥D­nªº¥\¥Î¬OÔ£°Ú?¥[¤W¥h´N¯à¹B§@¤F¡A¦n»ÅApplication.EnableEvents = False
Andy¦³ªÅ¯à¸ò§Ú¸ÑÄÀ¤@¤UApplication.EnableEvents = Falseªº¥\¥Î¶Ü?

TOP

¦^´_ 39# ÂŤÑÄR¦À
1.·|¤£·|¦³»~®t¤£ª¾¹D,«á¾Ç¥u¸ÕµÛÅý°õ¦æ¡A¸Ì­±ªºÅÞ¿è­pºâ¨S¬ã¨s
2.¨â­Ó°Æµ{¦¡¹ï½Õ
3.Application.EnableEvents = False ¬O¬°¤F¤£Åý°õ¦æªº¹Lµ{³sÄò¦AIJµo
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD