New profile posts

P

• P

  Pat Hartman tonycicc20 Pat Hartman wrote on tonycicc20's profile.

• May 10, 2021

Tony,
I attached a word doc because I got an error posting my message.
Pat

H

• H

  haitham Elareny theDBguy haitham Elareny wrote on theDBguy's profile.

• Apr 18, 2021

hi.... i want to design a message box which appear from right to left on opening at bottom of screen ,then disappear from left to right on closing .i tried with
form_load inside height=20000&inside width=0 but want to change message width from 0 to line length on opening

H

• H

  haitham Elareny arnelgp haitham Elareny wrote on arnelgp's profile.

• Apr 18, 2021

hi..i want to design a message which appear from right to left at bottom of screen on opening then disappear from left to right on closing .i tried using inside height

H

• H

  haitham Elareny theDBguy haitham Elareny wrote on theDBguy's profile.

• Apr 17, 2021

can you help me to modify that database

H

• H

  haitham Elareny theDBguy haitham Elareny wrote on theDBguy's profile.

• Apr 17, 2021

can you help me to modify that database

H

• H

  haitham Elareny arnelgp haitham Elareny wrote on arnelgp's profile.

• Apr 16, 2021

can you help me to modify that database

• 

  arnelgp SalmanZeiad arnelgp wrote on SalmanZeiad's profile.

• Apr 15, 2021

can you send your db to my email: agpuzon@gmail.com.
i have reformat my drive so i cannot remember the code.

F

• F

  flyers123 mike60smart flyers123 wrote on mike60smart's profile.

• Apr 12, 2021

I appreciate greatly for your tremendous help with building the database for me. Thank you for all your help

• 

  conception_native_0123 arnelgp conception_native_0123 wrote on arnelgp's profile.

• Apr 11, 2021

thank you for pointing out that that helped me. it was obvious but i made a mistake.

Y

• Y

  Yianni smtazulislam Yianni wrote on smtazulislam's profile.

• Apr 10, 2021

Hi, I have reviewed your database and see that you have thought through many issues.
1) I suggest that you use the Autonumber field in tblProjects as the unique number for each
project. Access will manage it, keep it unique (never duplicate it)
2) Use the same field name (ProjID) in the tblProjectDetails; however the field will be Number, Long Integer
more later

John

• 

  togur

• Apr 4, 2021

Date Picker not displaying

• 

  NauticalGent CooperF NauticalGent wrote on CooperF's profile.

• Apr 1, 2021

So what issues with DSUM are you having?

• 

  GaDauBac arnelgp GaDauBac wrote on arnelgp's profile.

• Mar 28, 2021

Hello!
You can make changes to the [Maintenance Date] field once a month until the Departure Date does not change.
This means it changes once a month.
For example:
- OutOfDate = 27/3/2021
- Maintenance date = 27/4/2021
Then 1 month Maintenance Day = 27/5/2021
If OutOfDate = Current date will not change
At stops: - MaintenanceDate = OutOfDate
Thank you!

S

• S

  shenekas theDBguy shenekas wrote on theDBguy's profile.

• Mar 26, 2021

I would like to make the Archived Date field a "required" field if the Archived value is selected in the Status field in Access 2016. Is there anyway to have the cursor automatically go to the Archived Date field so that the date can be selected? Does you have any idea how to fix this?

P

• P

  Pat Hartman sxschech Pat Hartman wrote on sxschech's profile.

• Mar 12, 2021

Please send me a link as a PM. Thanks

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