Recent content by griswom

crobg, Haven't been able to find a good overall reference. I just pieced my code together from examples I found on Google. Sorry I can't be of more help. Griz

crobg, Thanks for the advice. Sorry for the belated reply. Here is the code I ended up using in case anyone else needs this. It requires the XML 5.0 library: Function XMLPrice(sSecurity As String) Dim xml As XMLHTTP Dim sURL As String Dim sResponse As String Dim sQuote As String Set xml =...

I would like to be able to connect to a URL in access and store the response in a variable to display on a report. I use this code in Excel: With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://finance.yahoo.com/d/quotes.csv?f=l1&s=" & [A3], _ Destination:=Range("p32"))...

By the way... Test this on one specific record before you run it on all of them. I would hate for there to be some extra spaces in the field length that threw everything off or something... HTH, Griz

Hi tav1035, I have been down this road.... Design an update query. Bring down the Date_Received column. In the update field, enter this string... Mid([Date_Received],5,2) & "/" & Right([Date_Received],2) & "/" & Mid([Date_Received],3,2) This should accomplish your...

JBG, I'm not sure if this applies in Access 97, but in Access 2000 you could do docmd.printout acSelection and that would give you only what is active at the time. HTH, Griz

Yes... That is why you are selecting Indexed(Duplicates OK). Griz

Sabavno, This can be done easily. Go into design view on your table, and select the last name field. In the bottom left corner of the screen will be a row that says "Indexed". Change this to Yes (Duplicates OK), and save your table. HTH, Griz

xq, try this when you declare the rs variable dim rs as DAO.recordset that should fix the problem I believe. HTH, Griz

Hi SteveCarrier and buddyel, Ok to link an Excel spreadsheet, go to the tables tab in your database, right click in a blank area, and select link tables. At the bottom under "Files of type" change to Excel Spreadsheet. Then locate your spreadsheet, highlight it, and select link. At...

Steve, Link the spreadsheet into your database. This will allow you to treat it like any other table. You can then search for the values that you need and transfer them to your Access tables. HTH, Griz

Jucius, Thanks for the tip. I'll give that a shot. Griz

Hi All... Is there any way to tell which form just lost the focus? I have a field on a form that I would like to populate with a value from the form that preceeded it, but that form could be one of a few different forms. Any ideas? Thanks in advance! Griz

Crystalguru, As for the slow speed, it probably has to do with the "Perform name Autocorrect" bug. Go to Tools, Options, General tab on your database, and make sure that this is unchecked. Secondly, does your database use any "Make Table" queries? If these are run...

Nate, Open the properties of the unbound password field. On the data tab under input mask, type "PASSWORD". This will make asterisks appear in the field instead of the letters typed. HTH, Griz