Search results

Yikes! Somehow I've created an endless loop. I'm a novice code writer and I need help here. What part of my code is causing the loop to never end? Option Compare Database Public Function getSpecialID(firstStr As String, middleStr As Variant, lastStr As String) As String...

I think I broke it? Ok, when a duplicate userid would be created, I had thought the code would assign a userid beginning with "dupuskm", but all I get is an error back from the update query saying I have a key violation. I understand why I would see the key violation. The field is set for no...

I'm using Access 2010. I have created a report, based on a query. This has taken quite alot of time to create. When I try to open this report in Report View, it gives me a Enter Paramter Value and lists my query. When I click the cancel button, the Report opens and works as expected. I'm...

I have multiple fields in a table that are set up as Yes/No and display as checkboxes on a form. Now I need to create a text field on a report that showes all the Yes answers. The text field needs to figure out if it's a Yes answer, then display the field name, if there is more than one yes...

No worries, please don't feel like that. You will find people on this forum are happy to help. There are casual users of Access and serious programmers who all come here. If it's Access related and you don't know the answer, ask. Someone on here is always happy to help. Good luck with your...

MS Word has a wizard under Mail Merge that should walk you through this. You just select your database as the source for the addresses. Hope that helps. Rhonda

Thanks for asking. No, I don't want to do an Append Query. The User record is created, my system just assigns the UserID. The person entering the other information on the form, never sees the field for UserID. It is not the primary field on the table, but is an indexed field. There are...

That fixed it! Thanks very much!

Thanks. I tried that, but same result. By the way, the ! is what Access put in, when I built the update field from the Expression Builder. I used the reguar Query design window when I created the Update Query. I just opened the SQL view so I could copy and paste it into my message here...

Paul, Thanks so much for the help you've provided so far. I used your code with a few tweaks. Now when I run the update query, using the following command, UPDATE tblusers SET tblusers.UserID = getSpecialID([tblusers]![First Name],[tblusers]![Middle Initial],[tblusers]![Last Name]) WHERE...

Paul, Great Idea! Unfortunately for use here, I can't add a number in the middle of the UserID. Setting a duplicate to a different UserID would simply be a marker, that would generate a Help Desk Ticket, that's when a person needs to get involved. Instead of the number, can I simply add some...

Paul, You do great work, I tweaked your code to fit my situation and it worked like a charm! On to the error handling part. I can't just let it pop up a message to the person making the entry, that there is a duplicate UserID, so I have to have my system see the duplication and change the...

Big thanks for the suggestion, I'll give your code a try!

As far as the O'Malley kind of names, that's already been addressed. The apostrophe is left out, it turns into Omalley as his last name. I've already checked for duplicates on existing users, so this would need to be in place for the creation of a new user. I have the necessary tables, forms...

Thanks for the quick response. Let me answer your questions. First of all, no this is not the Primary Key, I use a separate Auto Number for my Primary key. The task I've been given? The UserID field has required elements (Corporate decision, not mine). The field has to start with "uskm"...

I've been tasked with creating a text field, all lower case, that combines to start, 4 letters, then 1st letter of First Name (field), Middle I (field) if exists, can be blank and finally using the Last Name (field) to create a new record in the UserID field that does not exceed 12 characters...

I work for a mfg/dist in the IT Dept. I've worked with MS Access since the Access 2000 days. I know enough about code to be dangerous :) Actually, joined this forum to seek others with alot more knowledge than me, when it comes to coding. I'm in Kansas City, Missouri USA