Nothing happens when I press datasheet view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hiya

Access has started doing something very weird. I am trying to create a simple query - sometimes though, if I put the grouping on (nothing fancy - simply click the sigma button) - when I go to view the datasheet absolutely nothing happens. The query stays in design view, no message, no nothing. The screen has not frozen or anything

What has happenned? This is really urgent as I have the whole company breathing down my neck about their bloody reports - can anyone help??

MK
 
Hi Hiya,

Does it happen on all machines?
Are you able to create other GroupBy queries in the same database?
Does it happen in other database files?

Possible problems could be:
- Problem with database = corruption
- Problem with query = corrupted
- Problem w/machine = need updated version of JET Database Engine

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Thread-Topic: Nothing happens when I press datasheet view
| thread-index: AcQtMwWpKVFzcv/tQoycfibM6QUv8g==
| X-WN-Post: microsoft.public.access.queries
| From: "=?Utf-8?B?TUs=?=" <[email protected]>
| Subject: Nothing happens when I press datasheet view
| Date: Wed, 28 Apr 2004 08:11:03 -0700
| Lines: 7
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.queries
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.queries:198876
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.queries
|
| Hiya,

Access has started doing something very weird. I am trying to create a
simple query - sometimes though, if I put the grouping on (nothing fancy -
simply click the sigma button) - when I go to view the datasheet absolutely
nothing happens. The query stays in design view, no message, no nothing.
The screen has not frozen or anything.

What has happenned? This is really urgent as I have the whole company
breathing down my neck about their bloody reports - can anyone help???

MK
|
 
Back
Top