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,
11:56 AM
CJ_London
replied to a thread
Is MAX Case sensitive?
in
Access
would have thought SELECT myTable.myItem, Max(myTable.myDate) AS MaxOfMyDate FROM myTable WHERE myTable.myFlag LIKE "L" GROUP BY ...
see more
9 replies | 42 view(s)
Today,
11:51 AM
TOPSie
replied to a thread
Is MAX Case sensitive?
in
Access
This works. So THANK YOU - but still bemused as to the results when I use LIKE or just = A mystgery for another day :-)
see more
9 replies | 42 view(s)
Today,
11:44 AM
TOPSie
replied to a thread
Is MAX Case sensitive?
in
Access
I think this is the point I want it to find all the items with a Flas of "L" then select the record form these items which has the latest date. But...
see more
9 replies | 42 view(s)
Today,
11:43 AM
Micron
replied to a thread
Is MAX Case sensitive?
in
Access
I think what you need is HAVING StrComp("L",myTable.myFlag,0)=0
see more
9 replies | 42 view(s)
Today,
11:32 AM
Micron
replied to a thread
Is MAX Case sensitive?
in
Access
I don't see how Max is relevant for L vs l. You're using Max on a date field, not the flag field.
see more
9 replies | 42 view(s)
Today,
10:47 AM
TOPSie
replied to a thread
Is MAX Case sensitive?
in
Access
SELECT myTable.myItem, mytable.myFlag, myTable.Comment, Max(myTable.myDate) AS MaxOfMyDate FROM myTable GROUP BY myTable.myItem, myTable.myFlag,...
see more
9 replies | 42 view(s)
Today,
10:31 AM
davegri
replied to a thread
Changes in form lead to wrong Changes in table
in
Access
Design problem. If you try and add a record, the form will force you to input a new salutation which will ADD a record to tabAnrede: To fix...
see more
8 replies | 177 view(s)
Today,
10:19 AM
Minty
replied to a thread
Is MAX Case sensitive?
in
Access
Just post up the real SQL. We will be guessing without seeing it.
see more
9 replies | 42 view(s)
Today,
09:46 AM
TOPSie
replied to a thread
Is MAX Case sensitive?
in
Access
I was trying to paraphrase the syntax - the real query is much more complicated - so I was just trying to pick out the essence of the issue - so a...
see more
9 replies | 42 view(s)
Today,
08:57 AM
CJ_London
replied to a thread
Is MAX Case sensitive?
in
Access
weird sql syntax - please specify what database you are using that uses that syntax or provide your actual sql. But my guess would be you have other...
see more
9 replies | 42 view(s)
Today,
08:54 AM
TOPSie
started a thread
Is MAX Case sensitive?
in
Access
I have a table with 3 fields is single character. I am trying to write a query to extract the latest an had a containing the letter L...
see more
9 replies | 42 view(s)
Today,
08:53 AM
CJ_London
replied to a thread
Changes in form lead to wrong Changes in table
in
Access
Think you mean 'AnredeText, second field from the bottom. It doesn't for me. tabKunden has the new value for Anrede_FK What I find confusing is...
see more
8 replies | 177 view(s)
Today,
08:30 AM
CJ_London
replied to a thread
OneDrive Question
in
Access
I would also point out that users should not have direct access to the tables, linked or otherwise
see more
3 replies | 85 view(s)
Today,
07:22 AM
moke123
replied to a thread
Create multiple predefined records in 2nd table onClick based upon values in a 3rd table
in
Programming
Might be easier if you upload a sample with just enough info to show your issue.
see more
4 replies | 49 view(s)
Today,
06:10 AM
Welshgasman
replied to a thread
Create multiple predefined records in 2nd table onClick based upon values in a 3rd table
in
Programming
I would be building the query in vba and a loop for as many records as required. You would populate the fields with your userid and whatever else...
see more
4 replies | 49 view(s)
Today,
05:25 AM
moke123
replied to a thread
Changes in form lead to wrong Changes in table
in
Access
You may want to re-think formatting your PK in the table. If need be, do the formatting in the form for display. Your PK should be...
see more
8 replies | 177 view(s)
Today,
04:45 AM
spikemannen
replied to a thread
Create multiple predefined records in 2nd table onClick based upon values in a 3rd table
in
Programming
Yes, but how do I define in that query that I want a different matchID for each of the ten records? (and not knowing it is ten)
see more
4 replies | 49 view(s)
Today,
04:37 AM
mike60smart
replied to a thread
Changes in form lead to wrong Changes in table
in
Access
Hi Wgm Here is the file that was in Dropbox.
see more
8 replies | 177 view(s)
Today,
04:35 AM
Welshgasman
replied to a thread
Create multiple predefined records in 2nd table onClick based upon values in a 3rd table
in
Programming
Use an append query.
see more
4 replies | 49 view(s)
Today,
04:34 AM
Welshgasman
replied to a thread
Changes in form lead to wrong Changes in table
in
Access
If you now have a small file you can upload it here?
see more
8 replies | 177 view(s)
Today,
03:53 AM
spikemannen
started a thread
Create multiple predefined records in 2nd table onClick based upon values in a 3rd table
in
Programming
Hi, I have a bit of struggle figuring out how to (in an easy way) create multiple records in a 2nd table when user click on a button in a form...
see more
4 replies | 49 view(s)
Today,
03:01 AM
Crewmate
replied to a thread
Changes in form lead to wrong Changes in table
in
Access
I did what I should have done in the first place and created a small mock-file with only the necessary parts. Sorry that my sleep-deprived brain...
see more
8 replies | 177 view(s)
Today,
02:22 AM
Crewmate
replied to a thread
Changes in form lead to wrong Changes in table
in
Access
Hi davegri, thank you so much for taking a look at my mess. In the beginning I didn't know about naming schemes and regret not having learned to...
see more
8 replies | 177 view(s)
Yesterday,
08:59 PM
Micron
replied to a thread
OneDrive Question
in
Access
Agreed. Plus, backups have nothing to do with FE table linking. If you have an FE/BE setup and the BE is on a server on a LAN that is A-OK. But...
see more
3 replies | 85 view(s)
Yesterday,
06:47 PM
Micron
replied to a thread
How to use a button to calcualte 2 fields then store new value in another table
in
Forms
I said as much in post 9 :banghead:
see more
17 replies | 286 view(s)
Yesterday,
06:30 PM
davegri
replied to a thread
OneDrive Question
in
Access
As the developer, why is this your problem? Client is responsible for configuring and maintaining their system.
see more
3 replies | 85 view(s)
Yesterday,
05:10 PM
TedS
started a thread
OneDrive Question
in
Access
Can anyone point me toward a good source for configuring OneDrive? Looking for design configuration strategies related to eliminating OneDrive...
see more
3 replies | 85 view(s)
Yesterday,
01:24 PM
pbDudley
replied to a thread
How to use a button to calcualte 2 fields then store new value in another table
in
Forms
"Either run UPDATE action SQL or in form BeforeUpdate event, set field to calculated value." Thats the method I was thinking about. thank you....
see more
17 replies | 286 view(s)
Yesterday,
11:39 AM
June7
replied to a thread
How to use a button to calcualte 2 fields then store new value in another table
in
Forms
Either run UPDATE action SQL or in form BeforeUpdate event, set field to calculated value.
see more
17 replies | 286 view(s)
Yesterday,
11:26 AM
pbDudley
replied to a thread
How to use a button to calcualte 2 fields then store new value in another table
in
Forms
Well, I'm just using an example. I don't particularly know what would help if I told you what I need this done for, that is subtract 2 fields in 2...
see more
17 replies | 286 view(s)
More Activity
No More Results
No Recent Activity