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 7 Days
Clear All
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
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
19 replies | 49024 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
3 replies | 57 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 | 194 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 | 194 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
19 replies | 49024 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 | 142 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 | 142 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
1 replies | 45 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
19 replies | 49024 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 | 142 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 | 142 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
19 replies | 49024 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 | 142 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 | 142 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
1 replies | 45 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 | 142 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
3 replies | 57 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
19 replies | 49024 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 | 602 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 | 194 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
3 replies | 57 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
3 replies | 57 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 | 142 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 | 56 view(s)
Yesterday,
02:26 PM
DebP
replied to a thread
Need help with forms and reports--I've just forgotten what to do to connect them properly
in
Forms
So sorry! I'm only at this job M-Thurs, so I was not been able to answer you quickly. I've zipped my database and attached (I think). I'm...
see more
6 replies | 194 view(s)
Yesterday,
02:10 PM
Bulzie
replied to a thread
Two BE, one with data and the other to save the data
in
Security
That will be a nightmare to make sure you have the new records saved to BE2. Plus what happens when both get filled up, you create a BE3? As other...
see more
3 replies | 92 view(s)
Yesterday,
01:40 PM
Bulzie
replied to a thread
Random records based off of number of records
in
Queries
Just thinking of the looping, you will need to do 2 loops, one for the Depts and one for the number of records for each Dept. Once you know the...
see more
12 replies | 142 view(s)
Yesterday,
01:05 PM
June7
replied to a thread
Two BE, one with data and the other to save the data
in
Security
You have hit 2GB limit in backend? Even after Compact & Repair? SQLServer Express has 10GB limit and is free. MySQL (an Oracle product) is...
see more
3 replies | 92 view(s)
Yesterday,
12:56 PM
orange
replied to a thread
Two BE, one with data and the other to save the data
in
Security
Mylton, a)What exactly is your concern? b)What exactly is the purpose and content of BE2? c)Have you considered a BACKUP STRATEGY...
see more
3 replies | 92 view(s)
Yesterday,
12:19 PM
Mylton
started a thread
Two BE, one with data and the other to save the data
in
Security
Good afternoon I would like to clarify a doubt. If I have an App with BE and FE. Where the tables are in BE. However, the information takes up...
see more
3 replies | 92 view(s)
More Activity
No More Results
No Recent Activity