New profile posts

What's new Featured content New posts New profile posts Latest activity
I
Hi @arnelgp
If you have time, I have posted a thread regarding "current active user". Please have a look.

Highlight currently logged users in access / Mark user as active at the moment

Hi, I have multiple user login based access database. There is table with name""UsersActivity". I created a form based on this table. I want to highlight users whose status is still logged in but not logged out yet from the the database. There are three fields in form (taken from table), and a...
www.access-programmers.co.uk
Many thanks
B
Yesterday you provided the SQL
select id, invoice, dcount("1", "yourTableName", "ID <= " & [ID]) As Sequence, Status from yourTableName Order By id Asc;
I do not have an ID value. To simplify, assume a table of only invoice numbers with duplicates. How would I change your SQL to:
1) get a sequential number for each record
2) get a subset of sequential numbers by the invoice number
isladogs
isladogs
@BGIBERT
You should ask this question in the forum thread where you are more likely to get a quick answer
C
Good evening. Just joined today to find out answers for of my questions and hope I can help resolve some issues, though. Still a learner.
S
Hi CJ_London
could You please look at my thread, if you are not busy

How to make a consolidated Report

Hi all... I am developing my first access app for building construction work purpose Actually all I want is to make monthly progress reports to submit to my boss This is my masterTable Project Name | Locality | EstimatedCost | Stage1CompletedDate | Stage2CompletedDate | Stage3Date | etc...
www.access-programmers.co.uk
B
Hi Everybody, I am new in this forum. I am learning VBA programming for Excel and Access. Would like to upgrade myself with the vast knowledge base available in this forum. In profession, I am a Mechanical / Piping Engineer, living in Thane, Maharashtra, India.
Regards,
Bibek.
Back
Top Bottom