Access FORM (1 Viewer)

[antonyel]

HI Master,

last year I had learned from this forum and shared the tools that really help me to generate the report and it was really helping me a lot. really thank you especially for JHB that shared the code for me and helping me to develop the tools that I used today.

after almost 1 year used I have faced some problem and try to find out but couldn't find the answers, if you don't mind I have couple question here.

1. if the first time I run the tools the secondary axis legend always shifted to the left like in the pic that I shared on attachment but after I did run (generate) the second time the position been corrected.

2. I have 9 Tab on my FORM is there anyway if I scroll down the TAB still in the position, like went we freeze a header on excel

3. is there any way to create a chart as many as we want because if I create some of the charts there are some limitation of the form. for example, I just can create like 5 charts in a row.

Pls find the attach for the sample tools for learn together.
thanks very much for this forum so much helping to build and learn access specially for beginner like me

Brs
AN

 

[JHB]

..
1. if the first time I run the tools the secondary axis legend always shifted to the left like in the pic that I shared on attachment but after I did run (generate) the second time the position been corrected.

I can't replicate your problem, because the graphs doesn't show any data.

..
2. I have 9 Tab on my FORM is there anyway if I scroll down the TAB still in the position, like went we freeze a header on excel

No.

..
3. is there any way to create a chart as many as we want because if I create some of the charts there are some limitation of the form. for example, I just can create like 5 charts in a row.

I think you've reach the max. high of a section (about 57cm), so the only way to get more charts in it, is to make them smaller.

https://support.office.com/en-us/ar...ications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c

 

[antonyel]

Hi.. JHB

thanks for the answer, sorry I forgot to tell you how to use the tools.

first we have to change the date format in laptop to yy-mmm-dd hh,

after that please follow the picture that I attached
1. select working set name
2. select date before and after
3. generate

because I just attach a certain date so it can only follow the date according to the picture. (date before is dec 14 - 15) date after is (dec 16 - 17)

for point 2 that I asked means there is no way anymore to modify the TAB Control so it can freeze like in excel.

thanks again for the answer

 

[arnelgp]

On pt 2, you can make a command button
that can be clicked to set the value of
the TabControl appropriately.
Set the TabControl's Style to None.

see the "New" command buttons Click event.
see also the Form's Load event.

 

[JHB]

There is no way to "freeze" the TAB Control.

Seems to loose the data when I save a copy of the database.

 

[arnelgp]

if there is Error in the Load Event,
delete the Form's Load Event.
create a Timer Event instead on the Main Form.
set the Timer Interval to 30.

Private Sub Form_Timer
    ' kill the Timer
    Me.TimerInterval = 0
    Me.cmd00.SetFocus
    Call fncGoToPage

End Sub

 

[antonyel]

Hi arnelgp

is working well cool, like proberb said There are many ways to go to Rome
thanks for the Idea.. and shared the code.

 

[JHB]

You could try to comment out or delete the following code line in the Sub Command167_Click().

DoCmd.RunCommand acCmdSaveRecord

 

[antonyel]

hi Jhb,

after i did remove the code, now when i run the tools looks perfect
thank you very much.. now everything was perfect to me..

thanks to everyone in this forum

 

[JHB]

You're welcome, good luck.

 

[Pat Hartman]

first we have to change the date format in laptop to yy-mmm-dd hh,

This is poor practice. It brings us back to the early 80's where applications assumed that they were the only programs running on a computer and they took over the world.

You CANNOT force a user to change his system settings to run your application. Your application has to format the date itself if the date needs formatting.

Also, you need to keep in mind that formatting a date using Format() converts it to a string at which point it will no longer act like a date. So, make sure you know what you are doing if you format a date. Sometimes, you need to format dates for display purposes and this looks like one of those so you don't need to format every date on every form, just this one.

 

[antonyel]

hi sir..

thank you for the input, you are really right.

Brs

DN