Search results

  1. P

    Change backcolor field in datasheet view

    Hi again, Is it possible to change the backcolor of a certain field (text field) in a certain record into another color than white when another field in that same record has a particular value and to enable that field then? And this when the form is in datasheet view. Thanks once again. Pascal
  2. P

    Run-time error “3201”

    Hello, I have a form and a subform. On my parent form I have a field called “Workdate” and a tab control on which I have put my subforms (on each tab a subform which are all related to the workdate on my parent form). The field “Workdate” is a unique field, so I can’t create double records...
  3. P

    Creating new table in VBA

    Hi, I have a table with the following fields : ID, Name, WorkDate, CheckTime ID is a unique number for each employee. CheckTime contains the hour someone comes in or goes out the office. So, each employee has at least two records (mostly four) a day in the table. Example of the table : 1...
  4. P

    Show all fields from a linked table for each record

    Hi, I have two tables called "Employees" and "Categories". The table "Employees" was imported from an Excel-file. Table "Employees": Fields: "EmployeeID", "Name", "CategoryID", "Field4", "Field5" etc. Table "Categories" Fields: "CategoryID" and "Category". There are 10 categories. Tables...
  5. P

    Changing field order in a table with VBA

    Hi, I added three new fields in an existing table with VBA. These new fields where all added at the end of the table (after the other fields). Is it possible to add them (or move them) at the beginning or inbetween two other fields with VBA? If so, how can this be done. Thanks already.
  6. P

    Requery subform

    Hello, I have a form (called MyParentForm) with a subform (called MySubForm). On MyParentForm I have a text field called "txtState" and a command button called "cmdFind". The subform is based on a query I call here "MyQuery". When I fill in a state in the text field and click on the command...
  7. P

    double countings

    Hi, I want to make a query with 2 fields. The first field needs to count all the records in my table. The second field, which is a YES/NO field, needs to count only those records with criteria YES. My question is, if this is possible in one query? Or how can this be done? Thanks already.
  8. P

    Form with buttons

    I work in a hospital and I want to make a form witch shows me all the patients in my post. Please open the attachment I've included (it's a word 2000 document) in which you can see how I would like it to be. I saw it on an application at my work but I don't know how this can be done...
  9. P

    no data - open report error

    When I open a report with no data my own message box (put in the Report-NoData event) is shown followed by the following error: Runtime-error 2501 - The Openreport action was canceled. The report is opened by pushing on a button on a form with the following code: DoCmd.OpenReport "MyReport"...
  10. P

    gotorecord problem

    I have a form, based on a table with unique dates, with a subform. When I open the form I like to see the record for today in the form if there is already one. If not I like to see a new record. How can I make this happen. I use Access 2000. Thanks in advance.
  11. P

    starting database problem

    I like to make a database of football results and tables (standings), but I'm not quite sure how to start on it. First of all I need of course a table in which to store the results of the matches. But do I need to make a table for the standings (tables) or don't I, because this is something...
  12. P

    Navigate through records with the Calendar Control

    Is it possible to navigate through records with the Calendar Control? What I want is the following. I have a form with a calendar control. The form is based on a table with several fields including a date field. This date field is unique. Now, I want to navigate through the records with the...
  13. P

    duplicate values

    I have the following problem. I have a form with several fields including a date field called "Date". Now this field is unique so duplicate values are not allowed. So when I have added a new record but filled in a date that already exists and I close the form with the cross in the upper-right...
  14. P

    counting with dates and hours in a form

    I have a form based on one table. On the form I have 4 fields ("DateIn", "HourIn", "DateOut", "HourOut"). Now, I want to make a new textfield (not bound) on the form which has to show me how many hours are between DateIn HourIn and DateOut HourOut. Can someone help me please as quickly as...
  15. P

    multi-select listbox

    I know this question has been asked several times. I've searched the forum but I still can't solve the problem by myself. My VBA knowledge is not what it should be. So therefor I've included a simple database to this message. Can someone please solve my problem in this database and return me...
  16. P

    message empty field

    I have a form with a subform. The form is based on a table with 2 fields: "ID" and "Date". The property "Required" of the field "Date" is YES. So normally when I leave this field empty in my form I should get a message but I didn't have one. Now I've tried something. I've put a third field...
  17. P

    form

    I have two tables "Employees" and "Tasks". Now, I want to have a form on which I want to fill in the task of all the employees every day. Every employee has a different task. Every employee has one task for the hole day. When I open this form I want to see the employees already filled in so...
  18. P

    result 0 in a query

    In a query with the field "Code" which can contain A, O, P or U I want to count all the codes with an A in it. That's not the problem, but the problem is when there are no records found with "Code" = A then the query returns an empty cell instead of 0 (zero). Can this be solved? Thanks again...
  19. P

    counting codes in a field

    I made a form with a subform. On the subform, which is in datasheet view, I have a field called "Code". There are 4 codes (A,O,P,U). On the form I want to put a field that counts all the codes "A" that appear on the subform and not from the whole table underneath. How can I do this? I...
  20. P

    Summing hours

    When you sum for example 23:00:00 + 04:00:00 this gives as result 03:00:00. How can I sum hours that go above 24 hours like in this case I should become 27:00:00 hours. Thank you very much.
Back
Top Bottom