Search results

Thank you. I agree. The purpose for which I need this is to be able to identify any common strings (down to 1 character) that is consistent in any particular section (char 9 alone, or 7-12 together, for example) that are consitent in most/all of the codes. So your point is well taken that a...

I have a column of alpha-numeric strings and need to find what elements are common and located in the same segment of the text string comparing all cells in the column to each other. In other words cell in row 1 = M0G001EVC07720 cell 2 = M1L001EVC14009 In this...

I deal with very large .txt files that, when imported into Excel, have to be "conditioned" via macro to "clean" the data. PROBLEM: The data (rows) is sporadic (sample following): 3/21/2008 10:26 TSC Refill E NAME 7142125 Order: 37207524 3/21/2008 12:14 AGH E NAME 7536895 Order...

I receive reports formatted as a .txt (flat) file. Problem: I have to develop a process to manage the .txt files so the data can be separated into its own fields. The layout of the output is as follows: Date Time User Status Customer Name ID# 06/04/07...

Yes. Only the Access shell. Most of the toolbar items are grayed out.

Negative. Looks grim.

I have a table that is comprised of 2 previously seperate tables. The data sources were different for each, so the formatting of the date fields (specifically) were different. One source parsed the date fields into 3 seperate text fields for YYYY, one field for MM, and one for DD. The other...

Not sure what happened here. I now have an empty (277MB) shell in which I cannot see any tables or queries. The event occurred when the db automatically began to "Compact and Repair" in the middle of creating a new query. Any thoughts?

I have two tables: one that has (in part) call data from calls to a call center. The data includes the initiating (or calling) number/Start Date of the call/ Start Time/End Time/Duration, as well as City and State (abbreviation) of origin. I also have a table that includes time zones by state...

I have a db to count the number of times we receive calls from phone numbers recorded in MCI records. The phone number counts are "bumped" up against a customer database and those customer records [with matches on the phone number in the customer record] bring up customer information including...

I have a query used to drive a report. The report is to list each record grouped by rnCode by state (e.g. NY, NJ, CA, etc...). The report displays all records under each code for each state. I have been able to display the count (total) of the number of records for each code by creating an...

I have a Form in an A2K db related to Written Correspondence logging, tracking, and reporting. I need to activate certain fields based on the selection of the term "Complaint" or "Inquiry" from a combobox value list. "Complaint" needs to lock out "Inquiry" fields, and vice versa. Is there a...

Reportedly, IVR usage has dropped over time. I have a Date Range Query that pulls data for the range entered. I would like the user to enter time range (1) to compare to time range (2) from the same table and compare month to month, etc. Now the query shows the same time period data twice and...

Yes, I have tried it. The code received is: Private Sub Command384_Click() On Error GoTo Err_Command384_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 Exit_Command384_Click: Exit Sub Err_Command384_Click...

Have read previous posts re: this topic but not getting results from applying them...Command Button "delete record" does not delete record. Changed code as recommended DoCmd select and DoCmd delete. Form Record Selector on left of screen highlights, but a message box pops with "delete action...

I got it. The sorting should have been done from right-clicking on the detail section of the report, and from there going into Sort and Order criteria. I set the criteria up on the report, and did not have to depend on manipulating the query. My narrow focus on the query kept me from...

In a query I have an Expression used to capture the parameter [Enter Month as Digit]. Expr2:[Enter Month as Digit] This is taken from another expression: Month[Received Date] This is used to identify the Month the data was received. The parameter [Enter Month as Digit] is to be...

10-4, and thank you again for the prompt and helpful directions!

Thanks for the detailed level of your response! I will follow this closely and advise the success (or otherwise) I achieve.

I have built a database over time, but failed to establish referential integrity at the outset. Is there a method by which to do this after the fact? What should I be looking for in fields, etc that will create problems? Anything that you can provide will be appreciated. Thanks.