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,
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
4 replies | 35 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
4 replies | 35 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
4 replies | 35 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
7 replies | 71 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
7 replies | 71 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
4 replies | 35 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
7 replies | 71 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 | 34 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
4 replies | 35 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 | 34 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 | 49 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
7 replies | 71 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
7 replies | 71 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
7 replies | 71 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
7 replies | 71 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
7 replies | 71 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)
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 | 2108 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 | 143 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 | 2108 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 | 143 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 | 2108 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 | 717 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 | 352 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 | 82 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 | 143 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 | 143 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 | 82 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 | 82 view(s)
More Activity
No More Results
No Recent Activity