Search results

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

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

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

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

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

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

I have password input form for input user name and password, but in password text box when user input capital or lower-case it true the same way. Example: password and Password it true the same. how to make more restrict with capital and lower-case. Thanks

I have create code for user input password in input box for process to open form, but when show input box and we input the password it show the password (readable) not covert to password style (*******) how to covert InputBox in ms access to password mask when we typing. this is my code: Dim...

i want to make report that detail of invoice group by customer, and at the end of report (report footer) i want to get data from other query that show only the total summary of debt, payment and balance. mean in one report i want to show data from two different query. how can i do that? thanks.

I have create Crosstab query that source is get from the first query that have input Start Date and End Date get from my input form. when i run the crosstab query it show message : The Microsoft database engine does not recognize '[Forms]![frmNavigationForm].[Form]![txtStartDate]' as a valid...

I have create list box (lstReport) that get the list of reports name from table report. now i create a command button for print the report that i select from the list report DoCmd.PrintOut me.lstReport But it not working, what problem with my code. Thanks for any command.

Could you please tell me how to disable/enable the shift pass key in ms access 2016, i have tries many time but not working. If you have other way for protect your database, please let me know. Thanks Sokkheng

I have create invoice form (Main Form : invoice number, date, customer name, address / Sub Form : item detail, unit price and total. Both form have two table that relationship with invoice number) before is ok both main form and sub form are work properly, but now subform is disable can't entry...

Thanks in advance! I have make program for print sale invoice and control stock. For my invoice side letter 8.5 x 11inch Continuous paper and use printer LQ 2190. The invoice paper i have design and printing with Logo, letter head and table form allready. In my database we print only Invoice...

I'm Sokkheng, from Cambodia. i have design some database using Ms Access.