Search results

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

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?

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

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

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

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? :(:(:(

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

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”...

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

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

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