New profile posts

J

• J

  JJNikon YouMust JJNikon wrote on YouMust's profile.

• Mar 2, 2021

Did you ever get a solution for the #deleted in an empty field that you posted on 31Oct2019? I having the same issue.
thanks
Jeff

• 

  Anthony.DG

• Feb 12, 2021

Cant search anything. Keep getting site errors
.......

• 

  mike60smart flyers123 mike60smart wrote on flyers123's profile.

• Feb 7, 2021

Hi
You asked for a copy of the example I uploaded screenshots of.

If you use Skype then i can show you what I have done. My Skypename is:- Live:mike.s23

Regards

Mike

H

• H

  hfsitumo2001 Abo Abd_Allah hfsitumo2001 wrote on Abo Abd_Allah's profile.

• Feb 5, 2021

Abo, Could you help me on my question regarding query to select only one row where date of order is the latest?, how can we say that query

G

• G

  Galaxiom isladogs Galaxiom wrote on isladogs's profile.

• Feb 2, 2021

Colin:
I know how you like to test different ways of doing things. I suspect you would like to compare the techniques offered in this thread.

Solved - Access - Counting Letters and Numbers In A String

Good afternoon. I have some data like this: AB12 ABC1 ABC12 ABCD123EF I would like to count letters, numbers, and then letters again if applicable. This would give me: AB12 = 22 ABC1 = 31 ABC12 = 32 ABCD123EF = 432 I am not sure if this something I can do in a query using LEN along with...

www.access-programmers.co.uk

Greg

A

• A

  avaarden2001

• Jan 18, 2021

Hey Ava here, living in USA, I start working as a content writer in which I generally write content over entertainment and technology.

W

• W

  wikihow MajP wikihow wrote on MajP's profile.

• Nov 15, 2020

Hello MajP, Hope you are doing fine. I have made some progress in my database and stuck on an issue. Please review the recent post, whenever you have time and let me know what is possible solution. Thanks for all your help

S

• S

  SalmanZeiad isladogs SalmanZeiad wrote on isladogs's profile.

• Nov 12, 2020

How to make a continuous flash for a record that meets a specific condition in the continuous records form

• 

  mistermarty Dave mistermarty wrote on Dave's profile.

• Oct 31, 2020

Hi Dave. Just tried to post a question on the VBA section and got a message saying it could not be posted because it may be spam etc. Any guesses?

• 

  GabrielRyder

• Oct 29, 2020

When I am editing my Access dB on a network, a PC name, not my own, appears next to the Citrix icon, namely rdrwrajr0304, at the bottom right hand corner. Is this a snooper?

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.