Search results for query: *

I created a database using Access 2003 and created a field called "UserName" where I read the user's login name to their PC and default this for new orders. I used the following to do this: =Environ("username") Now, when accessing this database using Access 2007 or later, I get #NAME in the...

I have a query of data for which contains an InvoiceID field. There are several instances where the InvoiceID field will be duplicated. In these instances, I want to create a custom column that will increment starting with 1 then 2 then 3 ans so on. Is there a function or anything that I...

I'm trying to use a Do...While loop (or possibly FOR loop) to loop through a table in my Access Database that will display a value of a specific field as it loops through the table. I have a table (TableA) with 3 fields: (Field1, Field2, Field3). When pressing a button, I want to loop through...

Hello! I have an Access Database for which I have a table including names and email addresses. What I want to be able to do have the user click a button and generate an email for each record in the table and pull the email address from the appropriate field. Has anyone out there created any...

Hello! I have a report created in Crystal 9.0 and on this report, I have a parameter for which the user can enter in multiple values. If the user does in fact select more than one string value for the parameter, I would like to display all of the values accordingly. Is there a way to do this...

I have a Crystal Report (version 11), where I have the main report then a subreport embedded. I want to create a formula field that references data from the subreport directly. For instance, if the value in {FieldA} is empty or NULL on the subreport, then display the value in {FieldB} from the...

I'm writing a report that has date criteria and two parameters that the user enters in a begin and end date. I want the results on the report to display all records that fall within that date range, INCLUDING the dates that are entered. When selecting the "Between" option in the select expert...

Does anyone know if there is a way to suppress a FOOTER section based on a particular DETAIL section? I have two DETAIL sections on a report with two FOOTERS. I want "Page Footer a" to only display on the page for "Details a" whereas I want "Page Footer b" to only display on the page for...

I'm looking for a way to search through a range of cells and populate another cell with that same data if specific text is found. I've used this code to search a specific cell for contained text and it works great. However, I'm having trouble searching a RANGE of cells using the same logic...

I have a Word template form where users tab through and enter text into specific fields. The form is locked and the tab sequence is setup for easy entry into the form. Now, what I would like to do is have a default word or line of text on one of the fields and have the default text delete as...

I have a series of cells for which I would like to parse and pull out specific data from each of the cells. In this case, the data that is in the target cell(s) is not always the same length. What I want to do is always pull the remaining text from within the target cell after the first...

I would like to write a formula in Excel that will check the value of a cell and compare that against another range of cells and if Excel finds an exact match within that range, it will display the value of the cell next to it. For instance: A1 = ABC A2 = ZZZ A3 = VRE A4 = ZZZ D1 = ZZZ E1 =...

I have a table (Table A) with several fields on it (Field1, Field2, Field3.....). What I would like to do is create a query with a parameter where the user can select which field they would like to see on the query. For instance, I have created a parameter that asks [Please Enter Field:] When...

I have had Crystal Reports 8.5 for several years now and I created all of my reports using 8.5. Recently, I upgraded to Crystal XI due to needing it for a new software implementation. Well, we come to find out the XI will not be needed and v8.5 will be just fine. So upon uninstalling all...

I have a Microsoft Access Report that lists 4 different fields in my Report Footer. Out of these 4 fields, I would like to find the MAXIMUM value or the highest value for these 4 fields. Is there a function I can run within another field's control source like...

I have two databases that store two different types of information. Both databases are rather large and keep track of different types sales and items. I would like to create a "sales log" that will show total sales volume from "Database A" and import the totals from "Database B" to incorporate...

I'm trying to save a record on a form after any field has been updated/changed on that specific form. I've tried using the "DoCmd.RunCommand acCmdSaveRecord" logic within the OnCurrent, AfterUpdate, BeforeUpdate and OnDirty properties yet I am still not able to save the current record...

I'm looking to run a "Match" query that checks for matches on a customer name field within one specific table. My customer table has about 50,000 records and I want to find all those customer names that match based on the first 10 characters. I can run the default "query wizard" to create a...

Hello there! I'm looking to change the way attachments are displayed within my INBOX or any folder for that matter. Currently, if an email has an attachment you will see a "paper clip" designating an attachment is present. Instead of the paper clip, I want to be able to see the attachment...

Hello there! I'm looking to change the way attachments are displayed within my INBOX or any folder for that matter. Currently, if an email has an attachment you will see a "paper clip" designating an attachment is present. Instead of the paper clip, I want to be able to see the attachment...