Showing datasheet

michael montagne

I can't seem to get my form to show datasheet bt default. If I run it
from the databse window, it works just fine. But called from a button
on a different form, and it goes to form view instead. I have the
proerties set to "Defaultview=datasheet' and "Views Allowed=datasheet"

-mjm

Nov 12 '05 #1

Subscribe Post Reply

1689

fredg

On Wed, 14 Apr 2004 15:33:40 -0700, michael montagne wrote:

I can't seem to get my form to show datasheet bt default. If I run it
from the databse window, it works just fine. But called from a button
on a different form, and it goes to form view instead. I have the
proerties set to "Defaultview=datasheet' and "Views Allowed=datasheet"

-mjm

If you open the form from a command button on another form you must
explicitly open it in Datasheet view:
DoCmd.OpenForm "FormName", acFormDS
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Nov 12 '05 #2

michael montagne

fredg wrote:

On Wed, 14 Apr 2004 15:33:40 -0700, michael montagne wrote:

I can't seem to get my form to show datasheet bt default. If I run it
from the databse window, it works just fine. But called from a button
on a different form, and it goes to form view instead. I have the
proerties set to "Defaultview=datasheet' and "Views Allowed=datasheet"

-mjm

If you open the form from a command button on another form you must
explicitly open it in Datasheet view:
DoCmd.OpenForm "FormName", acFormDS

I love this place!! Thanks.

Nov 12 '05 #3

by: Kent Eilers | last post by:

I want to follow naming conventions for my controls - i usually prefix combo boxes with "cbo". When a form is in datasheet view however i do not want the user to see the 'cbo' prefix in front of...

Microsoft Access / VBA

How to make a datasheet work like a spreadsheet?

by: deko | last post by:

I'd like to be able to do in-cell editing of a datasheet and have other fields automatically update. I know... the easy answer is to use Excel, but I'm wondering if I can pull this off in Access...

Microsoft Access / VBA

Showing datasheet

by: michael montagne | last post by:

I can't seem to get my form to show datasheet bt default. If I run it from the databse window, it works just fine. But called from a button on a different form, and it goes to form view instead. ...

Microsoft Access / VBA

Records showing as '#Deleted' in one form but not another.

by: maddman | last post by:

I have an odd problem with my database, and was hoping someone could point me at the problem. We have an access database that is used by several people to input data. Users have reported some...

Microsoft Access / VBA

Showing countdown timer on a form

by: Will | last post by:

I have form showing instructions and logging actions and I would like the form to show a count down timer for a certain period of time. E.g. 30 secs, going down to 0 and then displaying the action....

Microsoft Access / VBA

Att: PC Datasheet - Please readf inside

by: George Kandaz | last post by:

Steve, I posted a question to your last post almost a week ago, but never heard from you again. Please read my last message, as follows. Thanks. ...

Microsoft Access / VBA

Showing all records in a table in the details section of a form

by: Smriti Dev | last post by:

Hi, I am creating a form and I want all the records to show in the details section that are in the table. How do I get them to appear. Currently, I have to press next to view each record....

Microsoft Access / VBA

field not showing up in datasheet view

by: Takeadoe | last post by:

Dear NG - I may be nuts, so forgive me for bothering you. There is a text variable in my table that shows up in design view, but is no where to be found in the datasheet view. The field should be...

Microsoft Access / VBA

Datasheet Form insists on showing in Form view.

by: Ericks | last post by:

I have a sub Form that is in Datasheet mode. On my Main form I have a button that opens this form but then it shows in Form view. I set both the Default view and Allowed view options to Datasheet but...

Microsoft Access / VBA

Restore size Datasheet View Form on top of Maximized Form

by: Alan Forsyth | last post by:

That rather long subject says it. In Access97 running on XP - I want to display a Maximized size Form01, then open a Restore size Datasheet View Form02 on top of the first Form. PopUp won't give...

Microsoft Access / VBA

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Similar topics