Search results

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

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

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.