Search results

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.

Could you tell me more clear about to use API? Thanks

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

Thanks for your reply.

In sub report it always have relationship with main report? for the two queries that i want to show data it doesn't have relationship to each other.

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.

thanks for reply, for preview report is ok, it have problem only for print report when i click it do nothing.

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 for your reply, in my invoice max 15items but some invoice have 2 or 3 or 5 or 10 or 15items up on we sold in one invoice not fix items. but the Grand total we need to print in to the area spot in the invoice paper the we design and pre print already.

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.