473,405 Members | 2,334 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

How do you save a record in ms access using vb

I want to save the record on a form before creating a report.
Shit+Enter could do it but I would like to add a "save record" to a click event of a button that creates the report.

Can anyone please help.
David
Feb 7 '10 #1
2 5053
Stewart Ross
2,545 Expert Mod 2GB
Hi. If you are working in an MS Access form you can check the form's Dirty property, which is set to True if the current record has been modified but not saved. A simple way to save the record is simply to reset the property to false -which saves the current record as a result. The VBA for this is simply

Expand|Select|Wrap|Line Numbers
  1. If Me.Dirty then
  2.     Me.Dirty = False
  3. End If
-Stewart
Feb 7 '10 #2
Hi David,
Do you mean that you are using VB as front end and MSAccess Database as back end? If so you can save records on VB form by connecting to Database and using Update method.

Good Luck
Feb 9 '10 #3

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

Similar topics

0
by: Jeff D. Hamann | last post by:
Sorry for the seemingly novice posting, but I could find a solution for this on the web so far... I've been developing a database using postgresql (and loving it) and have started running into...
4
by: jaYPee | last post by:
anyone know how can i save record from datagrid back to sql server using datacommand? im trying to use dataset but no luck. the source has a join table and when i use the dataadapter wizard it says...
2
by: voroojak | last post by:
Hi How can i put save record and next record in one button. in my save record i put the calculation of the text boxes. i have a total field that the sum of the other field is in there and it wil be...
4
by: Trunk3d | last post by:
Hello all. I have a Data Access Page that users can reach to submit a request. At the end of the page I am using a Command Button that is set to Save Record. Is there a way that upon pressing the...
2
by: rockdc1981 | last post by:
I dont it is possible to put this codes together.. I want to prompt the user to save the record and at the same time have a log of audit trail. the codes work out fine separately. Code for Audit...
1
by: dkozel | last post by:
I am creating a project that in some areas has many steps to add a record to a database. The binding navigator is great but combined with the some additional steps this gets cumbersome. I would...
8
jmoudy77
by: jmoudy77 | last post by:
Hi, I've got a form that allows a user to imput their flight data. I programmed a MsgBox into the save button that asks if the user wants to input another duty position for the flight. If no, the...
7
by: Neil | last post by:
Was working in A2003 and noticed that the Save Record item on the Records menu was not available when the record was not dirty. In A2000, Save Record was always available. (This is a problem for me...
1
by: Karan Singh Goyal | last post by:
I have an access table which have fields like Customer Id, First Name, Last Name etc. i know how to generate auto number but when i delete last record it generates next number instead of previous one...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
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
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...
0
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
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
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...

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.