Search results

  1. C

    Can this site give php help?

    Most likely there are a few people here able to offer you solutions/advices for your php-related problems. Give it a try by asking a question or presenting a problem.
  2. C

    No budget. Is Access an option?

    How different is php-mysql from access? Could i do a php-mysql app if i've never tried php?
  3. C

    No budget. Is Access an option?

    I have a big dilemma. I want to develop a app for the education department of my company. The users should be able to insert appoiments for the clients for attending some seminars. Users are located in each county of the country. The budget for this project is 0. Yes, zero! That means that all...
  4. C

    Newb in need of some serious help in table design

    2003 mdb for some of the users.
  5. C

    Newb in need of some serious help in table design

    I suggest a structure like the one in the attach. Because a certification has a many to many relation with the soldier. Feedback?
  6. C

    Multiple Prices per product

    I have another suggestion for your problem. Is based on my need of different prices for my services for some of the clients. So, i suggest: 1. a table for price list: product_id, product_name, price. 2. a table for special prices: special_price_id, client_id, product_id, special_price Using this...
  7. C

    Attendence hours/employee

    I have: - tbl_company (containing company info) - tbl_employee (containing employees info) - tbl_cim (containing working contracts info, related with both tbl_company and tbl_empployee) In the tbl_cim i have starting date of the contract, working time per day (in hors, according to the...
  8. C

    Question Barcode

    You can make the filed no 1 in tab order. This way, when you open the form, the field is selected. Or maybe you sould use some fancy code (not my thing).
  9. C

    Football fixtures problem

    I dont understand the mechanism for the english fixtures, so i cant even try to help you. But, i have a sugestion: take into consideration not to change the field caled Order. It's possible that you will need to know (for some game statistics at least) in witch division Man U played in the...
  10. C

    Question Barcode

    You can have a field in a table representing the barcode number (text or number). So you can use a form in witch you search rows by barcode number field.
  11. C

    Is VBA a must?

    Hi, I'm playing with Access for a few months now. Still, i have to confes that i a self-learner and i have no idea about VBA. I've tried to get it, but it's to damn complicated for me. Or maybe is not, but noone could explain it for my level. Anyway, i have a question. Lets say that i want to...
  12. C

    Question More Relationships

    I have a database structure suggestion. You will see it in the attached file. And i can explain my suggestion but you have to confirm that i understand your need of the database. So, you have trips on witch different companies do differnt services. Maybe one company provides the boat, another...
  13. C

    Update a Field based on prior field

    The principle is explained in this video.
  14. C

    Attendance Table

    In the attendance table, i suggest that you use in_time and out_time to note it (the attendance). You can set rules for in_time not to be earlier then start_time in classes table and for out_time not to be later then end_time in classes. Also, in classes table, you should have fields saying...
  15. C

    Unemployed!

    In this case, i think you have a case :) Of course, depends on your country laws.
  16. C

    Child Of A Junction Table

    Why do you consider that notes are needed in a one to many relationship? Before you answer, let me say why i think that one 2 one relationship is my recomandation. The client has a junction table for transactions. Once in a while a transaction has a note attached. The question is: should be a...
  17. C

    Unemployed!

    1. talk with a layer. Maybe you have some rights over the app that you designed/modified on your years on the job. 2. depending on your social status and responsabilities, you could take into consideration the idea of your own business. ;)
  18. C

    Loan Calculator

    Make it available with previous versions. 2010 is a lil too much. Or better, make it ACCDE
  19. C

    Help designing tables

    Depending on how complex you want your app, your tables can suffer modifications. Suggestions: a. the lot table should not have temp id. You should create another table, related on lot id, where you mention the temp and also the start and the end of that 3 months test. b. in test table should...
  20. C

    Table Relationship clarity

    The form will show employee table fields. The subform will show only the payroll table fields that are related with the employee in the form. You can make a lot of things in the form: you can navigate employee by employee (and each time the subform records will change), you can design a search...
Top Bottom