Search results for query: *

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

PS The drive spins fine and sounds normal.

I built an external hard drive using a Seagate Barracuda 300GB drive in an enclosure about 1 year ago. The other day, I turned it on but the drive wouldn't show in Windows Explorer. The computer just froze and it stayed that way until I turned the drive off. When I turn it off, it says the drive...

I have a table named tblMaster with two fields - AssignedTo and CaseNumber. The CaseNumber is imported daily but the AssignedTo is left blank. I have a dozen users and they need the ability to "assign" CaseNumbers to themselves without going into the table. The main form, frmMain, has a textbox...

Okay, I got it to update the records where the two fields match...still trying to figure out how to append the records from UpdatedCases that aren't in the MasterCases. Joe

I have an Access table named MasterCases that contains 5 fields - CaseNumber, CaseName, User, Event and EventDate. Every day, I receive another Access table called UpdatedCases from an outside source that contains these same five fields - but with updated information in the Event and EventDate...