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
Filter by:
Last 30 Days
Clear All
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
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
2 replies | 35 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
2 replies | 35 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
2 replies | 35 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
26 replies | 49118 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
26 replies | 49118 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
26 replies | 49118 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 | 92 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
26 replies | 49118 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 | 109 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
26 replies | 49118 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
26 replies | 49118 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 | 80 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
26 replies | 49118 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
26 replies | 49118 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 | 109 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 | 233 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 | 233 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
26 replies | 49118 view(s)
Yesterday,
07:16 AM
Micron
replied to a thread
Random records based off of number of records
in
Queries
We don't know what your experience level is with this and there isn't enough info to create anything. What are you expecting from us, exactly?...
see more
12 replies | 201 view(s)
Yesterday,
06:59 AM
Soupy8728
replied to a thread
Random records based off of number of records
in
Queries
Yes but that is beyond my capability. Thank you tho.
see more
12 replies | 201 view(s)
Yesterday,
06:26 AM
ranman256
replied to a thread
Code to name specific printer
in
Access
My users have 2 printers, i keep their default in a table: tPrinters IP, Printer when user clicks Print button, it sets it as default in case...
see more
2 replies | 80 view(s)
Yesterday,
06:13 AM
Welshgasman
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
AM I missing something here? The tbl is populated with values, but no ticker, so cannot relate to what was selected? ALso managed to get this...
see more
26 replies | 49118 view(s)
Yesterday,
06:03 AM
Welshgasman
replied to a thread
Random records based off of number of records
in
Queries
Not really random then? You would build your sql with the value coming from your source query as a recordset.
see more
12 replies | 201 view(s)
Yesterday,
05:57 AM
orange
replied to a thread
Random records based off of number of records
in
Queries
Soupy8728, Did you look at my sample random records and selection mentioned in post #3?
see more
12 replies | 201 view(s)
Yesterday,
05:45 AM
orange
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
EricRex, Looks good. Glad you are pursuing this demo/project. Please keep me updated as you proceed. Tried it just now:thumbsup:
see more
26 replies | 49118 view(s)
Yesterday,
05:37 AM
Soupy8728
replied to a thread
Random records based off of number of records
in
Queries
Thank you for your patience and your guidance. I was able to generate the random records part fairly easy but only with a hard code number such as...
see more
12 replies | 201 view(s)
Yesterday,
05:08 AM
Welshgasman
replied to a thread
Random records based off of number of records
in
Queries
Take it one step at a time. Break it down into small steps, and work on each in turn. I would start with Code to print random records with a...
see more
12 replies | 201 view(s)
Yesterday,
04:52 AM
steveo0707
started a thread
Code to name specific printer
in
Access
Hello, We use Access to track Non-Conforming products. We enter the information into a form and then print and save from a Printable Form. i...
see more
2 replies | 80 view(s)
Yesterday,
04:29 AM
Soupy8728
replied to a thread
Random records based off of number of records
in
Queries
Thank you but I'm not sure how to do that. I was hoping it would be a lot easier for my experience level. Hahaha...
see more
12 replies | 201 view(s)
Yesterday,
12:38 AM
ArviLaanemets
replied to a thread
Creating Table from column data in another table.
in
Database Design
I suspect this is the case of bad excel table structure applied to Access database!
see more
4 replies | 109 view(s)
More Activity
No More Results
No Recent Activity