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: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
3 replies | 4 view(s)
Today,
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
3 replies | 4 view(s)
Today,
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
3 replies | 4 view(s)
Today,
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
3 replies | 4 view(s)
Today,
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 | 2034 view(s)
Today,
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 | 2034 view(s)
Today,
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 | 2034 view(s)
Today,
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 | 106 view(s)
Today,
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 | 2034 view(s)
Today,
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 | 106 view(s)
Today,
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 | 2034 view(s)
Today,
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 | 670 view(s)
Today,
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 | 314 view(s)
Today,
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 | 53 view(s)
Today,
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 | 106 view(s)
Today,
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 | 106 view(s)
Today,
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 | 53 view(s)
Today,
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 | 53 view(s)
Today,
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 | 53 view(s)
Today,
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 | 53 view(s)
Today,
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 | 53 view(s)
Today,
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 | 53 view(s)
Today,
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 | 314 view(s)
Today,
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 | 314 view(s)
Today,
08:59 AM
cheloto
started a thread
Empty Field (Fieldname only) in .xml file
in
Access
I want to create an .xml fie with commands Header start stop from a Tabel Difficult to explain, but maybe someone understand - I want this .xml...
see more
0 replies | 49 view(s)
Today,
06:56 AM
Micron
replied to a thread
Strange Query Design Grid Behavior
in
Queries
I took it that as a calculated field you have created would not conflict with the word "order" in the ORDER BY clause. However, I just reviewed my...
see more
9 replies | 106 view(s)
Today,
06:23 AM
gr8dane
replied to a thread
Strange Query Design Grid Behavior
in
Queries
First, because the SQL is Access-generated. Secondly, because I read that Access doesn't allow that. I tried it out, though, and it resulted in...
see more
9 replies | 106 view(s)
Today,
06:17 AM
steveo0707
replied to a thread
Eliminate extra background
in
Access
Hello, Yes, they are tabbed. I'm not sure everyone that works here will be able to handle overlapping. I will just leave it the way it is, so I...
see more
5 replies | 226 view(s)
Today,
05:58 AM
Micron
replied to a thread
Strange Query Design Grid Behavior
in
Queries
You already created a calculated field for Order; why not use it? ORDER BY , tblTestTasks.DateDue, tblTestTasks.PriorityID; That is probably...
see more
9 replies | 106 view(s)
Today,
05:41 AM
gr8dane
replied to a thread
Strange Query Design Grid Behavior
in
Queries
SELECT tblTestTasks.Task, tblPriorities.Priority, tblPriorities.PriorityRGB, tblTestTasks.DateDue, tblTestTasks.PriorityID, tblTestTasks.ProjectID,...
see more
9 replies | 106 view(s)
More Activity
No More Results
No Recent Activity