Register
Help
Remember Me?
Forum
What's New?
Activity Stream
New Events
Mark Forums Read
Quick Links
Today's Posts
How to Post a Question
How to Mark Thread Solved
How to Attach Files
Advanced Search
Home
Activity Stream
AccessForums.net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please
join our community
, the registration is free and takes only one minute.
Activity Stream
Filter
Sort By
Time
Show
Recent
Recent
Popular
Popular
Anytime
Anytime
Last 7 Days
Last 7 Days
Last 30 Days
Last 30 Days
All
All
Photos
Photos
Forum
Forums
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
03:43 PM
pbaldy
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Post 34 was moderated, I'm posting to trigger email notifications.
see more
35 replies | 49303 view(s)
Today,
02:50 PM
EricRex
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
I think your message was superseded by recent events, but in the interface I implemented, you don't get to pick what fields are returned for...
see more
35 replies | 49303 view(s)
Today,
02:43 PM
EricRex
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Hey Welshgasman, Too me a while to figure out why I was getting reams of data. Your date format works too well in the US. Switched it to: Dim...
see more
35 replies | 49303 view(s)
Today,
12:41 PM
pbaldy
replied to a thread
Constraining combo boxes
in
Forms
Does this seem relevant? https://www.baldyweb.com/CascadingCombo.htm
see more
1 replies | 36 view(s)
Today,
12:26 PM
matey56
started a thread
Constraining combo boxes
in
Forms
Hello, I have 2 unbound combo boxes to select records. The first box is ID Number and the second box is Material. Once options are selected from...
see more
1 replies | 36 view(s)
Today,
11:45 AM
orange
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Eric, We need some specifics. It's been years since I looked at any of this and then only helping someone else. The YahooFinance interface has...
see more
35 replies | 49303 view(s)
Today,
09:29 AM
Welshgasman
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
I did not Colin, but then I already have a version on my PC. :) That is for currencies only though, is it not? I already have a stock ticker excel...
see more
35 replies | 49303 view(s)
Today,
09:21 AM
June7
replied to a thread
QrderBy both?
in
Queries
So values will always be only 1 or 2 characters? Custom VBA function is not needed. SELECT * FROM table ORDER BY Format(field, "00");
see more
3 replies | 95 view(s)
Today,
08:47 AM
pbaldy
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Post 30 was moderated, I'm posting to trigger email notifications.
see more
35 replies | 49303 view(s)
Today,
08:19 AM
EricRex
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Hey guys, Surprised that so many people jumped on this so fast. Also grateful for the good code mod's. I'm struggling with a couple of those...
see more
35 replies | 49303 view(s)
Today,
06:29 AM
isladogs
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Just out of interest, did anyone look at my live currency exchange ticker that I mentioned in post #15? I ask as nobody has mentioned it since.
see more
35 replies | 49303 view(s)
Today,
12:13 AM
Welshgasman
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Cards were before my time, but the disks were huge when I started. By the time I finished they were using standard hard drives, that we use today? ...
see more
35 replies | 49303 view(s)
Yesterday,
07:34 PM
Middlemarch
replied to a thread
QrderBy both?
in
Queries
The correct order is text sort, except when numbers. Yes, adding a leading "0" works. But a big change. You gave me an idea though and adding this...
see more
3 replies | 95 view(s)
Yesterday,
06:42 PM
June7
replied to a thread
QrderBy both?
in
Queries
Not without modifying the data. All these values are text and alpha sort rules apply. 10 will sort before 3, numbers before letters. What would be...
see more
3 replies | 95 view(s)
Yesterday,
06:22 PM
Middlemarch
started a thread
QrderBy both?
in
Queries
A string field may contain A1, A2, B2 etc or 1,2,3, 10, 11 Is there any way to Order these both correctly in the same query?
see more
3 replies | 95 view(s)
Yesterday,
04:20 PM
orange
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Dave, So true. And I did similar with PL/1, Fortran and others. I started work with gov't org in '72 and couldn't believe they ran production jobs...
see more
35 replies | 49303 view(s)
Yesterday,
03:43 PM
davegri
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Ya know how line numbers started? Way back when, computers required data input on punched cards. No video data input or editing. One card held one...
see more
35 replies | 49303 view(s)
Yesterday,
02:54 PM
orange
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Guys, Back from golf and looking at the thread. I modified table YHistQuoteParams to put the Symbol as the first record. This puts the Symbol...
see more
35 replies | 49303 view(s)
Yesterday,
02:16 PM
Thompyt
replied to a thread
Dig Sig blxes anchor
in
Programming
Below is the solved issue: Public Sub AddSigBoxes()Dim App As Object, AVdoc As Object, AForm As Object, Cnt As Integer, Y As Integer, X As Integer...
see more
1 replies | 113 view(s)
Yesterday,
12:27 PM
Welshgasman
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
You can also just use this for the timestamps Dim BeginDate As Long BeginDate = DateDiff("s", "1/1/1970 00:00:00", Me.txtStartDate)...
see more
35 replies | 49303 view(s)
Yesterday,
11:56 AM
CJ_London
replied to a thread
Creating Table from column data in another table.
in
Database Design
if I had to guess, I think the OP is trying to pivot the data tbl_updated_table: ID data1 data2 data3 data4 data5 data6 data7 if so - a poor...
see more
4 replies | 134 view(s)
Yesterday,
10:18 AM
Welshgasman
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
@EricRex Not sure if you are planning on using UK stocks, but they have a .L suffix, so GSK in the UK is GSK.L and the amount is in pennies (your...
see more
35 replies | 49303 view(s)
Yesterday,
10:06 AM
Welshgasman
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
I would use the same logic that you use for the Selections and then split it and loop for each value in the split? I would also prefer the ticker...
see more
35 replies | 49303 view(s)
Yesterday,
09:35 AM
Gicu
replied to a thread
Code to name specific printer
in
Access
For the button that saves the form (you really should change it to a report but that's another thing) look up Docmd.OutputTo:...
see more
2 replies | 107 view(s)
Yesterday,
09:19 AM
Welshgasman
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
I had only a short time to look at it, as I was going out again in the community van. I noticed that the dates were not taken into effect as well? ...
see more
35 replies | 49303 view(s)
Yesterday,
08:49 AM
orange
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
EricRex, Paul A little more testing; I added Symbol to the StockSymbolsT and this code in the processing logic Dim symbolSQL As String ...
see more
35 replies | 49303 view(s)
Yesterday,
08:47 AM
Bulzie
replied to a thread
Creating Table from column data in another table.
in
Database Design
Provide an example with sample data from your 2 tables and what you want it to do/look like. Hard to tell what it is exactly you are asking from...
see more
4 replies | 134 view(s)
Yesterday,
08:43 AM
davegri
replied to a thread
Need help with forms and reports--I've just forgotten what to do to connect them properly
in
Forms
Happy to help. It's a nice little DB.
see more
6 replies | 271 view(s)
Yesterday,
08:23 AM
DebP
replied to a thread
Need help with forms and reports--I've just forgotten what to do to connect them properly
in
Forms
OMG! Thank you so much, davegri!!! Technology is only a part of my job description so spending a lot of time was completely out of the...
see more
6 replies | 271 view(s)
Yesterday,
07:32 AM
orange
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Paul, EricRex I did some testing based on Paul(WelshGasman) comment. I tried various combinations and got similar error message. I then added GSK...
see more
35 replies | 49303 view(s)
More Activity
No More Results
No Recent Activity