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!

Register Log in
  • Congratulations Rhinorhino 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: air1access
  • Content: Threads
  • Order by date
  1. air1access

    Get field name and add as a value

    I have a piece of code I'm messing with to normalize a recordset. I'm trying to get the field name of rs1 and add it as a value for rs2. I have a tried a few things, but can quite get it.... Any suggestions? Thanks in advance..!! Dim db As Database Dim rs1 As Recordset Dim rs2 As Recordset Dim...
  2. air1access

    Access data to Powerpoint Slides

    I have lots of powerpoint slides I need to create every month. The slides are the same for every one. So I have a template basically that never changes. The only thing that changes is the info on slides 2 (current date) and 4 (table in powerpoint). I hoping there is a way to take a query of...
  3. air1access

    Union Query to Reformat Results

    I have seen this trick a while back but can't remember how to do it...! I have a table with the data like this: Admin Ops-141 Escalated Member Status Change - 141.12 Admin Ops-141 HouseCalls Business Continuity Plan - 141.11 Admin Ops-141 HouseCalls Small County Analysis - 141.13...
  4. air1access

    Chart Series Name and Change Color

    I'm trying to put together some code for looping through seriescollection names of a chart, and change the color of the bar depending on the series name... Any ideas or suggestions? Below is what I am working with: 'On Error GoTo Err_btnColors_Click 'define chart colors for each series...
  5. air1access

    Compare Tables

    I working with the code below. This works perfectly if I just have 1 primary key that is a number field. Now I have 2 fields that are the primary key. One is a number, and one is a text field. I need to be able to compare each record by the 2 fields... How can I get this to do that...? Do...
  6. air1access

    Save attachments from Outlook

    I am working with some code that saves the attachments on selected emails... It saves out the first attachment, and then the next attachment has the file name + a formatted date trailing on the name... It does this because the attachments are all named the same thing. I don't want it to name...
  7. air1access

    Connect to specific Outlook Folder

    Below is code I'm working with. It works just fine. BUT - I need to connect to a different inbox, and a folder in that inbox... Right now it connects to the folder "HPMS" in MY inbox... But I need to connect to a different inbox - different folder in that inbox.. I can't figure it out...
  8. air1access

    Text File Edit Before Import

    I have a text file with an "=" sign on each line... I need to remove this "=" sign before importing into an Access D/base- for each line... My text file is actually a .csv file with headers on the 1st line for field names... Not really sure how to go about this.... Any suggestions...?
  9. air1access

    Format text date to 1st day of month...

    I have a table with records that hold a "text date" that is formatted like: Mar-2015 Apr-2015 Feb-2015 Dec-2014 I need this field reformatted with a new field to show the value like: 3/1/2015 4/1/2015 2/1/2015 12/1/2014 Any suggestions or examples..?
  10. air1access

    Text Box Value - to Be Field Name in Reports Recordsource

    How can I get the value of a text box (on a form) to be the field name in a query for a reports record source - at run time? The text box value will equal a field name that is in a table that is used in the query to build the reports record source. I'm trying to build it to where the user does...
  11. air1access

    Extract Data Elements from Memo Field

    I have memo filed in a table that I need to extract some data from and add as a new record to different table. The memo field has the same structured value in it each time. Its the body of an Outlook email that is imported into my d/base. The event file that you uploaded has been validated by...
  12. air1access

    Loop Field Names - Update per Combo Box

    Ok - I have a form, with a combo box. The combo box contains "Jan-2015", Feb-2015", etc. I have a table with field names "Agent_SAN", "Jan-2015", Feb-2015", etc. I want the user to be able to select a month-year from the combo box, then update that matching column/field in the table... The...
  13. air1access

    Date Range from a given month value

    If I have a value in one field that is 4/1/2015... How can I get all records from the 2 months prior to 4/1/2015...? March and Feburary.... This does kinda what I want - but only works for getting the records for the 2 months prior to the current month... Between...
  14. air1access

    Generate Reply Email

    Hopefully this is the right area to post my request... I have a form with a cmd button. The cmd button generates a new email message with the a text box contents as the body of the email. Below is what I'm working with.. What I am wanting to do is instead of generating a new email - I want it...
  15. air1access

    Edit Outlook Inbox Data from Access

    I have a command button on a form - that runs a piece of code... It connects to a Outlook Inbox, and updates the "Categories" field in the email data. I almost have it working...! Ha..! It updates the data/emails in outlook but not the EntryID I'm searching for. It just updates all of the...
  16. air1access

    Remove unwanted contents of string

    I have a memo field that I need to trim the date from the left and leave everything else out... How can I get just "Thursday, December 11, 2014 8:27 PM" out and into a seperate field...? "Thursday, December 11, 2014 8:27 PM" is the very fist part of the value in the memo field... Any...
  17. air1access

    Convert from Long Date

    I have a text field value that I need to convert from December 11, 2014 3:58 PM to 12/11/2014 3:58 PM Any suggestions or examples.. I'm stumped..!! Thanks in advance..!!! jcw5107
  18. air1access

    Split Text File Into Smaller Text Files

    I have searched and searched... I cannot find anything that I can make work for me.. I have a huge text file (about 4mil lines/records). I like to break it up into smaller text files, in the same location. Something like read the first 200,000 lines of the original, write that to a new text...
  19. air1access

    Outlook Inbox Loop

    The code posted below works fine until it comes to something other then an Outlook "message"... I need to have it go thru each item in the inbox, check to see if its a "message", and go from there. If not, skip, and continue the loop... Any suggestions or examples..? Thanks in advance...
  20. air1access

    Field Value AND Field Description Property

    I am trying to update one table with data from another as well as a field property value (description)... It like I can almost get it to work...!! Ha..!! Just not setting up the references to the table the right way I guess... Below is what I am working with... Any suggestions or examples would...

Part and Inventory Search

Back
Top