Recent content by Sokkheng

Thank you for your advice, I will try it.

I have one table for store information of car call (tblCarInfo) with fields: CarId, CarModel, CarPicture (Data type Attachment) and i have other table and form call tblCarControl and frmCarControl in this form i have many fields and one combo box call cboCarId (data source from tblCarInfo) but...

In Ms Access code i need to write function for convert number to words, but in Modules i can't typing khmer unicode, it display only ?, how to fix it? Example in English (One) for Khmer (មួយ) but in module when i typing (មួយ) it show ??? Thanks Sokkheng

I can't open my project file it always show the message as below The Microsoft Access database engine could not find the object 'MSysDb', Make sure the object exists and that you spell its name and path name correctly. my Microsoft Access file version 2019Pro Plus How to solve this problem...

Should i create table for store open balance for every year and months?

I design the stock control system that I need the report that displays the first line is opening balance (Balance BF), and have the column transfer in, column transfer out, and current balance (Stock on hand), and one more report is user can set the date rank so if the user set the date rank...

please one more thing, I want to group my text box in ms access report for easy to move position or arrange it. Thanks

follow your instructions now I'm solve the problems, thanks for any help. Sokkheng

I create report that start from month to month, so the user can select month from the form that have two combo box cboMonthStart and cboMonthEnd. In report title i want it dynamic title refer to the user select month example the user select from Jan to Feb the title is "Report from Jan to Feb"...

I need code for checking Invoice ID after that field is update for protect duplicate. Now my invoice is check duplicate when i click save, so it wast the time for typing. thanks for reply. Sokkheng

Thanks for reply, now i still can't get value from that field. here are working properly if i use direct in (frmStation) that form Private Sub StationID_DblClick(Cancel As Integer) Dim VarStationCode As String VarStationCode = Forms![frmStation]![supfrmqryProvinceStation]![StationID]...

here is my text box control texbox = Forms![NavigationSubform]![frmStation]![supfrmProvinceStation]![StationId] If i use direct in my form without in navigation form it's ok texbox = Forms![frmStation]![supfrmProvinceStation]![StationId]

I have one text box (text box in main form) that will get value from field in sub form after i double click that filed, it's work properly, but after i create Navigation Form (Navigation button) that attach to that form that text box can't get the value from the field in the sub form. this is my...

Thanks for your reply, for my idea i need to make query for send to process report that in column for the months (Jan, Feb, Mar....) row for show the expense account. i need to make 3 report from the query: 1- Report 3 months (Jan, Feb, Mar) 2-Report 6 months (Jan, Feb, Mar, Apr, May, June)...

Could you please guide me the good way for make query report by month (3months, 6months, 12months). i need this report for show by month and by expense account. thanks for any help. Sokkheng