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:
Forums
Last 30 Days
Clear All
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
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
23 replies | 49064 view(s)
Today,
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 | 81 view(s)
Today,
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
23 replies | 49064 view(s)
Today,
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
23 replies | 49064 view(s)
Today,
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 | 65 view(s)
Today,
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
23 replies | 49064 view(s)
Today,
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
23 replies | 49064 view(s)
Today,
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 | 81 view(s)
Today,
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 | 213 view(s)
Today,
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 | 213 view(s)
Today,
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
23 replies | 49064 view(s)
Today,
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 | 165 view(s)
Today,
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 | 165 view(s)
Today,
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 | 65 view(s)
Today,
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
23 replies | 49064 view(s)
Today,
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 | 165 view(s)
Today,
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 | 165 view(s)
Today,
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
23 replies | 49064 view(s)
Today,
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 | 165 view(s)
Today,
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 | 165 view(s)
Today,
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 | 65 view(s)
Today,
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 | 165 view(s)
Today,
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 | 81 view(s)
Yesterday,
09:35 PM
EricRex
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
This modified version of the original project gets Date, Open, High, Low, Close, Adjusted Close, and Volume for a fixed date range set in Private Sub...
see more
23 replies | 49064 view(s)
Yesterday,
08:21 PM
ano
replied to a thread
datasheet font set in module
in
Modules
Option Compare DatabaseOption Explicit Public Sub clm(frm1 As Form, Optional fst As Boolean) Dim ctl As Control Dim frms As Variant Dim frm...
see more
16 replies | 616 view(s)
Yesterday,
04:41 PM
davegri
replied to a thread
Need help with forms and reports--I've just forgotten what to do to connect them properly
in
Forms
See if this helps. Your subform recordsource was a non updatable query (with Data Entry = Yes). I simplified the junction table. It's primary key...
see more
6 replies | 213 view(s)
Yesterday,
04:29 PM
madpiet
replied to a thread
Creating Table from column data in another table.
in
Database Design
What problem are you trying to solve? Sure you could create a query that returns the data you want (from the source table) and then subtract (well,...
see more
4 replies | 81 view(s)
Yesterday,
04:18 PM
Clifford86
started a thread
Creating Table from column data in another table.
in
Database Design
Hello, Is it at all possible to have Access take data from one table's column and use the data in a new table as its columns based on the data...
see more
4 replies | 81 view(s)
Yesterday,
03:37 PM
Micron
replied to a thread
Random records based off of number of records
in
Queries
I say 1 loop for department only. Calculate the number of records per dept and use that in a Select query statement with Top N predicate (sub query).
see more
12 replies | 165 view(s)
Yesterday,
03:23 PM
Thompyt
started a thread
Dig Sig blxes anchor
in
Programming
All, Since I have completed the other thread, I have found an additional issue. In this document the sig blocks are correctly placed: If I...
see more
0 replies | 64 view(s)
More Activity
No More Results
No Recent Activity