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,
08:53 AM
Micron
replied to a thread
Query to create report but need to use one field over another based on a toggle
in
Reports
Can you post a couple of records that illustrate the difference and identify the cases when one or the other should be chosen? If you know ahead of...
see more
4 replies | 11 view(s)
Today,
08:46 AM
pbDudley
replied to a thread
Query to create report but need to use one field over another based on a toggle
in
Reports
Ok, I made it sound too complicated with the background info. I can't upload the database. I have one query (that is used query design) that is tied...
see more
4 replies | 11 view(s)
Today,
08:36 AM
Micron
replied to a thread
One liner to find the position/index of a value in list box??
in
Access
A sql statement or query that returns a record with the SN value? Of course, the record would also need a field that returns the unique line number...
see more
1 replies | 31 view(s)
Today,
08:30 AM
Micron
replied to a thread
Query to create report but need to use one field over another based on a toggle
in
Reports
Not sure I understand (terms like "in-house" don't mean anything to me/us). If the source table does not have a fixed numeric record ID (e.g....
see more
4 replies | 11 view(s)
Today,
08:28 AM
Welshgasman
replied to a thread
Query to create report but need to use one field over another based on a toggle
in
Reports
You would need to show us the report code? Or the query that is the source for the report?
see more
4 replies | 11 view(s)
Today,
08:21 AM
pbDudley
started a thread
Query to create report but need to use one field over another based on a toggle
in
Reports
Hello I have a form where users must enter parameters. Some of the parameters are stored in our in-house tables as well and aren’t editable from my...
see more
4 replies | 11 view(s)
Today,
08:00 AM
TOPSie
replied to a thread
Sending emails from Access VBA
in
Programming
Thanks to you and Philipp I can now successfully send emails from Access using a Gmail account. But there a couple of tweaks I would like to make....
see more
8 replies | 981 view(s)
Today,
07:02 AM
JB510
started a thread
One liner to find the position/index of a value in list box??
in
Access
I have a list of 400 or more serial numbers in a list box called Listbox1. I have a source SerialNumberToFind with a value in it. I want a...
see more
1 replies | 31 view(s)
Today,
05:32 AM
Welshgasman
replied to a thread
Colours on a report
in
Reports
Hmm, strange :( Well done for finding a solution. :thumbsup:
see more
6 replies | 55 view(s)
Today,
05:14 AM
DC CS
replied to a thread
Colours on a report
in
Reports
Hi, It seems the solution is to NOT use labels on the report. I replaced the labels with text boxes and now the ones that need to be a different...
see more
6 replies | 55 view(s)
Today,
05:03 AM
A S MANN
replied to a thread
Colours on a report
in
Reports
If you run code in On load event than it will run partially Place code in On Format of report .
see more
6 replies | 55 view(s)
Today,
04:46 AM
Welshgasman
replied to a thread
Colours on a report
in
Reports
Out of ideas then, sorry. You could post the DB with enough to see the problem. I work best like that for silly stuff. :) By that, I mean stuff...
see more
6 replies | 55 view(s)
Today,
04:43 AM
A S MANN
replied to a thread
Constraining combo boxes
in
Forms
Prepare a query and filter it by Forms!! Use this query as record source of Material field of form. Select after update as Requery so when a ID is...
see more
2 replies | 76 view(s)
Today,
04:40 AM
DC CS
replied to a thread
Colours on a report
in
Reports
Hi Welshgasman, Yes, the code is within a For...Next loop. Label captions are named Label1, Label2...Label12 I did step through the code with F8...
see more
6 replies | 55 view(s)
Today,
04:29 AM
Welshgasman
replied to a thread
Colours on a report
in
Reports
Not showing much code there are you? :( Is that code within a loop incrementing i ? Are the labels all called Label1, Label2 etc? Walk your...
see more
6 replies | 55 view(s)
Today,
03:51 AM
DC CS
started a thread
Colours on a report
in
Reports
I have a report with some data and is bound to a query. The report consists of the months and some calculated values under each month. The month...
see more
6 replies | 55 view(s)
Today,
02:19 AM
Welshgasman
replied to a thread
QrderBy both?
in
Queries
Format returns a string, so 199 will always come before 21 if sorted ascending.
see more
5 replies | 147 view(s)
Today,
01:04 AM
Welshgasman
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
I upgraded to Dim BeginDate As Long BeginDate = DateDiff("s", "1/1/1970 00:00:00", Me.txtStartDate) 'CDate(Format(Me.txtStartDate,...
see more
41 replies | 49453 view(s)
Yesterday,
07:49 PM
EricRex
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Hey all, After some more testing, I found that none of the intraday timeframes work as expected. They all return a 404 error from the HTTP...
see more
41 replies | 49453 view(s)
Yesterday,
07:28 PM
EricRex
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Hey there, Not sure if this is a better link than the previous one, but FYI: https://cryptocointracker.com/yahoo-finance/yahoo-finance-api ...
see more
41 replies | 49453 view(s)
Yesterday,
05:37 PM
Middlemarch
replied to a thread
QrderBy both?
in
Queries
It's always good to see someone else's approach. I tried ?format(199,"00") in the immediate window and it printed 199. I tested in the table and...
see more
5 replies | 147 view(s)
Yesterday,
05:08 PM
pbaldy
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Post 38 was moderated, I'm posting to trigger email notifications.
see more
41 replies | 49453 view(s)
Yesterday,
05:03 PM
EricRex
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
That link was included in Post #30. Here it is again for convenience. https://stackoverflow.com/questions/44030983/yahoo-finance-url-not-working...
see more
41 replies | 49453 view(s)
Yesterday,
04:47 PM
orange
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
Eric, You don't necessarily need a different table for different Symbols or extractions. If your requirement is to have all the fields you have...
see more
41 replies | 49453 view(s)
Yesterday,
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
41 replies | 49453 view(s)
Yesterday,
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
41 replies | 49453 view(s)
Yesterday,
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
41 replies | 49453 view(s)
Yesterday,
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
2 replies | 76 view(s)
Yesterday,
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
2 replies | 76 view(s)
Yesterday,
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
41 replies | 49453 view(s)
More Activity
No More Results
No Recent Activity