Search results

  1. C

    Tab Key causing Access to Crash after open a report

    The problem comes from the Cycle Property in the Other tab, you have to set it to Current Record. The filters would be better to make them in a data summary mask and then eventually print the result.
  2. C

    Inserting rows based on dates

    The unique index "yr" of the "Dues" table is wrong as it is set only on "Year" while it must include "Year" and "MemberID".
  3. C

    Keeping linked date over 2 tables

    Again I repeat that it can be done but it is necessary to have the Excel file available, with a minimum of data and replacing any sensitive ones, to get an idea of how to carry out the project.
  4. C

    Keeping linked date over 2 tables

    Of course it can be done but you need to have the Excel file available to get an idea of how to carry out the project.
  5. C

    Make one row for every invoice and it’s payment

    Yes, but the attachment satisfied your request.
  6. C

    Make one row for every invoice and it’s payment

    In the attachment you can see the example where I took the liberty of modifying the Data Source of the subform which is now given by Query3 without the need to set all those conditions as in the QryReportSubCustomerProject. Furthermore, I would like to point out that the database structure is...
  7. C

    Display connected data through duplicate data

    In the image you can see the relationships.
  8. C

    PW to enable controls in sub-form

    A few records are enough, replacing sensitive data with random ones.
  9. C

    Employee Lateness

    A few records are enough, replacing sensitive data with random ones, especially to see the structure of the tables and relationships.
  10. C

    Employee Lateness

    Have you already developed anything? if yes then attach a sample file.
  11. C

    PW to enable controls in sub-form

    Attach a sample file.
  12. C

    Normalization

    You can compress it and try to attach or post on a site with a sharing service.
  13. C

    Normalization

    In order to give an opinion it would be necessary to really see how the two tables are structured by posting an example file with a minimum of data and replacing the sensitive ones. It can be said, already now, that the States, the Cities, the Postal Codes, the Contacts, the Pastors and...
  14. C

    Edit entries(List) of Combo Box

    To give you an answer it would be necessary to have the file available to check if the error occurs.
  15. C

    Design Help

    Sorry but from the excel file you understand little and nothing, perhaps it is better if you attach in file what you need to start from to recreate the structure in Access. Also you should describe step by step what the program should do, example: enter the Building create an estimate of the...
  16. C

    Access Calculations Based on dates

    The fundamental problem, as partially already reported, is in the structure you have given to the database. Data recording should be done, briefly, in three tables: tblEmployees EmployeeID Surname FirstName SerialNumber tblPerformance PerformanceID EmployeeID StartDate Endate...
  17. C

    Access or Excel?

    In order to be able to give you some advice it would be advisable to see how far you were with the project, in access, which you say you have already completed.
  18. C

    Relationship or Table problem, where am i going wrong ?

    You must enter the value of the ShipmentNo field, from the GoodsOutward table, into the ShipmentNo field of the Parts table for all items that are to be shipped with that shipment.
  19. C

    Solved Access crash

    Maybe if you can attach the database, devoid of any sensitive data, you can see if it runs regularly on another computer. If so it means that it depends on your Access.
  20. C

    date query

    ... WHERE Date()>=(DueDate-30) And Date()<DueDate
Back
Top Bottom