473,789 Members | 2,781 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Open a table from switchboard to enter data

5 New Member
I want to open a table from switchboard in datasheet view to enter data, can anyone please guide me how it can be done, i created a form for the table and tried to open it from switchboard but it does not open in datasheet view.

I am a newbie so any help is appreciated....
Mar 7 '10 #1
3 7222
Delerna
1,134 Recognized Expert Top Contributor
in the code that opens the form you need something like this
Expand|Select|Wrap|Line Numbers
  1. docmd.OpenForm "form Name",acFormDS
Mar 8 '10 #2
NeoPa
32,579 Recognized Expert Moderator MVP
If it's the table you need then something like :
Expand|Select|Wrap|Line Numbers
  1. Call DoCmd.OpenTable("TableName", acViewNormal, acEdit)
Mar 8 '10 #3
tasawer
106 New Member
Hi,

How about this code:
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "FormName", acFormDS
Sorry I did not see the solution above.. Apologies.
Mar 10 '10 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
2607
by: lestersal | last post by:
How would I compact a database on Open using code? I presume I'd have to use the Autoexec macro but what code do I put in the procedure called by Autoexec? Thanks, Alistair
4
9416
by: Terry | last post by:
I have created a Main Switchboard in Access 2000 and it has a button which opens a Form. I have set the form Properties Default View to Datasheet and this always opens in datasheet view. When I open the Form from the Main Switchboard it always opens in form view. Can this be changed so that it always opens in Datasheet View? Terry
2
4924
by: Miguel | last post by:
I have reviewed the many postings on this topic and understand the principle, but am not sure where in my case to apply trapping an error. I have created a form to supply parameters to a report. I click on the command button to open the report, the form opens as it should and the parameters are entered. Upon clicking on "OK," the underlying query is executed. It is at this point, the the error message appears. The dialog box disappers as...
3
3848
by: Cagey | last post by:
What I'm trying for: If this selection or if click on selection (highlighted line choice/ which ever selection change) w/in query's combo dropdown list box (on Switchboard), then Open in Datasheet View, the specific underlying record's Row... showing all columns Or selected columns. For a specific row's record ONLY, Or for all Xs (same type), or for the whole data sheet (all records... includes all types then), but focus still opens...
1
1698
by: jgraves | last post by:
Can I use a query to open a form? I have 2 different companies I enter data for. I want to set button on my switchboard that when clicked asks which company I am entering data for. Then it opens the form for that company. If I say "company 35" then it opens the form for "company 35".
1
1888
by: Don Croner | last post by:
I am using access 2003 with windows xp. I have created a data base for to keep track of my 180 employees. I have created a table with 21 records. Then I created a form to input employee data. I then created a switchboard to open a blank form. Now I want to use the swithchboard to open the form to a specific text box. ie, Edit Active Employees. I would like to do this by last name or SSN, two of the fields in the table. I can get it to...
9
3339
by: mtgrizzly52 | last post by:
Hi all, I've looked for an answer for this in lots of books, online in several discussion groups and have not found the answer which I feel may be very simple. What I want to do is have a switchboard with several active buttons on it for entering new data, updating data, reports etc. The new data and report stuff is easy, but the update button has me baffled. What I want to have happen is when the update button is clicked, a parameter...
6
3535
by: Markus_989 | last post by:
I have a LOANS table that has a list of loan details for different borrowers. I have a main switchboard with a LOANSELECT combo box (that displays a list of borrower last names and loan numbers). I'd like to be able to have a user click on the say, RECEIVE PAYMENT button that will open the payments form. This form should open to the loan that was selected from the LOANSELECT box. This form also has a box on it to switch to different...
4
8931
by: Nour469 | last post by:
Hello, I need simple help! I have a form with a field (DrsName) which is a combo box that looks up values in another table (Drs List). When I come across a name that is not in the list, I need to open the form (Drs List) and add the name. for which I added a cute button. I am having 2 problems: 1) I cannot get the button to open the form in add mode, as I don't want the users to accidently type over the data, I just want to be able to ADD...
9
3406
by: vanlanjl | last post by:
Okay lets see if I can do this with out confusing myself or others. First I will give ALL the details then state my problem and request at the bottom. Tables: tblContacts ID Company LastName FirstName Initial
0
10410
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10200
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...
1
10139
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7529
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
5418
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
5551
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4093
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
3701
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2909
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.