Search results

Has anyone created a connection to a Rally instance from Access? Right now I do a manual export into a csv file and import it into access but I'd love to figure out how to make a direct connection.

I'm trying to improve my coding and have created a function to loop through an array of values to see if a particular field contains them. Right now I have them hard coded as seen below. I'd like the array to read from a table if possible. I created a table called "REF_IHS_Projects" and the...

I have a database that links to some tables using an ODBC connection (Oracle in OraClient11g_home1). Just a couple days ago it said my connection failed when I ran my queries and I had to refresh the links where it prompted me for my password. Once it refreshed everything the data pulled fine...

I currently have this code to spit out some data into a table, however I would like to tweak it to be more of an append query. I know I need to use "INSERT INTO" somehow based on searching, but I also want to ensure the table doesn't get duplicate records in it from the previous code. Manually...

I’m not sure where to start so I’ll just describe the scenario. The Master table contains all the information I need however there’s a field “SCRs” that need to be converted by using a key in another table. I basically need to join the “SCRs” field to the “TS_ID” field but the “SCRs” field...

All I'm trying to do is a make table (table name to overwrite: "TBL_5_7_RFCs") query via VBA so I can loop through a set of VARs in a table. Here is my code: Public Function test_sql() Dim Conn As ADODB.Connection Dim RS As New ADODB.Recordset Dim MySQL As String Set Conn =...

I'm starting to work in Microsoft Project and wanted to see if I could import the data into an access table. The person who is teaching me has a macro in MS Project (listed below) and saves it as an excel file with 3 tabs (Activities, Resource Roster and Assignments). He the links to the excel...

I'm trying to send a message via Office Communicator using vba and am having some issues. I'm getting an the error "Invalid Procedue or Arguement" on the "Set msgr = Messenger.InstantMessage(ToUser)" line. Option Compare Database Public Sub sendIM(ToUser As String, message As String) Dim...

I've been trying to search for all picture files in my documents and copy them to a folder on the desktop. I found this below and it work great for searching however I'm having trouble getting the copy to work. http://www.ammara.com/access_image_faq/recursive_folder_search.html Dim...

Lookup Table Name: "Code_Test" Fields: Code: A 2 Digit Text Field Price: A number amount Example of values in the table: CV / 45 ~R / 15 I first wrote some code to determine if any of the codes in the "Code_Test" table is in the service_code_string field of a record (as seen below). It...

I wrote this code in Access 2003 and now I'm in 2007 and it's giving me a 1004 error Method of Save of object failed (XlBook.Save). I checked the refs and everything seems to be fine. Any ideas? Public Function Output_Overall() Call Init_Paths Dim cnn As ADODB.Connection Dim MyRecordset As...

I use the code listed below to create a custom function. I'm able to look at a field "service_code_string" (looks like "D0|D1|D2|D3|;=|KT|T:|2R|T0|T0|NG|A9|LK|U+|U$") and am able to test if a set of codes in in each line in the table. I'd like to try and code better and store them in a table...

I have a function that converts a number of days field into 30 day buckets. I've been asked to keep increasing the number of buckets so I was wondering if there was a way to do it with a loop of some sort. It would always be in increments of 30 and it could say either "60 Days" or "2 Months"...

I have some vba that dump an access table into a recordset and then into an excel spreadsheet. When the data is exported Columns I:Q (which are numbers) appear as text (with the green triangle in the upper left corner). I have a pivot table that refreshed however it can't do anything with...

I've been getting better at VBA over the past couple years however I'd like to try and learn how to simplify/condense my code. The code below allows me to output a query "02_08_Overall_Latest_Week" to a specific tab and cell. The "Call Init_Paths" is just where I have my paths stored so I can...

Is there any way to simplify and shorten my code. It works but I feel like I could shorten it somehow. Function DishNet_Converted_Type(service_code_string As String) As String Dim CodeArray, i As Integer NC_CodeArray = Array("60") CH_CodeArray = Array("64", "74", "8.", "R=") TC_CodeArray =...

I created two functions to use when I'm pulling data using a query (QBE). I would like to combine the two into a 3rd Function that works like this: BB_Only = DishNetActivityCode = 1 and VideoActivityCode = 0 Hybrid = DishNetActivityCode = 1 and VideoActivityCode = 1 V_Only =...

I have designed a form in excel that I need the user to fill out completely before they either send or save the file. I currently have code (see below) that prevents them from saving it however they're able to email it as an attachment. I've seen many posts on disabling the ribbon however I want...

I have a field that provides a 1 or 0 based upon if a field contains "-k" K_Code: IIf(InStr([service_code_string],"-k"),1,0) Is there a way to search for both "-k" and "QP" I tried with no luck. K_Code: IIf(InStr([service_code_string],"-k", "QP"),1,0) Any idea?

I have a form with a command button that prompts the user to select a picture file. When they select it it shows the file in a label. I'm trying to have the file path they select be stored in a string so I can copy, rename, etc the file. When I used a message box to confirm it still has the...