Recent content by Loek

The printer is connected by USB and is local without an internet connection. all code is in a form with one commond button to print text line by line

Hi, everybody I have a problem with an epson lx300 + dot matrix printer. The vba vbCrLf code doesn't work when I print text line by line. Have you ever experienced the same thing? I use this code : strLine as string Dim lReturn As Long, lpcWritten As Long, sWrittenData As String strLine...

Dear all, I was created a form with two tables and I want get a serial number for each my collections. Table1 say as My Category Table2 say as My Collection In the table1 I have : Id | Category ----------------- 01 | Computer 02 | Religious And in the table 2...

how do you give your DB to user..? you can make a form (switchboard) and set it to startup in your db

I am sorry. I wasn't careful with your help ( space in ""). Thank you very much. it is very helpful

I had try your help, but not worked. I still got like this : 2,000.00 300.00

I sorry before. My English not fluently. Let it converting to currency with decimal place. And I get like this : order_id : 1 ---------------- product|price A......... 2,000.00 B......... 300.00 I want get like this : order_id : 1 ---------------- product|price...

I sorry before. My English not fluently. Let it converting to currency with decimal place. And I get like this : order_id : 1 ---------------- product|price A......... 2,000.00 B......... 300.00 I want get like this : order_id : 1 ---------------- product|price...

Yes, I am. if I remove the ccur function, I will get like this : order_id : 1 --------------- product|price A..........2000 B..........300 if print it by report, nothing problem with converting it to currency (not decimal). But, I was print it line by line using data from form (main form and...

Hi..everybody... with the code above I got print line by line like this (for example) : order_id : 1 ---------------- product|price A......... 2,000.00 B......... 300.00 I want get : order_id : 1 ---------------- product|price A......... 2,000 B...

thank you... I was fix up my code and working properly. Private Sub cmdPrint_Click() Dim strLine1 As String, strLine2 As String Dim rst As DAO.Recordset Dim lReturn As Long, lpcWritten As Long, sWrittenData As String strLine1 = me![order_id] set rst =...

Thank you Banana for your response I was add space, but the same error. I get Run-time error 3131 "Syntax error in FORM clause"

I am new in access and I am sorry before. My English not good. I have main form (f_order) with a subform (f_order_detil) and was linked with order_id. I want print line by line like receipt in the mini market or etc. But, my problem is I can't read the data (field) in a subform using VBA...