473,503 Members | 2,322 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Open datasheet with new record line at top

44 New Member
I have a form in datasheet (Edit) view that is many records longer than the page height. The usual reason for the user to open this form will be to enter a new record, rather than amend an existing one. It would be neater and require less keystrokes if I can make the new record entry line appear at the top of the datasheet to avoid them having to (find and) click on the 'enter new record' control and then be taken to the bottom of the datasheet. Is this possible please?
Jun 7 '13 #1
4 3759
Seth Schrock
2,965 Recognized Expert Specialist
What you can do is to just go to the new record when you open the form.
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm...
  2. DoCmd.GoToRecord Record:=acNewRec
Jun 7 '13 #2
Nick Cooper
44 New Member
Thanks Seth, Yes I have now done that and it's certainly an improvement, but somehow it seems neater if the user is taken initially to the top of the numerically then alphabetically sorted list of records. Some of them will not be too conversant with the use of datasheets. Also, I use the form caption to describe what action is needed and it would be good if the blank record waiting to be completed was immediately below it. No big deal but if there is a relatively easy way of achieving it ....
Jun 8 '13 #3
Seth Schrock
2,965 Recognized Expert Specialist
I don't believe that there is a setting that puts it at the top, but what you can do is to have some unbound controls at the top of your form and have the datasheet form as a subform. When you enter the new record information in the unbound controls and click an "Update" button, it would insert the new data and could requery the subform to show it. This would require some coding, but nothing too complicated.
Jun 8 '13 #4
Nick Cooper
44 New Member
Thanks for your help Seth. I think I'll stick with the first solution.
Jun 9 '13 #5

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

Similar topics

0
966
by: Ivan Shevanski | last post by:
Hey this is probally a noob question but here goes. . .How could I open the command line inside of a python script? Would I have to use COM? -Ivan ...
3
36078
by: N. Graves | last post by:
Hello, I'm having trouble with a feature that I would like to add to my database. I would like to have the ability to double click a record on a Sub form and that action would open that...
2
8659
by: Support4John | last post by:
a2k (9.0.6926) SP-3 Jet 4.0 SP-7 I have a button on a Single Form that when pressed displays all the underlying records in the table in a Datasheet Form. For example, Northwind, Customer...
3
4187
by: Chris | last post by:
Hello all. I have a database that I use to send email updates to people. Everything is working fine, but one suggestion I keep getting is to add a link to the automatic emails that will open up the...
5
3473
by: Bill | last post by:
This database has no forms. I am viewing an Access table in datasheet view. I'd like to execute a macro to execute a function (using "runcode"). In the function, I'll reading data from the record...
4
7551
by: Orv | last post by:
I have a search form which contains a non-linked subform. When I fill the criteria of my search and click the search button it returns the results in the subform, datasheet view. I then want to...
23
3701
by: olivero | last post by:
Hi group, I've got a 3 level hierarchy of forms, as such: --Main ----frmSubOrders1 ------frmSubOrderDetails1 Order Details is a subform of Orders and Orders is a subform of Main.
3
2598
by: Jollywg | last post by:
I have a continuous form that i would like to remove or make invisible the new record line (the record with the asterisk next to it). Is this possible? Thanks in advance. Matt
16
5954
by: GLEberts | last post by:
Subject: Trying to open up a record in a form called "fmappointment" when clicking on a "looks like hyperlink" text box called "ContactID" I have made many instances of this in my database but in...
2
3522
by: eko99312 | last post by:
Let's say I have this form called Attendance List. The list was in datasheet form. In the list there were names and date checklist. The question is, I want to edit one of the names by double clicking...
0
7291
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,...
0
7357
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...
1
7012
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...
0
7468
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...
0
3180
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...
0
3171
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1522
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 ...
1
748
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
402
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...

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.