Search results

Can anyone help me to find the VBA to print specific excel worksheets on a workbook from access vba.

Am trying to transfer a table to excel with the following code. But i am not getting the data in ascending order with a specific column. Can anyone help me plz.:banghead: Set rs = db.OpenRecordset("QUG_Accident_Register_MainTable", dbOpenSnapshot)

Here you may download : Subcontractor management system: 1. Subcontractor Management 2. Contracts Management 3. Invoice Management 4. Payments Management 5. User Management 6. Reporting Etc. Enjoy! User Name: admin Password: 12345 Cheers!

Dear Experts! I am trying to develop a simple software and stuck with criteria to calculate some fields. I have attached a sample excel file for your kind review. Can anyone help me in this regards without SQL.:banghead:

Hi Experts! I have deployed my access database with an excel linked to the database. Excel is in my desktop. But when i tried from another PC in which Access runtime 2013 installed am not able to open it. Error showing as attached. Can any one help me to fix it. Tried some registry location and...

Can any one help me to fix the formula Monthly Cost: IIf(AND([FromDate]<[LeaseStartDate]<[ToDate]),([ToDate]-[LeaseStartDate])*[MonthlyRent]*12/364,IIf((AND([FromDate]<[LeaseStartDate]<[ToDate]),([LeaseEndDate]-[FromDate])*[MonthlyRent]*12/364,[MonthlyRent])):banghead:

Dear Experts! Can i omit one column value and make a total in cross tab query. I have attached a sample screen shot for better understanding. From the column heading i need to get a total of all columns starting from "CROMPTON" till "TTC". Total should not include the "QDVC" Count. Could anyone...

Any experts to tell me a best solution to implement a system in place with workflow approvals and time attendance submission process. Can MS Access cater my needs? Is that practical to deploy Access runtime version to 900+ employees to collect their monthly attendance.:confused:

Dear Experts!!! I am developing an employee database and when i split it while running a VBA code it gives me the subject error:confused: It's highlighting the append query statement. It was working before i split it. Can anyone help me. Is there any endless loop in my coding. Please help...

I am trying from the mainform to check whether the subform field is blank and take an action. But it doesn't work :confused: . Can anyone support! Main Form = Proposal_1AABEmployee_MasteR_Tab Subform (unbound) = Proposal_A-Master_Table subform Combobox Control Name = Prop_Appraisal Type...

Hi Can anyone help me to convert the below sumif to sumproduct =SUMIF('G:\ACCOUNTS\ACDOC\01. Accounts Monthly Reporting\2016\2016.06\Accruals\[201606 Trial + Results.xlsx]Sheet1'!$A$12:$A$269,$C28,'G:\ACCOUNTS\ACDOC\01. Accounts Monthly Reporting\2016\2016.06\Accruals\[201606 TrialB + Results...

Hi Experts! I am beginner in MS Access and i am trying to develop an attendance tracking for my office. But i am not able to complete the project due to lack of my experience. Could anyone help me in this regards to accomplish my vision. I have attached necessary files for better...

Dear Experts! From the below SQL Query i need to get the unique records. Could anyone help me !:rolleyes: SELECT [Cost Center],[Employee Backcharge] FROM [Accommodation Module-6-LRT Employee Backcharge by Cost Center 2]; UNION SELECT [Cost Centers],[Sum of Total Amount] FROM [Accommodation...

I am trying to pull a query from access to excel and got an error message as attached saying "data provider or other service returned an e_fail status" Any Experts!!:banghead:

Where are my wrong with this formula. Help please!! TotA: IIf(IsNull([Basic Salary EUR]),0,([Basic Salary EUR])>0,([Basic Salary EUR])*IIf(IsNull([ZZB-Exchange Rate Table]![Eur Exchange Rate]),0,[ZZB-Exchange Rate Table]![Eur Exchange Rate])+IIf(IsNull([Allowance A]),0,[Allowance...

Dear Experts! I am trying to do a scatter chart as attached picture from my access query. But couldnt finilize as it is. I have attached the screen short of scatter chart prepared in excel and the access data for making scatter chart in ms access. Can any one help to get it done!!:rolleyes:

Where am i wrong in this formula. I am not getting the exact results. Expr1: [Total C]+Nz([Final Export]![Company Provided Social & Healthy Security],0)+Nz([Final Export]![Employers Additional Charges (Above 20%)],0)*[ExchRate]+Nz([Mobilization Demobilization Cost]+Nz([Final Export]![Furniture...

Hi .. Where am i wrong in this formula. I am not getting the exact results. Expr1: [Total C]+Nz([Final Export]![Company Provided Social & Healthy Security],0)+Nz([Final Export]![Employers Additional Charges (Above 20%)],0)*[ExchRate]+Nz([Mobilization Demobilization Cost]+Nz([Final...

Hi Experts! I am trying to do some sum of percentages through my cross tab query and couldn't get through:banghead: Could anyone help me to resolve it. Please look into my screen shots. 1. in the first picture you may see the query. 2. is the result of that query. 3. is the one I need...

:banghead: Dear Experts: I am a beginner in MS Access. Well I have developed a small software and now my issue is as follows: I am not able to delete all related records in a subform and the form when clicking the delete option. When i am clicking it should delete the project number and...