Search results for query: *

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

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

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

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

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

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

I am building a database where a workload leader will go in, select a group of records, and then assign that group of records to an employee for them to process. The fields are simple - Case_ID and Employee_Name. I'd like to populate a list box with the Case_ID. Then have the workload leader...

I am trying to use the .LDB file to determine who is in a database at a given time. I open it in Notepad and it shows me the following: FLD004161 Admin FLD004727A Admin FLD005611LS Admin...

I need to open a form and show only those records that meet two sets of criteria. I am currently getting a type mismatch when I try this. Here's the code: On Error GoTo Err_cmdOpenFeedback_Click Dim stDocName2 As String Dim stLinkCriteria2 As String stDocName2 = "frm_Feedback"...

I have 30 users on a database...yesterday they are started getting the error, "Record is Deleted". I went into the main table and found a record that just had pound signs (#) in every field. What caused this, and how can I prevent it in the future? Thanks, Joe

I have a table with 5 columns, UserID, UnitID, DateRequested, DateFulfilled and NumberofUnits. Here's a sample: http://i131.photobucket.com/albums/p314/firebirdta84/1-2.jpg I need to create a report on this information that gives a "summary" for each UserID - showing the average days it takes...

I recently built a database in Access 2003. It has worked fine for months and still continues to on computers with Access 2003. Well, the IT department at work decided to start loading employee's computers with the free Access 2007 runtime, and for those people, one of two things happens: 1...

I have a system in place where multiple users send me an Excel spreadsheet containing the same columns of information, just different data. I need to take those files and merge them into one Master Workbook, which will basically append each user's spreadsheet into one main one. Due to the...

I have some users on an Access 2003 database out in the field. The database is not set up as a front end/back end because a few of those users live in the middle of nowhere and have a dial-up connection, making loading speed of the database extremely slow. I have it set up so they email me their...

I have a form with a button that, when pressed, will open MS Outlook and attach a query from the database in XLS format. It works perfectly, but if I click the button and then decide I don't want to send the email and close out of the email, I get Run-time error 2501: The SendObject action was...

When the "New Record" button is pressed on my form, it will blank out all the fields and allow the user to enter a new record. One field in that form is the Primary Key. If someone accidentally presses the "New Record" button, they are forced to enter at least the Primary Key. Is there a way to...