Search results for query: *

I have a database here at work (not developed by me) where there is a text field that is laid out thusly: Undelimited_Field LLL-LLLL-3 LLLLL-LL-5 LL-LLLLLLL-19 I need to be able to parse the field into 3 fields, the last one being a number field. Is there a quick and easy way to create a...

I have a form that I wanted to improve for the users by allowing them to double click in a cell and autopopulate today's date (using the on double-click > textfieddate=date() approach). However, I also don't want this field updated until the user hits an edit button which unlocks the editable...

I created a database quite a while back that has multiple combo boxes for the users to select "Reported By", "Analyst Assigned", and "Tester Assigned". What we've discovered after using the database for a while is that these three fields are often, but not always, the same person. It was...

I have the following query to accommodate a multi-user setup and assign work. SELECT entity_discrepancy.RowNumber, entity_discrepancy.FieldDiscrepancy, entity_discrepancy.TaxId, entity_discrepancy.TinType, entity_discrepancy.AmsSystemKey, entity_discrepancy.DmsSystemKey...

I am looking for a way to search a field on a table for a special character. I want to identify each record which has a comma embedded. I have tens of thousands of records to search through. I did a keyword search, but am having difficulty since I don't know what keywords to search for. Any...

I've done some searching via keyword, and I cannot find the answer here--which is amazing to me, so perhaps I'm not doing my search accurately. Anyway, to the point, I'm working on a database which the analysts in our area will use to record the work we're currently working on. It will be a...

I have a database where users enter transactions. Some transactions require that the users enter a quantity (which I "sum"), and other transactions are by definition 1, so I just "count" those). There are certain transactions where the quantity is optional. For some reason...

I've read the excellent FAQ on name parsing, but I'm getting data that needs to be parsed that is in more than the 9 different formats that are listed. Here are the formats I have to work with (all in one field) FirstName MiddleName LastName Suffix FirstName MiddleInitial LastName Suffix...

I'm not a programmer, but I've worked a bit on building Access forms with some success. What I'm working on currently is a database where the users will want to enter information regarding insurance licenses (requests for appointments) that are sent to several companies. Much of the...

I built a database for a multi-user environment, and have lately been getting this error a lot. It is very disrupting to all of our daily work. I've searched this list and have not found a solution. Does anyone have any idea how I can avoid this problem altogether? It is very frustrating... JW

I have a sequel statement assigned to mstrSQL and when I call for it using this code Me!WorkToDoLST.RowSource = mstrSQL everything in my list box shows up okay. However, if I try to add a sort, such as Me!WorkToDoLST.RowSource = mstrSQL & "ORDER BY DateIn DESC" my list...

I'm attempting to add to a record using a SQL statement in code behind a form. I have an option group indicating which queue a piece of work is going into, then I want the SQL statement to look up the actual queue name from the table and paste the name (queue name, not the queue number) to the...

I have a query which I'm using for a mail merge program for agents. I can easily weed out the lines of business I don't need (Medical, Health, and Variable Life), but now I want to combine the agents who have either Life only, Variable Annuity only, or both. I thought I could use a Group By...

I've posted this question here a couple weeks ago, but I think I wasn't clear about what I wanted. I have a form where reps enter the quantity of each type of transaction that they accomplish. They should first enter their name and the date the work was completed. Then, I want them to be able...

Not sure who wants to help me tackle this one, but I'll start out with the entirely too huge SQL Statement. SELECT TransactionsTBL.TransactionID, OptionGroupTBL.OptionGroupID, OptionGroupTBL.OptionGroupName FROM OptionGroupTBL INNER JOIN TransactionsTBL ON OptionGroupTBL.OptionGroupName =...

Friday, before I left work, I had a form developed, and which was running acceptably (more tweaks needed, but still workable). Monday morning, I opened the database and the form, and got a "recordset is not updateable" message when trying to enter sample data. I'm not sure what...

My combo box will jump to a letter entered (i.e. hit "w", it will jump to the "w"'s of the combo box list.) However, it won't allow the user to down arrow to other w's in the list. It just goes to the first one forcing the user to use the mouse. I'm probably not explaining...

I'm developing a form which lists various tasks and the quantities of tasks completed. There are 30 or so of these transactions. I have created a tabbed form which separates the transactions by type. What I want, is for users to be able to enter the quantities next to the transactions and to...

I have a database where we keep track of incoming mail--who receives it and who completes it. For several month's, users were entering their own names to identify their work via a combo box. I have set up a new form where the name field is now populated by their user ID from Windows login...

I have a form where the user looks up items entered into the database. I want them to enter information, choose a button which says "Mark Completed", and have Access assign today's date and time to the table--unless the item has already been marked as completed. It would be nice if...