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
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
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.