Search results

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

I create new query for create Sum in any fields and make new field for amount that sum fields, but when i create new field for amount when i run the query it always as me to "Enter Parameter Value?" what problem with new field for amount?. In any field that we use Sum it auto to create field...

With code for user click on bin

How i can export ms access report to ms word document with specific file name (mean I want to put file name with my customer ID). Thanks

In my database ms access when i click preview report it show the message my database was unable to create windows. "The system is out of resource or memory." I use Microsoft access 2016 MSO (16.0.12527.20260) 64-bit Please let me know what problems with my database (ms access problem; my...

what is CF condition?

I want to prevent user from coincidence delete or edit record in the Main invoice form and Sub invoice form, and I have one command button that allow Edit or Delete when i click. I set in the form property of Main invoice form (Main invoice form have one Sub invoice form in side): Allow...

Thanks for your reply, and how to replace value = 0 with blank, or how we can make conditional format if the value = 0 is change font color to white (only hide with white color) in the report.

In my report some field value = 0 and some value <>0, But now i want to display only value that <> 0 and value = 0 is blank, because i don't mess with 0 value. Thanks for help.

In Crosstab query i need to show in column heading by product name mean i have 7 product name and i want it always show all 7 product name however in some product name don't have data i need it show that column name also (In Crosstab Query for Column heading it show only the product name that...

In my database i have one blank table for store data that get from many query for share to other user use for make report or export to excell for what they want. in my process : 1-I have one blank table 2-I create action query (delete query) for deleted previous data to make table clean prevent...

Thanks for your help.