Search results for query: *

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

Hi Nate16, Here is the way that I would do it. Make an unbound field on the form with the button called password. Disable the button on the form. Write some code in the After Update event of the unbound field something like this: If me.password = "Password" Then...

PICKLES, Do some research on the DLookup database function in Access help. You should be able to use this to accomplish your needs. Griz

scking, I think that you had the problem pinpointed. I created the database on a local drive and then moved it to a network drive. That must have resulted in the functions not working probably. Thank you all for your kind assistance. Griz

Hello All, I just got a freshly formatted computer, and for some reason this install of Access is not recognizing built in functions such as Date(), InStr(), etc? Any ideas as to why this might be happening? Any help would be appreciated. Thank you! Griz

Hello All I have a subform, and the AllowEdits property is currently set to False. The user needs to be able to create new records and fill in all the fields, but not change them after the record is saved. Ideally, I would want AllowEdits to be false for every field on the subform except one...