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:
Last 7 Days
Clear All
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
10:32 AM
Khalil Handal
replied to a thread
Count number of student in specific school year
in
Queries
Hi, Yes: A student might be enrolled in a school year but not in a different school year. To be more clear in relation to the above quote about...
see more
9 replies | 151 view(s)
Today,
05:05 AM
ArviLaanemets
replied to a thread
Count number of student in specific school year
in
Queries
... The school year is actually defined as 2020-2021 and can be selected from a combo box. I Added a field CurrentStudent a Yes/No field for table...
see more
9 replies | 151 view(s)
Today,
02:37 AM
Khalil Handal
replied to a thread
Count number of student in specific school year
in
Queries
Hi, The school year is actually defined as 2020-2021 and can be selected from a combo box. I Added a field CurrentStudent a Yes/No field for table...
see more
9 replies | 151 view(s)
Today,
01:56 AM
Welshgasman
replied to a thread
Access App color settings
in
Access
Why not post the solution. Someone else might have this issue in the future and a search could find the solution. These forums are here to help...
see more
2 replies | 65 view(s)
Today,
01:52 AM
Welshgasman
replied to a thread
Count number of student in specific school year
in
Queries
If you havce a field that actually defines the school year and perhaps term, like 2021 and 1, then just look for that field being 2021. If you wanted...
see more
9 replies | 151 view(s)
Yesterday,
11:23 PM
Khalil Handal
replied to a thread
Count number of student in specific school year
in
Queries
Hi, I defined my school year and I am doing some progress. I will keep all of you posted. Thank you
see more
9 replies | 151 view(s)
Yesterday,
09:34 PM
Salty Mariner
replied to a thread
Assistance with a Function
in
Programming
This .FindFirst ("LegNo = " & Me.LegNo + 1) and If Not .NoMatch Then strNextLat = ! worked like a charm!
see more
2 replies | 55 view(s)
Yesterday,
09:05 PM
June7
replied to a thread
Assistance with a Function
in
Programming
The last record is not EOF. So, code attempts to pull from next record which does not exist. Not sure Nz() is needed. .FindFirst ("LegNo = " &...
see more
2 replies | 55 view(s)
Yesterday,
08:49 PM
Salty Mariner
started a thread
Assistance with a Function
in
Programming
I have a Function (actually two similar ones) that are not giving me the desired results. Here is the code: Private Function GetNextLat() Dim...
see more
2 replies | 55 view(s)
Yesterday,
08:12 PM
Micron
replied to a thread
Access App color settings
in
Access
Probably good enough if you just mark it as solved (Thread Tools above your post header).
see more
2 replies | 65 view(s)
Yesterday,
06:22 PM
Cosimo
started a thread
Access App color settings
in
Access
Sorry. I just figured out how to change the colors of the App window itself. But now I can't figure out how to delete this post!
see more
2 replies | 65 view(s)
Yesterday,
11:18 AM
June7
replied to a thread
Random excessive vertical spacing in report
in
Reports
Accidentally duplicated post.
see more
2 replies | 78 view(s)
Yesterday,
10:24 AM
June7
replied to a thread
Random excessive vertical spacing in report
in
Reports
Can you provide db for analysis? Follow instructions at bottom of my post.
see more
2 replies | 78 view(s)
Yesterday,
10:23 AM
lkyinc
started a thread
Random excessive vertical spacing in report
in
Reports
I have 18 groups in my report. Anywhere between 1 and 9 recrds in each group. Display only once for those that are similar. For those groups with...
see more
2 replies | 78 view(s)
Yesterday,
10:06 AM
Welshgasman
replied to a thread
Hide a form
in
Forms
Yes, and I just used intellisense, as I do not know what goes where. :(
see more
3 replies | 106 view(s)
Yesterday,
07:48 AM
Bob Fitz
replied to a thread
Hide a form
in
Forms
In case you haven't noticed, you have four commas in the following line but Welshgasman has five commas. DoCmd.OpenForm "Frm_DetectIdleTime", , , ,...
see more
3 replies | 106 view(s)
Yesterday,
07:17 AM
Welshgasman
replied to a thread
Hide a form
in
Forms
This is what I get from intellisense in the immediate window? docmd.OpenForm "Form1",,,,,acHidden acSaveNo is only if the form was opened in...
see more
3 replies | 106 view(s)
Yesterday,
05:48 AM
DC CS
started a thread
Hide a form
in
Forms
I have a form that detects idle time. This was adapted from a forum. The code when logging into the database, as follows: DoCmd.Close...
see more
3 replies | 106 view(s)
Yesterday,
05:44 AM
Welshgasman
replied to a thread
Count number of student in specific school year
in
Queries
However you define your school year?
see more
9 replies | 151 view(s)
Yesterday,
05:36 AM
orange
replied to a thread
Count number of student in specific school year
in
Queries
How about providing sample data in your table(s) and any queries you have tried?
see more
9 replies | 151 view(s)
Yesterday,
05:27 AM
Khalil Handal
replied to a thread
Count number of student in specific school year
in
Queries
Hi, I Think no. What criteria should I use? Khalil
see more
9 replies | 151 view(s)
Yesterday,
04:52 AM
Welshgasman
replied to a thread
Importing Excel into Access
in
Import/Export Data
When you are repeating code, generally there is a better way. DoCmd.TransferSpreadsheet acImport, 10, WKS.Name, filePath & fileName, True
see more
5 replies | 305 view(s)
Yesterday,
04:45 AM
Welshgasman
replied to a thread
Count number of student in specific school year
in
Queries
Then date does not come into it, does it?
see more
9 replies | 151 view(s)
Yesterday,
04:35 AM
ano
replied to a thread
datasheet font set in module
in
Modules
thnx for explaining yep guess its equivalent but not visible even no errors because i neede form1a,form1b,form1c other fonts , form1 is just...
see more
4 replies | 146 view(s)
Yesterday,
04:09 AM
Khalil Handal
started a thread
Count number of student in specific school year
in
Queries
I need to count number of students in a specific grade in a specific school year (previous or current). Note that some of the students left school....
see more
9 replies | 151 view(s)
Yesterday,
02:55 AM
CJ_London
replied to a thread
datasheet font set in module
in
Modules
- highlight your code and click the # button Public Sub ft(frm As Form, sm As String, sc As Integer, fn As String, fs As Integer)...
see more
4 replies | 146 view(s)
Yesterday,
02:00 AM
CJ_London
replied to a thread
Importing Excel into Access
in
Import/Export Data
I've tidied up your code - Note if you are going to type the tags rather than simply using the # button you need to use rather than < and > ...
see more
5 replies | 305 view(s)
Yesterday,
12:04 AM
ano
replied to a thread
datasheet font set in module
in
Modules
dont understand code between code tags perhaps fontsize called height in datasheet?
see more
4 replies | 146 view(s)
04-25-2024,
09:23 PM
katjoe
replied to a thread
Importing Excel into Access
in
Import/Export Data
Hi CJ_London, My appologies before I begin. This is the first for me as of posting in a forum. I could not find how to use the code tags. I...
see more
5 replies | 305 view(s)
04-25-2024,
08:05 PM
davegri
replied to a thread
item not found in collection, error cdoe 3265
in
Modules
If Recset!] > Blanks And Recset!] <> "DNA" Then Not same number of spaces in field name. Very surprised this does not produce runtime error.
see more
1 replies | 103 view(s)
More Activity
No More Results
No Recent Activity