Search results

  1. yhchen

    Validation Rule Help: Option Group VS Text box

    I have a form that I use to track the imcoming phone calls I would like to set the field of a textbox "Student ID" as a required field when the value of option group is 1 (when the value of option group is 2 then "Student ID" is not a required field) I am struggling how to write the...
  2. yhchen

    why does this code work in one form but not the others?

    why doesn't this code work? I have been trying to figure this out for whole day but not very successfully... so I am hoping someone here will be able to spot the error... I googled this datestamp method: It worked once (somehow) and then just doesn't work anymore.... any idea?
  3. yhchen

    Date Stamp

    Hello.... Hope someone here knows about the answer about this: When user attempted to update a record in the form, I would like the field "lastupdate" to be datestamped if the field Confirm Update (yes/no) is ticked... I tried to use IIf([Update],Date(),"") but it's not working... Hopefully...
  4. yhchen

    When open a form go to the new record

    I made this simplest code so when the form opened it would go to the new record but sadly this simplest code in the world doesn't work... :( Private Sub Action1_Open() DoCmd.GoToRecord , , acNewRec End Sub On the form property, I set Open to Event Procedure but it is not working...
  5. yhchen

    how to write this criteria....? Please Help

    I am writing a database to record staff training records each training record will have two costs involved: cost of the course and no show cost I would like to write a query which if attendance is set to yes, then the record would show the actual cost if the attendance is set to NO, then the...
  6. yhchen

    Help...why is my dlookup not working....?

    I have looked at the text book and checked many times, and I am sure I am doing something wrong.... I even created a simple form just to test it out and it is still not working.... can anyone see the mistake in the attached graphic? :(:(:(
  7. yhchen

    HELP!! Copy and paste data from subform to the main form

    HELP!! get subform data to the main form or Dlookup with If statement Dear all I have a form which contains a subform (see attached graphic) I would like to have a bottom created that on click it will copy the student number field and student name field to the main form (as shown in the...
  8. yhchen

    Experts View needed... search and fill function in a form...

    Hello experts….I have created a log system recording the usage of student services which is currently working just fine but I am looking at making some improvements…. The log form is called “Log” which writes data to a query called “Log_Data” (contained two tables: “Log_Table_Enquiry_Data”...
  9. yhchen

    Multi-Users Form

    I created a form that is used to log the enquiries we received as well as making appointments. During peak time, up to 7 users might be using the system. It works fine, but over last week (the freshers week) the system seems to be frozen from time to time (error message: you cannot go to the...
  10. yhchen

    Text Validation for a form written to two tables

    I have a form that will write data into a query which has two linked tables, call it Table A and Table B. In table A, the “ID” field is a required field. In table B, the “Name” field is a required field, this will only trigger if Field B is not null. So for example, if a staff write a record...
  11. yhchen

    Debug help!

    Text search in a form Hi guys I know very little about VBA codes but managed to find a well-written VBA code which I can use for my form - which you can enter text and search to display the result in the subform. It works perfectly well... However, I would like to create the 2nd text box...
Back
Top Bottom