Search results

creating a table with a list of all students in it will not be a problem, and of course the student number will be unique to each student. the table will simply contain two fields (student_number and student_name) I wonder if this approach will also provide a usage log which links to each...

Thank you DCrake. In that case, would you mind give an example how the script should be written on the student number field please?

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

It is beyond my knowledge but I am using front-end and back-end database so this will enbale you to circulate different versions of front-end to different users.

Thanks mate. I also found this http://support.microsoft.com/kb/304932 I have had a go and would like to try it Monday to see if it resolved the problem. Thanks a lot for your valuable opinion.

:(:(:( Thank you for trying though... :(:(:(

ah.. Right... when I tested it by missing inputing any text in the required field, and click "OK" It pops up the message I created, so I click OK. It then pops up another general MS Access Message says "You cannot go to specific record". I clicked ok again. Then, expectedly, with the...

no...nothing happened...no error message at all it didn't go anywhere but stay at the bottom I clicked...

cheers mate. the actual field name is Student_Name but the information you provided is very useful as I wasn't aware there is a list of reserved words

uh...no... they are all accessing the same copy on the network... please can you tell me how to split it to front end and back end?

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

GoToControl should make the focus go to the specific field (in this case, field Name) but it is not working.... If anybody knows why please let me know... Many thanks.

Hello guys Thanks a lot! I use macro: 1. Cancel Event (have condition set to: (Not(IsNull(Me.FieldB))) And (IsNull(Me.Name)) 2. MsgBox 3. Stop Macro 4. GoToControl and it works! Thanks!! You guys are the best! the gotocontrol command somehow doesn't work though :(

Hi....no..it doesn't work... it broke at Then showing "Compile Erroe, expected :)" any idea?? Also, when I type alone, the system told me as MsgBox I should follow: MsgBox(Prompt,[Button As VbMsgBoxStole=vbOKOnly,[Title],[HelFile],[Context]) As VbMsgBoxResult uh?? Many thanks for all...

on dear! thanks for the light speed reponse! will try to see how it goes!!

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

Please can you share what your solution is?

Thanks Banana.

write a simple micro: GoToRecord object type: choose form object name: choose your form name record: choose new save the macro go to your form, go to design view, choose form property, under event submenu, on click choose the macro you just created. it should work fine....

It's now working perfectly fine!! Thank you so so so so much! xxxx