Search results

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?

thanks all. it work TQVM

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

i found the way already and share to you all. Dim mscomm1 As New MSComm Dim msg As String msg = Me.txt1 ' input txt mscomm1.CommPort = 3 ' set port no mscomm1.Settings = "2400,n,8,1" ' set parameter mscomm1.PortOpen = True 'set port open mscomm1.Output = Chr(27) & Chr(81) & Chr(65) &...

i want to send this command([1BH][73H][31H]) to pole display. Below is my example , but difference thing are show in pole display. Anyone know how to correct it? Dim mscomm1 As New MSComm Dim msg as String msg="[1BH][73H][31H]" mscomm1.CommPort = 1 mscomm1.Settings = "2400,N,8,1"...

I found the answer.. share for all. 1)Download mscomm32.ocx and register it, 2)in regedit add the license key, [HKEY_CLASSES_ROOT\Licenses\4250E830-6AC2-11cf-8ADB-00AA00C00905] @="kjljvjjjoquqmjjjvpqqkqmqykypoqjquoun" 3) enable "microsoft comm control 6.0 (SP6)" 4)write this code Dim mscomm1...

TQ! but the link is difficult to understand for me...;)

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...

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...

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...

I found the best way to custom the printer papar size; Example my custom size is 200mm x 110mm 1) Go to Control Panel>Administrator Tools>Print Managment>Print Server>Form. In action select manage forms and create a new form saiz, In form decription set the form to 200mm and 110mmm. finaly...

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...

Thank for nanscombe! you solved my prolem

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...

WORK...TQ... i'm Thinking 1 day

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"...

i want to made a own Point OF Sales (POS) system using access

THANKS. it work:):)

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...