Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...?

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..?

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...