Search results

Thanks, It's a bit difficult to copy and paste the information into a new database due to the amount of tables etc - best just to give you the exact replica I think. When it loads simply press 'Continue' and select 'Student Details' and try and add a new record by pressing the 'Add Record'...

Still the same :-( Any chance I could upload the Database for you to view please?

It appears to stop at: If IsAlpha(Me.Forename) = False Then Did you put the function in a standalone module (preferred) or a form's module (not advised) ? I just created a new module? (Thanks.)

Thank you but I get the following error: Compile Error: Expected variable or procedure, not module I currently have a module called 'IsAlpha' with the following inside: Public Function IsAlpha(ByVal strText As String) As Boolean On Error GoTo Err_IsAlpha Dim intCounter As Integer...

Thanks - what type of input mask please?

Hello, I'm trying to make it so that my Student Forename field only allows text (from a-z i.e. no numbers etc) to be written inside the box, would I use a certain validation rule and if so how would I do this please? Thanks in advance.

You beauty, thank you very much.

All the information is fictional :-)

Hiya, I'm new here so please forgive me if this is the wrong forum :-) I am currently making a student record database system for a college project. I designed it in Access XP (Microsoft Office XP) consisting of tables, queries, forms and macros. The basic principle of the project is to have a...

Can anyone please help me? :-)

Hiya, I'm new here so please forgive me if this is the wrong forum :-) I am currently making a student record database system for a college project. I designed it in Access XP (Microsoft Office XP) consisting of tables, queries, forms and macros. The basic principle of the project is to have a...