Search results

What if the name was something like First----- Middle----- Last Billy Bob--Earl------- Mc Allen I have not tested the fixname sub on those, but by the examples given it looks like it would break.

strColumns = Split(strField, ",") That should give you strColumns (0) the First half before the Comma and strColumns (1) the last half after the comma. Then you would need to focus on "FirstName Middlename". Names can be tricky so a Split(strField, " ") could fail to return accurate results on...

I hope it works for you, you will want to remove the " ' " from the 'On Error GoTo errhandler in your function once you have it how you want it. I forgot to remove it prior to uploading.

I looked at your Database, there is a lot going on. I think I understand what you are trying to do with the Function but your forms are a bit busy. I copied a few tables from your sample to mine and created a form and Function. Simply Click the button to run an append a query and Return the...

If no one helps you before I get to work tomorrow I am willing to see what you have and assist then.

I have Access 2007 at work, but here at home I have only 2003 so your example, at least for me will have to wait until I get to work tomorrow. Possibly someone else could take a look. The one function you posted in this thread however is not going to work just by copy/pasting into a module...

You would want to rename the command button to something like cmdShowIdentity. You do not want it to have the same name as your function or Public Sub.

Thanks for the assist Wayne, I was going to upload a DB using Kelso's function however it is missing a few things. Without knowing more details about what it is supposed to do aside from returning LastID, I assume this is the purpose, I hesitate to modify it and submit it.

I would do this: Dim Some_Variable as String ‘Your data type should be LastID’s data type preferably. 'Use your variable to call the function Some_Variable = ShowIdentity I see no reason for that not to work. Ideally you would want the Function as a specific variable (Whatever...

This one is prety good as well: http://www.allenbrowne.com/tips.html

You are very welcome.

Once you have the references window open Scroll down for Microsoft Activex Data Objects X.x Library, where X.x is the latest Number, then place a check mark. I am not sure but you may also need Microsoft ADO Ext X.x for DDL and Security.

I have deleted orphaned ldb files before to no detrimental effect. You should be able to delete it as stated above.

Did you set the reference for it in the Tools/References?

I do not know anything useful about Oracle nor how you have it set up in Access, so pardon me if I ask what may be a stupid question.. Can you manually input a new record?

You could tie a combo box to "Personal Details" and another to "Course Master" You could then add a button that when Clicked used DAO to Append "personal_ID" and the "Course_Id" into the "enrolment" table.

If you wish to append the names to an existing table you could craft an SQL "Insert Into" statement and then execute it using DAO.

Quite true. Thank you for showing me the 3rd query.

Of course I am counting non-blanks, I did not say otherwise. I simply stated you can count two fields in one Query. As in Version two in my sample you get a break down of all those non-blank records, which is why I made it. As I previously stated, it depends on what you want and what you got...

I honestly do not know why your Query fails, however I managed to duplicate it in some part. I copied your sql into a query and remade it so that I could use it. I received a similar error to yours. I have no clue why as everything appeared in order as apparently yours was. My solution or work...