A
Alberto Uttranadhie
Hi everybody,
Here are two questions you kindly answer:
1. Forms and display resolutions
I am building a DB application on Access for a local network. Everything is
fine, but not everybody has the same display resolution. I would like to
know if Access allows autoresizing or so; I must say all forms execute
Me.Maximize method as opened; but, only is user has a 1024 x 768 display
resolution will manage the application as I wrote. Is it possible to set
form and its objects sizes as, for instance, HTML pages do with cells and
tables (i.e., using percentages).
2. RecordCount
I have a continous form whose Recordsource comes from a SQL sentence from
another form using:
DoCmd.Openform, "Results",,varSQL
where varSQL is a variable containing the WHERE instruction with no WHERE
itself, as everybody knows for Openform method.
Otherwise, there is a Textbox whose function is to show the number of
records returned from my previous query, that is:
Me.Textbox1.Value = "Number of records found: " &
Me.RecordsetClone.RecordCount
This method works fine but RecordCount only returns the total number of
records capable to be displayed on screen, but not the whole number of
records. That is; if my form is only able to show 6 records at the same
time, that will be the number of records returned from RecordCount; although
the whole number is 56, for example.
Thanks in advance.
Alberto (Spain)
Here are two questions you kindly answer:
1. Forms and display resolutions
I am building a DB application on Access for a local network. Everything is
fine, but not everybody has the same display resolution. I would like to
know if Access allows autoresizing or so; I must say all forms execute
Me.Maximize method as opened; but, only is user has a 1024 x 768 display
resolution will manage the application as I wrote. Is it possible to set
form and its objects sizes as, for instance, HTML pages do with cells and
tables (i.e., using percentages).
2. RecordCount
I have a continous form whose Recordsource comes from a SQL sentence from
another form using:
DoCmd.Openform, "Results",,varSQL
where varSQL is a variable containing the WHERE instruction with no WHERE
itself, as everybody knows for Openform method.
Otherwise, there is a Textbox whose function is to show the number of
records returned from my previous query, that is:
Me.Textbox1.Value = "Number of records found: " &
Me.RecordsetClone.RecordCount
This method works fine but RecordCount only returns the total number of
records capable to be displayed on screen, but not the whole number of
records. That is; if my form is only able to show 6 records at the same
time, that will be the number of records returned from RecordCount; although
the whole number is 56, for example.
Thanks in advance.
Alberto (Spain)