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,
10:35 AM
Micron
replied to a thread
Querying two unrelated columns from two unrelated tables
in
SQL Server
When I see her, I see bacon.
see more
10 replies | 74 view(s)
Today,
10:22 AM
Soupy8728
replied to a thread
Structure for inventory with multiple allowances
in
Database Design
Yes, exactly. It could be 30 of C and 0 for D and E or 10 each....like that
see more
6 replies | 45 view(s)
Today,
10:16 AM
NoellaG
replied to a thread
Querying two unrelated columns from two unrelated tables
in
SQL Server
Miss Piggy looks very nice with lipstick
see more
10 replies | 74 view(s)
Today,
10:11 AM
Micron
replied to a thread
Change event and input masks
in
Programming
Not sure I follow completely. Once the text is entered, how is the button activated? If that is by clicking on it, you've just left the control/field...
see more
1 replies | 59 view(s)
Today,
10:07 AM
Bob Fitz
replied to a thread
Select Records by Most Recent Date
in
Queries
Can you post a copy of the db
see more
1 replies | 2 view(s)
Today,
10:05 AM
Micron
replied to a thread
Querying two unrelated columns from two unrelated tables
in
SQL Server
Likely it makes no sense because the samples are pseudo data and that just leads people down a rabbit hole. Any solution offered usually fails...
see more
10 replies | 74 view(s)
Today,
09:57 AM
Micron
replied to a thread
Access report records (lines) sequentially
in
Reports
Not possible. Once a report is generated, that's it. When February calculations are done, are the January ones done again? If so that's a monstrous...
see more
3 replies | 21 view(s)
Today,
09:54 AM
Grimjack
started a thread
Select Records by Most Recent Date
in
Queries
Hello, I am trying to get my query to select only those records with the most current date. The date spans 2 tables and they are linked. Below...
see more
1 replies | 2 view(s)
Today,
08:50 AM
Bulzie
replied to a thread
Access report records (lines) sequentially
in
Reports
Are you saying for each Month box, it could run through 204 calculations to get the value it needs? Or based on the registration say, it goes and...
see more
3 replies | 21 view(s)
Today,
08:30 AM
Soupy8728
replied to a thread
Structure for inventory with multiple allowances
in
Database Design
Yes, exactly. It could be 30 of C and 0 for D and E or 10 each....like that
see more
6 replies | 45 view(s)
Today,
08:27 AM
Welshgasman
replied to a thread
Access report records (lines) sequentially
in
Reports
You would use a form for that.
see more
3 replies | 21 view(s)
Today,
08:19 AM
DC CS
started a thread
Access report records (lines) sequentially
in
Reports
Hi, I have created an Access report where several lines are displayed. The report displays vehicles with their registration number and some other...
see more
3 replies | 21 view(s)
Today,
07:54 AM
Bob Fitz
replied to a thread
Structure for inventory with multiple allowances
in
Database Design
I think you may need to structure your tables differently. See attached
see more
6 replies | 45 view(s)
Today,
07:42 AM
Welshgasman
replied to a thread
Structure for inventory with multiple allowances
in
Database Design
I would write a function to do that. Function could have a Select Case For A & B just DLookup() as normal For anything else Process the...
see more
6 replies | 45 view(s)
Today,
07:40 AM
Bulzie
replied to a thread
Structure for inventory with multiple allowances
in
Database Design
So you are saying C,D,E can only have a combined limit of 30?
see more
6 replies | 45 view(s)
Today,
07:24 AM
madpiet
replied to a thread
Querying two unrelated columns from two unrelated tables
in
SQL Server
Are you trying to do something like assign a random part to each department? The only way I can think of doing it is to create a CTE for each so I...
see more
10 replies | 74 view(s)
Today,
07:19 AM
Minty
replied to a thread
Querying two unrelated columns from two unrelated tables
in
SQL Server
No not in a query. And as far as I can see it serves no useful purpose, just list the two tables next to each other.
see more
10 replies | 74 view(s)
Today,
07:19 AM
ranman256
replied to a thread
Structure for inventory with multiple allowances
in
Database Design
on the entry form , after every entry, lookup the limit sub form_AfterUPdate() iEntryCount = Dcount("*","tEntryTbl","='" & txtItem & "'")...
see more
6 replies | 45 view(s)
Today,
05:06 AM
NoellaG
replied to a thread
Querying two unrelated columns from two unrelated tables
in
SQL Server
Why should the paintbrush be in HR and not in Marketing or Facilities? If partID is de ID of table Parts, it should be different for each part? If...
see more
10 replies | 74 view(s)
Today,
04:16 AM
Welshgasman
replied to a thread
Saving a report with as filename the records out of the query
in
Modules
Not sure your recordset stntax is correct, I have never seen that before. As I always advise DEBUG.PRINT your variables and see what they are, not...
see more
1 replies | 37 view(s)
Today,
04:05 AM
Soupy8728
started a thread
Structure for inventory with multiple allowances
in
Database Design
Hello, I am trying to build an inventory database and I'm running into an issue that I'm not sure how to approach. We have different locations...
see more
6 replies | 45 view(s)
Today,
04:00 AM
huk250
started a thread
Saving a report with as filename the records out of the query
in
Modules
A good morning, I am looking for the following solution I have a tabelquery : "MCDQUERY" with the following columns : MCDNumber Country ...
see more
1 replies | 37 view(s)
Today,
01:26 AM
Lhoj
started a thread
Change event and input masks
in
Programming
I have some forms where there's a couple of text boxes that are required, so before enabling a button I want to check both are filled. The way I do...
see more
1 replies | 59 view(s)
Yesterday,
10:44 PM
June7
replied to a thread
Querying two unrelated columns from two unrelated tables
in
SQL Server
Okay, but why? What rule should be applied to cause these associations? What you want makes no sense. You show only 2 parts, not 5 and only 3...
see more
10 replies | 74 view(s)
Yesterday,
10:32 PM
hansdbase
replied to a thread
Querying two unrelated columns from two unrelated tables
in
SQL Server
PartID Part 1 Paint_Brush 1 Hammer
see more
10 replies | 74 view(s)
Yesterday,
10:30 PM
hansdbase
replied to a thread
Querying two unrelated columns from two unrelated tables
in
SQL Server
PartID Part 1 Paint_Brush 1 Hammer
see more
10 replies | 74 view(s)
Yesterday,
10:14 PM
June7
replied to a thread
Querying two unrelated columns from two unrelated tables
in
SQL Server
What do you mean by "corresponding value" - these tables do not have relationship so there is no "corresponding" anything. If you want only 5...
see more
10 replies | 74 view(s)
Yesterday,
09:32 PM
hansdbase
started a thread
Querying two unrelated columns from two unrelated tables
in
SQL Server
Suppose I have a table that has parts_no and parts_name with 5 parts totals. So 2 columns and 5 rows in other words. Parts_name is unique. And I...
see more
10 replies | 74 view(s)
Yesterday,
04:28 PM
Micron
replied to a thread
Old Access Database Conversion
in
Programming
I can say that it doesn't work from the immediate window, yet it is an intellisense option. Doesn't work as a code snippet either. M$ documentation...
see more
33 replies | 2108 view(s)
Yesterday,
04:16 PM
isladogs
replied to a thread
Old Access Database Conversion
in
Programming
I suggest you try this for yourself to answer the question. If you think it through, if db.Close did work then any subsequent code such as Set db =...
see more
33 replies | 2108 view(s)
More Activity
No More Results
No Recent Activity