Size of Query result

Ok, I see. There are many details to cope with. I have showed the query to
the user, because it is a crosstab query with dynamic number of columns,
depending on the result. The output is datasheet. I have earlier made a
cumbersome report that does the same thing in an earlier application and
thought I would be able to do it a bit easier this time. I would hope that
his version should present the data the same way as mine does. But I guess I
have to do it with much more labour.

Thank you anyway for your responses.
/ Rolf



"Allen Browne" wrote:

Sorry, Rolf

From my first reply, I have assumed you had a Datasheet form to display the
query -- probably because I never let users anywhere near the actualy tables
and queries.

You were talking about queries. I have not been answering your question at
all. Apologies.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Rolf Rosenquist" wrote in
message
...
As normal, as the queries are not locked, only forms, reports and code.
The
user has also a full licensed version of Office, so I am not using the
developer version in this case.

I must correct one thing I said earlier. I was not using 2002 when writing
this application, but 2000 as I should make a mde version of it. I have
learned that the 2002 version saves the programs in 2000 style by default
and
that could not be converted to mde in 2002. - So the program is made in
2000, and I can change and save the query in my 2002 version and it works
on
my other computer with 2002, but not in his 2003 version.

/ Rolf

Allen, I have now tested to make a brand new database in his machine, without
any connection at all to my application. Created a table and a normal query.
- Still the same issue. He cannot change the size of the result of the query.
At least it was not my application that was the problem. I have suggested a
reinstallation of Access as a possible way out - but must admit that I doubt
for the result. If so could it be the hardware that locks up?
/ Rolf




"Allen Browne" wrote:

Sorry, Rolf

From my first reply, I have assumed you had a Datasheet form to display the
query -- probably because I never let users anywhere near the actualy tables
and queries.

You were talking about queries. I have not been answering your question at
all. Apologies.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Rolf Rosenquist" wrote in
message
...
As normal, as the queries are not locked, only forms, reports and code.
The
user has also a full licensed version of Office, so I am not using the
developer version in this case.

I must correct one thing I said earlier. I was not using 2002 when writing
this application, but 2000 as I should make a mde version of it. I have
learned that the 2002 version saves the programs in 2000 style by default
and
that could not be converted to mde in 2002. - So the program is made in
2000, and I can change and save the query in my 2002 version and it works
on
my other computer with 2002, but not in his 2003 version.

/ Rolf

I have had problems with trying to make modifications remotely i.e.
refresh table links. I had to create a procedure attached to a command
button on a form that would refresh the links on the remote computer.
Click the command button on the form and that refreshed the links.
Running the procedure directly in the module remotely appeared to work
but did nothing. This may be a similar issue.


Rolf Rosenquist wrote:
Allen, I have now tested to make a brand new database in his machine, without
any connection at all to my application. Created a table and a normal query.
- Still the same issue. He cannot change the size of the result of the query.
At least it was not my application that was the problem. I have suggested a
reinstallation of Access as a possible way out - but must admit that I doubt
for the result. If so could it be the hardware that locks up?
/ Rolf




"Allen Browne" wrote:

Sorry, Rolf

From my first reply, I have assumed you had a Datasheet form to display the
query -- probably because I never let users anywhere near the actualy tables
and queries.

You were talking about queries. I have not been answering your question at
all. Apologies.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Rolf Rosenquist" wrote in
message
...
As normal, as the queries are not locked, only forms, reports and code.
The
user has also a full licensed version of Office, so I am not using the
developer version in this case.

I must correct one thing I said earlier. I was not using 2002 when writing
this application, but 2000 as I should make a mde version of it. I have
learned that the 2002 version saves the programs in 2000 style by default
and
that could not be converted to mde in 2002. - So the program is made in
2000, and I can change and save the query in my 2002 version and it works
on
my other computer with 2002, but not in his 2003 version.

/ Rolf

Yes, you are right abaout that. I have also many times noticed that the
update of my remote display has not always worked. But as we on those
occasions spoke to each other over the telephone, I have heard that it had
been updated on the host side.

But this problem that the query result cannot be set, is still the same on
his computer.

I have earlier got annoyed of another thing, and that is that reports tend
to open in a smaller size than 100%. Even when I try to save it in 100%. Then
I got the tip from an older thread here that if I let the code have the line
"DoCmd.RunCommand acCmdZoom100" right after the open report command on the
preceeding form, it worked. So I tried to figure out if there is something
similiar for the query result, but could not find anything. Maybe there is,
or there isn't?
/ Rolf



" wrote:

I have had problems with trying to make modifications remotely i.e.
refresh table links. I had to create a procedure attached to a command
button on a form that would refresh the links on the remote computer.
Click the command button on the form and that refreshed the links.
Running the procedure directly in the module remotely appeared to work
but did nothing. This may be a similar issue.


Rolf Rosenquist wrote:
Allen, I have now tested to make a brand new database in his machine, without
any connection at all to my application. Created a table and a normal query.
- Still the same issue. He cannot change the size of the result of the query.
At least it was not my application that was the problem. I have suggested a
reinstallation of Access as a possible way out - but must admit that I doubt
for the result. If so could it be the hardware that locks up?
/ Rolf




"Allen Browne" wrote:

Sorry, Rolf

From my first reply, I have assumed you had a Datasheet form to display the
query -- probably because I never let users anywhere near the actualy tables
and queries.

You were talking about queries. I have not been answering your question at
all. Apologies.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Rolf Rosenquist" wrote in
message
...
As normal, as the queries are not locked, only forms, reports and code.
The
user has also a full licensed version of Office, so I am not using the
developer version in this case.

I must correct one thing I said earlier. I was not using 2002 when writing
this application, but 2000 as I should make a mde version of it. I have
learned that the 2002 version saves the programs in 2000 style by default
and
that could not be converted to mde in 2002. - So the program is made in
2000, and I can change and save the query in my 2002 version and it works
on
my other computer with 2002, but not in his 2003 version.

/ Rolf