New profile posts
Online and learning Access!
-
S
sribblett wrote on MajP's profile.
You asked what is does Program mean. It is actually the classroom identification for that staff person. there are several staff who would not have that due to staff who do not work in a classroom or staff who are "floaters" or AN(as needed) who are not assigned to 1 particular classroom.
-
S
sribblett wrote on MajP's profile.
ok...I'm ready to tackle the issues with my current database. As you know there's a lot of work to be done. Where should I begin? You suggested combining some tables and changes their PK and creating FK. I'm ready whenever you are able to help me to get this done right and most effective.
Learning a new skill
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
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.
Glasgow, UK
-
S
sunkerala wrote on CJ_London's profile.
Hi CJ_London
could You please look at my thread, if you are not busy
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
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.
Regards,
Bibek.