473,703 Members | 2,605 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Showing datasheet

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=da tasheet' and "Views Allowed=datashe et"

-mjm
Nov 12 '05 #1
2 1707
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=da tasheet' and "Views Allowed=datashe et"

-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


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=da tasheet' and "Views Allowed=datashe et"

-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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
3564
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 the field name. Is there a way to retain this nomenclature and yet have the view display the field name (or anyname i want for that matter)? Thanks --
2
3059
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 since all my data is in tables. For example, I have a SubForm Datasheet with these text boxes: txtAccountNumber txtCurrentBalance txtPendingTransactions txtLedgerBalance
2
278
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. I have the proerties set to "Defaultview=datasheet' and "Views Allowed=datasheet" -mjm
0
309
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 of the records in their forms (Datasheet view) are showing up as "#Deleted", though no one should be deleting records from here. Further, the messages show up only on certain users' screens. Is this a result of corruption from having multiple...
1
29571
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. I want the user to be able to see the seconds counting down. Can anyone help me? thanks
1
2930
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. --------------------------------------------------------------------------- Steve: I have followed your instructions to a "T". However, I continue to
4
315
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. Thanks for your help! Smriti
2
7721
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 populated with data and not only is there no data, there isn't even a blank column with the field name. Is there some type of hide feature that may be preventing the field from showing? Any assistance would be greatly appreciated. Mike
3
1470
Ericks
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 that didn't help. This keeps me wondering why it shows as Datasheet when called directly but in Form view when called from the Main Form. I guess I need to add some code to the On click command of the button. Any suggestions?
2
3151
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 me Datasheet view. Dialog mode won't give me Datasheet view I could make Form01 Restore size and expand it to fill the Window in Restore size (maybe DoCmd.MoveSize Right, Down, Width, Height) - I don't want this.
0
9117
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8961
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7861
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6585
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4429
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4687
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3122
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2446
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2063
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.