Recent content by catalin.petrut

  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.
Top Bottom