Recent content by firebirdta84

They are text fields holding a string, currently.

Thanks, MajP! I definitely don't want to do the workaround if there's a better, more efficient solution best suited for long term use. That being said, I am a bit confused with your first post on how to normalize the data. Can you elaborate a bit more on what I'd need to do? Thanks! Joe

I need some assistance with assigned records in an Access 2010 database table, based on criteria found in another table in the same database. Two tables for this example: 1. tbl_Master: Each record is a separate report. These reports are given one or multiple categories based on criteria that...

MajP - Brilliant! Your code to analyze the data in reverse worked perfectly. Thank you very much! Joe

MajP - thanks so much for your reply. I'm going to try it shortly and I will let you know the results! Joe

Good Morning, I've been stumped on this problem for about a week now, hoping someone can help me out. I have a table called "tbl_Messages", and it contains a message transmitted by a user. Depending on the length of the message, it could all appear in one record, or the message could be split...

I figured it out...thanks!

Thanks Andy. The duplicate part I understand, I'm just not sure how I would go about via VBA coding updating all the records with the correct value. Would it be a loop where it starts with the first record, sees how many dupes there are, sees the highest number already assigned to the...

Yes, there is an ID field that is unique. I thought about appending the ID to the end of the case number, but I need the unique 2 digits to repeat for every case number, starting at 01. Thanks Joe

Hey guys, Need a little bit of help with this one. I have a table (tblCases) containing about 100,000 records. Each record has a ten digit number in the field called Case_Number. This data in this field is not unique; a single Case Number can exist in multiple records. I also have a field in...

Hi All, Running Access 2007 and need a bit of assistance. I have a table called "tbl_Master" where the first field is called "AssignedTo" and the other fields have data that is loaded from an outside source. I also have a table named "tbl_Users" with consists of two fields - "UserName" and...

MajP - with a little tweaking to my specific application, your code worked great! Thank you so much. Joe

Hey gang, I need a little assistance. I have a database set up where an individual can go into a form, select the number of records they want assigned to them, and it will go into the table and place their name in the "AssignedTo" field for each record they request. The table is prioritized by...

Hey everyone, I have a table named tbl_Master_BE with three fields - CaseNumber, FieldType and AssignedTo. Right now, I have code that fills in the AssignedTo field with a user's name for "X" number of records (that they choose from a drop-down box). If the AssignedTo field is already filled...

I have an Excel document with 40 tabs, one for each employee. This one document will go out to all 40 employees. When they open the document, they will see a main menu where they will choose their name and enter a password. It will then take them to their designated sheet. It is VITAL that each...