New profile posts

N

• N

  nishan_gunarathne isladogs nishan_gunarathne wrote on isladogs's profile.

• Oct 19, 2020

Hi,

I just need code which hides the Access DB window and only have the open form. I have two more options in the form to which shows a report and one which saves the report as a excel file.

my form name: frmMyTime
my report name: rptMyTime

I use both MS Access 16 64bit / 32bit.

• 

  mike60smart roluko mike60smart wrote on roluko's profile.

• Oct 15, 2020

Hi

If you can send me some examples of your current Excel files I will take a look and make some suggestions.

Send to me at:- mike.s23@outlook.com

Regards

Mike

C

• C

  CHITTA apr pillai CHITTA wrote on apr pillai's profile.

• Sep 26, 2020

You are Great, GRAND SALUTE for your sample database (ShiftDuty.accdb)

N

• N

  nav786te isladogs nav786te wrote on isladogs's profile.

• Sep 11, 2020

Hi
Can u please add/share practical example of sending messages to users in access. I have seen 'CheckUser...' database with missing feature.

• 

  zac123

• Sep 10, 2020

Online and learning Access!

S

• S

  sribblett MajP sribblett wrote on MajP's profile.

• Sep 7, 2020

I attached my database today (9.7.20) for your review in the previous thread due to not allowing for me to upload it here.

S

• S

  sribblett MajP sribblett wrote on MajP's profile.

• Sep 4, 2020

I'm creating my table now. the Primary keys they are not auto number, correct? what does "indexed" mean?

S

• S

  sribblett MajP sribblett wrote on MajP's profile.

• Sep 4, 2020

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

• S

  sribblett MajP sribblett wrote on MajP's profile.

• Sep 4, 2020

We can forget the PIR Table. this is keeping track of all staff who had been hired and left during the program year. But I will have this information one my DB is done correctly.

S

• S

  sribblett MajP sribblett wrote on MajP's profile.

• Sep 4, 2020

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.

G

• G

  Gismo isladogs Gismo wrote on isladogs's profile.

• Sep 2, 2020

Hi,

thank you very much for the solution on the resizeform
this it absolutely amassing

thank you so much for all the replies you assist me with

• 

  mike60smart registan mike60smart wrote on registan's profile.

• Sep 1, 2020

Hi
If you want to chat through your problems then contact me via Skype: Live:mike.s23

H

• H

  HealthyB1 CJ_London HealthyB1 wrote on CJ_London's profile.

• Aug 28, 2020

How do i mark a thread as SOLVED?

• 

  mloucel

• Aug 5, 2020

Learning a new skill

• 

  smtazulislam bob fitz smtazulislam wrote on bob fitz's profile.

• Jul 25, 2020

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.

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

F

• F

  Falcone203

• Jul 5, 2020

Just having FUN! Making a DB for my local volunteer Fire Dept

• 

  onur_can

• Jul 2, 2020

I am here to solve your Access problems.

I

• I

  Ihk arnelgp Ihk wrote on arnelgp's profile.

• Jun 30, 2020

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

• B

  BGIBERT arnelgp BGIBERT wrote on arnelgp's profile.

• Jun 29, 2020

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

C

• C

  Charlie Tay

• Jun 12, 2020

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.