Search results for query: *

I am putting this code into an access query and the last two iif statements give me a #Error result. So it's not recognizing anything for "VA", "FHA", "RISK". Investor2: IIf([MIS.CD] In ('B','L','M','N','S','W'),"PRIVATE",IIf([MIS.CD] In ('C','V'),"FHLMC",IIf([MIS.CD] In...

Is it possible to write vba in an access(or excel file) to or from Rumba? Or is there a forum for this? I couldn't find one. thx

I cannot get this Hyperlink/Vlookup to work. It will show the lookup value as a hyperlink, but when I click on it it says "Cannot open specified file." When I click the link on the source page it does open. Any suggestions on this? thx =HYPERLINK(VLOOKUP(C6,'Investor...

Any help on why this nested IIF statement isn't working properly? There aren't any errors. It just returns "Processing" for every field. I've checked spelling, etc. but no luck. Function: IIf([dbo_flat_wo]![status]="File Prep" Or "File Process" Or "File Received" Or "File Rev Miss/I" Or "File...

Is it possible to calculate how many business days have passed in an access calculate field, assuming there already is a start date in another field? I'm assuming the weekday function would be used, but not sure.

I have a field in a query that returns a value that has 10 digits(spaces). An example would be xxxxxyyyyy, or it would be xx yyyyyy. So it can be any combination of X, Y, or a space. Is it possible to split up each one of the digits/spaces into a separate field for each? I guess it would be...

Looking for some help on a pass through query in Access 2000. I'm not too familiar w/pass through queries and SQL. Basically I have a table that has too many fields to access which is why I need to use a pass through query. Which I've been able to set that up and run a basic query. Now can...

I have a form in access. Below is the original code I had in the form. It worked fine, but I have to change it now. I made what I thought where the correct changes but I'm getting an error. I've tried two different ways and am getting two different errors. Here is the original code that worked...

Does anyone if you can have vba in Access(or excel) write to a website? eg. Take data from say a form in Access and write it to particular form fields on a website. Or the same for Excel. If so can someone post an example or point me in the direction of how to start off on that? Thanks

I have a query that receives it's criteria from a form. The form has 2 text boxes which are for dates(start & end date). It also has 3 dropdown list boxes. 2 of the boxes have about 10 entries that are from a table, and one of the list box has 2 entries which are I put in manually. This...

I can't seem to figure out the sendkey for ctrl 5. I've tried the following and none work. Sess0.Screen.SendKeys ("{^5}") Sess0.Screen.SendKeys ("(^5)") Sess0.Screen.SendKeys ("^5") anyone able to post how to use the ctrl then 5 key? thx

I have the below code running in excel vba. What I want to do is run this into a access table. I'm not to familiar w/access vba. Basically how this is setup now is my excel sheet has it's required header rows already put in and then I run this macro to get data from Extra Mainframe to put in the...

I'm getting this error on this piece of code ws.Cells(x, 1) = acct_num What I'm trying to do it get data from a queue in Extra and put it into excel. I'm not taking anything from excel to start, just going through the queue and hit alt8 to move to the next account. I'm also not sure what loop...

I'm running this in excel. I can't seem to figure out what is wrong. I get a debug message at this line of code For x = 2 To Worksheet.UsedRange.Rows.Count Sub Main() Dim Sessions, System As Object, Sess0 As Object Set System = CreateObject("EXTRA.System") Set Sessions = System.Sessions Set...

I have an access database. I have a query that I run w/a button on a form in access. How can I have access run a macro in VBA to input some of the data into Attachmate from the query I run. I've seen people do it w/a form, but not a table from a query which is what I have. Here is some of the...

I'm trying to create a macro that puts a number into Extra at location 3,17 , enter is hit, the screen is displayed data. It then moves to location 5,13, pulls that field which is 10 characters long. And puts that field into excel in Column B, starting at Row 2 and going down. The original...

I'm wanting to pull a string of info from extra based on what I put into a macro. So for instance say I need to find a string that says "ABCDEFG12345 10/1/09". Is it possible to have the macro look for that string in the range of 10/20 thru 20/20 in extra?

Trying to make another macro with and excel file. Col A in excel will have days of the month(I'm using june) the days will start on row 3 and end at row 33. Col B in excel will be blank. In extra at 4,25 I will need to put the date from Col A, then move to 6,12 and put an "F" in there, hit...

I get the error "Illegal Redifintion of Set" it points to the second line. Sub Main Dim Sessions, System As Object, Sess0 As Object, Set System = CreateObject("EXTRA.System") Set Sessions = System.Sessions Set Sess0 = System.ActiveSession file = "E:\MonthlyNumbers.xls" Dim...

I have two .xls files, one has account numbers on it, can call it A.xls. The other has a bunch of fields set up almost like a sheet of paper that would be filled out, which is 2 pages long, but repeating for a couple hundred pages, which can be called B.xls. Is there a way to create a macro that...