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
Clear All
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
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
5 replies | 58 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 | 19 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
0 replies | 19 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 | 19 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
0 replies | 39 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
5 replies | 58 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
5 replies | 58 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
5 replies | 58 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
5 replies | 58 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
5 replies | 58 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 | 2106 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 | 2106 view(s)
Yesterday,
04:13 PM
Micron
replied to a thread
Old Access Database Conversion
in
Programming
I have never done so because to me, that would imply that I want to close the current db. Probably not a good idea if you could.
see more
33 replies | 2106 view(s)
Yesterday,
03:47 PM
CJ_London
replied to a thread
Strange Query Design Grid Behavior
in
Queries
You could just order by is not null
see more
9 replies | 138 view(s)
Yesterday,
03:29 PM
Welshgasman
replied to a thread
Old Access Database Conversion
in
Programming
I have never ever used db.close? Does it exist?, if so feel free to use it, instead of nitpicking. :(
see more
33 replies | 2106 view(s)
Yesterday,
02:16 PM
gr8dane
replied to a thread
Strange Query Design Grid Behavior
in
Queries
There doesn't seem to be a problem with using the word as an alias. Only with using it later in the SQL. I don't understand it either. It's...
see more
9 replies | 138 view(s)
Yesterday,
02:08 PM
Cosimo
replied to a thread
Old Access Database Conversion
in
Programming
In your example, shouldn't db.close also be included before doing db = nothing?
see more
33 replies | 2106 view(s)
Yesterday,
01:55 PM
Bulzie
replied to a thread
Get RGB colour
in
Access
This is another site I have used for colors https://www.endprod.com/colors/
see more
21 replies | 710 view(s)
Yesterday,
01:00 PM
bubly1322
replied to a thread
Enforce referential integrity
in
Database Design
I was able to do relationships between tables and do enforce referential integrity. Thanks for any advice!
see more
17 replies | 350 view(s)
Yesterday,
12:01 PM
Welshgasman
replied to a thread
Saving Form
in
Forms
Not sarcasm, genuine dissapointment. :( I gave you the links. perhaps have the courtesy of looking at them? They will solve this particular problem...
see more
6 replies | 79 view(s)
Yesterday,
11:58 AM
Welshgasman
replied to a thread
Strange Query Design Grid Behavior
in
Queries
In fact Access reports take no notice of any external order in the first place, so if a report it HAS to be done in the report.
see more
9 replies | 138 view(s)
Yesterday,
11:51 AM
Bulzie
replied to a thread
Strange Query Design Grid Behavior
in
Queries
Not sure why happens, just delete the duplicate and just have the 1 field with the sort on it. If this is a report, can set the sort in the report.
see more
9 replies | 138 view(s)
Yesterday,
11:48 AM
Bulzie
replied to a thread
Saving Form
in
Forms
You can create a report to minic the form(copy the fields over if needed) and for the RecordSource of the report, make it a query where you only show...
see more
6 replies | 79 view(s)
Yesterday,
11:43 AM
Erichss
replied to a thread
Saving Form
in
Forms
Does no one answer a question for somebody who has VERY LITTLE Access experience without sarcasm anymore.
see more
6 replies | 79 view(s)
Yesterday,
11:20 AM
Welshgasman
replied to a thread
Saving Form
in
Forms
Does no one do any research anymore? :( Why not look at the syntax of the OpenReport command? ...
see more
6 replies | 79 view(s)
Yesterday,
11:17 AM
Erichss
replied to a thread
Saving Form
in
Forms
When I tried it that way, it pulling the entire table and not just the single record.
see more
6 replies | 79 view(s)
Yesterday,
11:06 AM
ranman256
replied to a thread
Saving Form
in
Forms
you should really save a report, instead of the form.
see more
6 replies | 79 view(s)
Yesterday,
10:31 AM
Erichss
started a thread
Saving Form
in
Forms
I have a form that is used to enter in data. The filled out form get saved as a PDF when the record gets saved, but the issue it the form has an...
see more
6 replies | 79 view(s)
Yesterday,
09:47 AM
Micron
replied to a thread
Enforce referential integrity
in
Database Design
Well then, this makes no sense especially if "new" is really "now", but OK. Thanks.
see more
17 replies | 350 view(s)
Yesterday,
09:39 AM
June7
replied to a thread
Enforce referential integrity
in
Database Design
Micron, tblCommunityConsensus was in the original schema and replaced by tblCommunities.
see more
17 replies | 350 view(s)
More Activity
No More Results
No Recent Activity