Search results

  1. K

    How to allow 3 decimals in the table, query, and form.

    Hi, I have a number field in my table. I want to display 3 decimals like 3569.150 but when I type "3569.150" access automatically converts it to "3569.000". How can I allow it to show the numbers after decimal points? Waiting for the expert's guidance, Thank you
  2. K

    Solved I need help converting overtime hours to the round figure.

    Hi, I have an attendance table. There are some fields: 1) Time_In 2) Time_Out 3) Overtime The field overtime calculates the overtime hours after completing 9 working hours. I need to restrict the overtime hours value: If the Overtime hour is less than 1.00 then convert it to 0.00. After the...
  3. K

    I need help adding some transactions to the vendor ledger.

    I have a voucher form with the help of which I do voucher entries. Each entry is posted in a table called GeneralLedger. I then display the entries for specific heads of accounts from this table in a separate report, such as all transactions for a specific vendor. Let me share some images to...
  4. K

    Solved I need running balance including add and less in the report field

    Hi, I need help calculating a running balance in a report field. Where the debit will accumulate in the balance and the credit will be subtracted from it. In the image below my report is getting the "CASH IN HAND" transactions from General Journal and showing the balance from there. I also...
  5. K

    Solved I need help in DLookup

    Hi, I am using DLookup in Microsoft Visual Basic for Applications, I actually want to get the values of 3 fields: 1) COACODE 2) AccountGroup 3) AccountType in a form, from a query "COACODE". Visual Basic Code is: Private Sub AccountGroupID_AfterUpdate() Me.COACODE.Value =...
  6. K

    Solved How can I restrict the front-end user from editing the queries?

    Hi, I have shared my Microsoft Access database by splitting BE and ACCDE files. The shared ACCDE file is working fine. But I don't want any user to make changes in any Query. Can anyone guide me on how I can restrict the users of ACCDE files to edit my queries? Thank you
  7. K

    Solved While splitting Microsoft Access BE file an error accrued "The search key was not found in any record."

    Hi, I am trying to share my database in my Local Area Network. When I am trying to split my database an error appears "The search key was not found in any record.". Please guide me on how to resolve this issue. And share my database so my colleagues also can use that. Thank you
  8. K

    Solved How to get groups of Autonumber depending on another field value

    Hi, I need help with an access query in which I already have 3 columns GroupID: Auto Number GroupName: Text AccountType: Lookup I want to get different Autonumbers for each account type in a single column. For example in the table below I've added a column name GroupCode, having different...
  9. K

    Solved How to divide total wage amount into currency notes.

    Hi, I need guidance for the Microsoft Access query in which I calculate the employee's wage. I want to get the number of different currency notes making each wage value. So it will be easy for me to distribute them. Example: Name Total Wage 5000 Notes 1000 Notes 500 Notes 100 Notes 50 Notes 10...
  10. K

    Solved I need guidance to calculate Duty hours and Overtime hours

    I am working on the attendance table to get Overtime and Duty hours. Conditions: Duty hours are 9:00:00 AM to 6:00:00 PM & Grace Time is 15 Minutes (If an employee arrives after 9:15, the number of minutes he is late will be deducted from his 9 hours duty hours). Overtime will be started after...
  11. K

    Solved How can I get first word from a sentence using Left function?

    Hi, I have an excel formula to get the first word from a sentence. =LEFT(CellName,FIND(" ",CellName)-1) Example: I want to use this in Microsoft Access to find the first word from a particular field by using calculation column. Can anyone guide me how to use this? Thank you
  12. K

    Solved I want to Show and Hide a field in a SubForm depending on the value in a field on Main form.

    Hi, I've created a voucher form to make different vouchers. There is a lookup field to select the Type of Voucher. List of Voucher Types is: CP-Cash Payment CR-Cash Receipt BP-Bank Payment BR-Bank Receipt PB-Party Bill JO-Journal SL-Sales A subform named GeneralLedger is associated with this...
  13. K

    Solved Hi, Can anyone guide me how to make an accounting database?

    Hi, I am beginner in not very expert in Ms Access but I am learning. I got a project from the company I work for. The Project is to create an accounting database. Database should be included: General Ledger Chart of Account Different types of vouchers (including voucher printing functionality)...
  14. K

    Solved Hi, I am trying to Concatenate 2 fields but I am not getting the desired result.

    Hi, I want to Concatenate 2 fields to make a separate Code for each account in chart of account. I have a fields: 1) ID containing numbers 0001, 0002, 0003 etc 2) AGCode (AccountGroup Code) containing 11, 12, 13, 21, 22 etc this is a code to Identify each Account Group such as Current Asset...
  15. K

    Solved I am trying to use Left function but I could not find my desired output.

    Hi, I am trying to use Left Function in Calculated column to get starting 3 characters of a specific field. Expression I am writing is: Left([AccountGroupID],3) OUTPUT 1) In "1.1 Current Asset" starting 3 characters are 1.1 so I want output in Code column 1.1 but its giving 1. 2) In "1.2...
  16. K

    Solved Hi I want to VBA Code for Currency to Words in Indian format but One Hundred Thousand instead of Lakh

    Hi, I have a VBA Code for converting currency to words. this code is working fine in Microsoft Excel. But I want to use this code in Microsoft Access Module to use in my report. The code is: 'Main Function Function SpellNumber(ByVal MyNumber) Dim Rupees, Cents, Temp Dim DecimalPlace...
  17. K

    Solved How to copy data from excel to access query.

    Hi, I am trying to copy attendance from excel to my Microsoft access query. There are 3 columns that I want to copy 1) Attendance Status: this is a lookup datatype including Present, Absent. 2) Time_In: this is a date/time datatype with a general format. 3) Time_Out: this is a date/time datatype...
  18. K

    Solved How to use time from a field in which Date and Time both are written.

    Hi, I am using the calculation data type field in my table to make a field that can calculate grace time for employee attendance. There are 2 different fields Time_In and Time_Out. I want to use time from the Time_In field while both time and date are written in this field. Is there a way I can...
  19. K

    I am trying to split my database an error appears "|9 was unable to export the data.".

    I want to share my database with someone to work together. But when I am trying to split my database an error appears "|9 was unable to export the data." Please guide me on how to split my database in this case. Thank you!
  20. K

    Solved Image is not printing in my report.

    Hi, Please guide me how to enable image printing in my access report. REPORT VIEW PRINT PREVIEW Please guid me ASAP. Thank you
Top Bottom