Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: RDMRDM
  • Content: Threads
  • Order by date
  1. RDMRDM

    Help: Should I use an Access Pivot Table?

    I am working with a table of 20,000 records. I need to capture email address which is one of the fields in my table. I need to allow my users to select the criteria they want for the names they want. Such criteria might be selecting Full Time or Part Time employees, Males or Females, and...
  2. RDMRDM

    Helping: Auto send Access Report thru Lotus Notes Email

    I have an Access Database that is set to run on MS Scheduler to open every morning and send an email out. The Access Application starts, then it opens up my lotus notes with the attached Report with the correct distro. The problem is, I have to select "Send" in order for the email to go out...
  3. RDMRDM

    Checking Daily Record Count in Access Table

    We have a table that gets created each evening. We would like to create something that would run each morning that would check the record count and notify us if we appear to be missing records. For example, this table usually has around 21000 records. This morning, it only had 1497 records...
  4. RDMRDM

    Help: Set Order of Group on an Access Report

    I have a report that is grouped by 3 categories. Currently these 3 groups are showing up in Ascending order on my report. The 3 groups are Growth Relationship, Off Campus, Trusted Partnership. That is the order they are currently showing on the report. I would like to have their groups...
  5. RDMRDM

    Help: Query Output in a string

    I have a table with a field with email addresses. I would like to have my query results include all the email addresses separated by a comma. Example: Field Name: Email Field Name entry examples: JohnDoe@email.com JaneDoe@email.com JoeDoe@email.com I would like the query results to be as...
  6. RDMRDM

    Help: Adding Email address to field

    I have a field in a table with just the first part of the email address. Such as JohnDoe I need to add the @email.com to this field. Wondering how I would write this to include the @email.com so the new field would read JohnDoe@email.com I am guessing I would do this in a query. Thanks...
  7. RDMRDM

    Help: Forms Combo Box Storing Data

    I have a form with a combo box drop down for the users to select which field they want. My drop down has 5 columns that allows the users to decide which field they want. I use 5 to give more description. My problem is, it appears I am only able to store just one of the columns in the table...
  8. RDMRDM

    Label on Form causing screen to flash when mouse scrolls over it

    I have a form where I put a label to explain what a field is. Problem is, when I run my mouse over this label, it causes my form/screen to flash. Each time I scroll over it, it does this. I am not clicking, just moving my mouse over it. This does not happen when I go over List or Combo...
  9. RDMRDM

    Help: Refreshing query record on Form Automatically

    I have a form that has a list box. Within that list box, it is tied to a query. When I change a record on the form that is tied to that query and go to the next record, this query does not update my totals. If I go up to menu and select Records, then Refresh, it will update the form to show...
  10. RDMRDM

    Help: CrossTab Report Layout

    I have a CrossTab query that returns the results I need. I am looking at putting the results into an Access Report. Problem is I have around 30 fields along the top of my report. Is there a way to format the field names on the top to read at an angle or stand vertically along the top to use up...
  11. RDMRDM

    Help: Set Required # Characters on form in Access

    I have a text field on my form to enter SSN. The field is for Social Security Number. Since SSN's are 9 characters long, I would like to set this field to require the person to enter 9 characters and only 9 characters in length. How would I do this using a text box on a form? Thanks.
  12. RDMRDM

    Help: Import Access Data to link to Combo Box

    I have a table in Access 2003 that has combo fields to allow me to select the field I need. For example, the combo box has Yes, No, and Maybe as the 3 choices. When I import data from Excel, even though the field has Yes, No, and Maybe in Excel, I am required to reselect the Combo box field...
  13. RDMRDM

    Need Help:Sorting Records on Form List Box

    I have an Access form that shows data from a table called "Contacts". This table has a list of contacts and their information. On the form, I added a "List Box" showing Lastname and Firstname from the contacts table. I added this to allow me to find various contacts in the table by selecting...

Part and Inventory Search

Back
Top