Learning a new skill
New profile posts
Hi Bob fitz
Cloud you please check this below link and solution this problems, this example is for isladogs. I just edit and try to put. But did not success. Hope you will help me. thank you.
Cloud you please check this below link and solution this problems, this example is for isladogs. I just edit and try to put. But did not success. Hope you will help me. thank you.
Solved - Form data enable/disabled
Oh hu hu, I am stupid i forget to put this event. Private Sub Form_Current() Call cboStatus_Change End Sub arnelgp code is work, Thank you.
www.access-programmers.co.uk
Just having FUN! Making a DB for my local volunteer Fire Dept
I am here to solve your Access problems.
-
I
Ihk wrote on arnelgp's profile.
Hi @arnelgp
If you have time, I have posted a thread regarding "current active user". Please have a look.
Many thanks
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
-
B
BGIBERT wrote on arnelgp's profile.
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
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