Search results

  1. W

    Add query criterial using VB

    Hi! i have a query name "Query01". I want to add a criteria ">=#1/5/2015#" in the field of "PaymentDate" using VBA. Anyone can help me?
  2. W

    format text

    hi!, I want to format the text using format function. how i format the word apple to "apple" (With Quatation mark). str = Format(Me.word, xxxx) TQ
  3. W

    Configure Serial Port

    hello, 1)How to used VBA access code to configure the serial port? i want to set com3 2400,n,8,1 2)how to send the msg to pole display.:banghead::banghead::banghead: TQ I try to using this code, register mscomm32.ocx and enable "microsoft comm control 6.0 (SP6)" but still error. "Run time...
  4. W

    Export the link table to another database

    Hi ! I want to export my data in "Asset_Table" link table to another file store in "d:\Database1.accdb" with table name "AssetList". The Code i used as below. But when i opening the "Database1" file, the Table "Assetlist" is a LINK table type (I want Local Table). Anyone got ideal how to export...
  5. W

    Question Export the link table to another database

    Hi ! I want to export my data in "Asset_Table" link table to another file store in "d:\Database1.accdb" with table name "AssetList". The Code i used as below. But when i opening the "Database1" file, the Table "Assetlist" is a LINK table type (I want Local Table). Anyone got ideal how to export...
  6. W

    Question Printer Papar size

    Hello, i want to set my paper size to user defined, but it not working, <<<<<<<<<<<<<<<<<<<<<<<<<< Set Application.Printer = Application.Printers("P1121E") Application.Printer.PaperSize = acPRPSUser Application.Printer.ItemSizeHeight = 9.35 Application.Printer.ItemSizeWidth = 26.9...
  7. W

    Question Auto Generate NO and Reset it Everyday

    Hello, Please help me! :-) I Want to automatic Generate the Numbers (Me.RID) when everytime loading the form. EXAMPLE "14011701", "14011702", "14011703", "14011704".... 140117 mean "yymmdd" and the last 2 digit mean autorun Number. But in the next day 140118 I want the last 2 digit auto...
  8. W

    Question Format(Year(Date)) ...to get two digit of the year

    Hello, Please Help me I Want the last two digit of the year, Example "14" for 2014, "15" for 2015 I had try to using Format(Year(Date)) But still cant get, Format(Year(Date)) show "2014" Format(Year(Date), "yy") show "05" Format(Year(Date), "00") show "2014"...
  9. W

    Update Record

    Hello,:):) I had made a simple access file using update statement but i dont know why can not work, Example of my table Grade Code Country 1 X MAL 2 X UK 3 X US >>>>>>>>>>>>>>>>>>>>>>>>>>>>>> I want to update my table record as...
Top Bottom