Recent content by graviz

Rally is an agile tool similar to Jira.

I'm open to suggestions. I started with the following in the query design view: "IHS Projects: IIf([Project]="sh.p.smart home" Or [Project]="sh.p.supply chain" Or [Project]="sh.p.wfm / ofs" Or [Project]="sh.x.perficient" Or [Project]="sh.x.wfm/ofs" Or [Project]="sh.x.crafted" Or...

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 tried all that. I tried making a new access DB, creating a new ODBC connection and no luck.

If I open the first two it always works. That's the odd thing. Again the connection string is the same except for the table name.

I used access to connect to oracle as a linked table. So I made some progress but have no idea what's causing this: There are 6 Oracle tables (A,B,C,D,E,F) I'm linking to in a single DB (the connection string is the same except the table name). When I open my access DB, if I try to open 4...

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

If the table gets deleted each time how would I do that. Basically what I'm saying is I can't go into the design of the table and set one to a primary key. There is a unique field if there's a way to do it through code.

So that's what I was trying but I didn't want to create duplicate records. Here's my code that works but it's creating dups: Public Function Output_RFC_Tables_Test() Dim Conn As ADODB.Connection Dim RS As New ADODB.Recordset Dim MySQL As String Dim ArrayRS As ADODB.Recordset Set ArrayRS = New...

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 knew I was missing something simple. Thanks! One step closer!

Public Function Split_SCR() Dim Org_RS As Recordset Dim New_RS As Recordset Dim SCR_Array As String Set Org_RS = CurrentDb.OpenRecordset("RFC_STAGING_1") Set New_RS = CurrentDb.OpenRecordset("SCR_Split") Org_RS.MoveFirst While Not Org_RS.EOF SCR_Array = Split(Org_RS.Fields("SCRs"), ",") For i =...

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

That did the trick, thanks! I'll post my final code with the loop.