Search results

  1. C

    Timesheet Table AM/PM

    Attach the db in witch you made that test. I dont understand your suggestion!
  2. C

    selection combo box

    If you want a combobox in witch you will have only "in use" reagents, you need to create a query to use as a source for your combo.
  3. C

    Timesheet Table AM/PM

    Check this solution!
  4. C

    Recommended Table Construction

    My suggestion is to use the first option. And let me say why! I see the access database like a software for users. You, like a developer, should create the easyest to use software.The query is some work for you, but will not be seen in the front-end of the application. So, use the first option...
  5. C

    Calculated fields

    I don't understand: you have a access database and you want to export to access? How is that work? Returning to your problem, i can say that normalization rule about calculated fields is more of a suggestion. Be more explicit about your export desire and you can get an advice about your problem.
  6. C

    choosing form solution

    I've made the query and the form has a NZ & DLOOKUP in after update. My problem is that i wonder if is best to have all the prices and a field to enter special price only on some jobs, or should i enter special prices one by one. I have choose to enter them one by one. Is more simple.
  7. C

    Check box in a form

    Same problem! The unbound fields will act like this in a form. You will have to bound the field to a table field.
  8. C

    Billing System Form

    You level of Access knowledge is important, but i've asked about your database level. How is it structured, how many tables you have and things like this.
  9. C

    Check box in a form

    1. You cand check or uncheck the box independently because the checkbox is unbound control! 2 & 3 will may be resolved only after resolving no 1.
  10. C

    choosing form solution

    I have a situation and i ask for a suggestion. tbl_doctor with a list of doctors, tbl_jobs with a list of jobs that has a specific price for each one, and a tbl_special_price. In that last table i will have a list of special prices for some of the doctors for some of the jobs. So, some doctors...
  11. C

    Billing System Form

    You can't expect people to respond to this. You need to share the level that your db is at.
  12. C

    Booking system form

    You will need to create another table to join the two tables becouse one customer can go to many parties and at a party can come more customers. It will be a junction table. So you will have: TBL_CUSTOMER customer_id Other customer infos TBL_PARTY party_id Other party infos TBL_ATTENDENCE id...
  13. C

    Check box within a form

    I supose that the value DaysRemaining is a calculated field. In that case, you shouldn't store that value. Even if it is not a calculated value, the checkbox is a field that is "calculated" based on the field DaysRemaining. In that case, you shouldn't store this value. In a form or in a report...
  14. C

    Using several forms to fill in one record on a table

    i don't know if there is such a possibility (to insert data in a single row using to forms). But i have another suggestion: use the TAB control. The real solution is to split the table so that you don't have to many empty fields.
  15. C

    combo box with 3 items not displaying

    CJ_London's suggestion sounds more proffessional. My suggestions is from a newby. But i will do the way London said. I will steel his sugestion also. :D
  16. C

    combo box with 3 items not displaying

    Suggestion: create a query and insert a field concatenating the three fields. Use this query as a control source for the second combobox.
  17. C

    while filtering main form subform also gets filtered

    I've looked at your db and everything seems to be ok. I have no problems seeing the ElectionRelatedIncidents. If you think you have a problem becouse on the record 1 on the main form you dont see any records on the ElectionRelatedIncidents, well, that is becouse there is no such incident related...
  18. C

    Dumb (probably) Questions...

    Till a lit later i'm on mobile so i can't review your atached files. But i think that a lot of the fields in excel are calculated fileds. This kind of fields don't need to be inserted into databases.
  19. C

    Query to find specific skills

    If you use a form to choose the skill, will need to create a query with skill id (on the criteria you will reffer to the field - a combo box, best idea - in the form), employee name.
  20. C

    while filtering main form subform also gets filtered

    Maybe a sample of your db will clear us more.
Back
Top Bottom