Search results

need to add "me.refresh" at the last line. Can you try?

No one know the root cause?

can you make it in this way? Correct me if I am wrong.

Dear All, I have write some VBA coding for a field. It is about after select the Employee Name, then VBA will run and get the outcharge rate for that employee and fill-in the field automatically. The code is as follow. The file is saved in a network drive, and the coding run normally in my...

Oh, I found the solution for this when I practiced. Here is the solution, just share with you all, the steps are as follows, - In the Report Design View, right click from the ruler bar (see attached MSAccess_Report_sortingandgrouping1.JPG) - Select Sorting and Grouping - Manager the Field you...

Dear All, I have a question, please help to guide me. I have a report, it contains Page Header, Name Header, Detail, Page Footer and Report Footer. I would like to add "Name Footer" in the report, so I can get a total cost for each Name Header. Can you please let me know the procedures how I...

THX for your help!!!!

Dear All, When I tried to explore someone MS Access, and try to learn how is there report format, however, I found that there is some terms confusing me. When I opened the report, it contains - Report Header - Page Header - Assigned To Name Header - Detail - Assigned To Name Footer - Page...

Dear all, I have tried to make a tab control within a form, inside the tab control, I put a subform inside. However, how can I call the text field within tab control > subform ?? For example, Main Form: frm_main Tab Control: TabCtl48 tab1: Project_Details tab2: Project_Milestones...

Thanks for your help~ I have googled few days about Gantt Chart, and I know how to make a Gantt Chart by using Excel > Conditional Formatting right now~~ It is useful~~

Dear, I just download a free template for project management, it contains gantt chart inside. I don't know how to make the cell change color without using formula and VBA. Anyone can guide me? Thanks, Victor

Anyone can help?!

May I ask, when I use the Shell () Function, do I need to enable some library in Tools > References ?

Got it!! Thanks!!!!

I am now working on a project management database. However, I got a question when selecting Milestone in Tasks Tab. Please look into the attachments "Milestones.GIF" & "Tasks.GIF" When a user create a project in project_details, afterwards, user required to fill in milestones. After finished...

Dear, I am now developing a project database with cost allocation...etc. I have created the 3 control tabs in 1 form. Please see "FormView.JPG". And now, I would like to show the subtotal of "Cost_allocation_percentage_rate" in text8 text box. I assume that the subtotal should be 100%...

Thank you for your sharing!! I got it!! Victor

Dear All, I have an existing form in my database already design. And now, I have to create another page which is related to the same record within the existing form. So I want to create an "Tab Control" for easy use. However, when I try to move the existing form's components into the new tab...

I would like the access to export a text file after the database close by user. For example, export some system log that I created, then delete the records inside. So, the size is not too large for Access. That's why I ask what is the Function Name of closing database. DoCmd.Quit is used to...

I would like to ask, The functionName for database close? For example, when user click close button on top right hand corner or the close button that I created. I would like VBA to do some procedures before close. If user uses the button that I create to close the database, then I can insert...