hello
i m working on my project,someone plz help
i delete record ,after deletion result is saved in database(access ),but not in vb form ,when i click on next or previous buuton ,i still see that record in form,and this record remains in form until or unless i reopen the form.
i m using ADODB ,record set and sql query like - a="delete from addressbook" where name='"& txtname.text *"'
-
conn.Execute(a)
4 2139
Just put
right after your
It will go to the first record in recordset and the deleted record won't be there.
NeoPa 32,568
Recognized Expert Moderator MVP
That code will need to be called from the form that needs to be requeried. This may, or may not, be the same place you are running the SQL code a from.
If it is not then you need : - Call {Some reference to the form}.Requery()
See Referring to Items on a Sub-Form for help with that.
I guess I did make an assumption there. Good catch NeoPa. One more thing to think about when answering questions.
NeoPa 32,568
Recognized Expert Moderator MVP Seth:
One more thing to think about when answering questions.
Less straightforward than one might imagine, certainly. You're certainly heading in the right direction though. Welcome on board :-)
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: David Allison |
last post by:
cmdButton to Print 3 copies of record in Form view ?
cmdButton will print 1 but I need 3 copies of the one Form record.
--
Dave Allison
|
by: bhavik |
last post by:
hi
I have problem with attachment showing form server side.
when our application run on localhost we add any attachment to mail server.
if suppose we want to show that attachment we can see that attachment with
View button. so in view button I me giving path of local machine and
attachment will be showing.
but..... when I upload that application on server machine and when I click
|
by: dbuchanan |
last post by:
VS2005
I've been reading all the help I can on the topic (MSDN, other) but I
can't make sense of this.
Desired behavior;
The user is to choose from the displayed list of the databound combobox
and the coresponding 'Id' from the lookup table is to be inserted into
the field of the new record.
I have two simple tables. "tblPerson" is the data table. The lookup
|
by: Ragbrai |
last post by:
Howdy all,
I have a form for entering data (Form A), on which is a cmd button that opens Form B in acdialog mode to allow me to enter/edit records that are being displayed on Form A.
After adding/editing a record on Form B (opened in acDialog mode), I want a cmd button on Form B to close Form B and then have Form A automatically take me to the record that was added/edited in Form B (Form A has a subform that I will then enter data into).
...
|
by: Rathi R |
last post by:
Hi,
I am new to this forum. I am working on Ms-Access. Based on the data in various tables i am generating a form. In that form, the calculated values have to be displayed one after the other i.e as new record. This form is being called from a main form and this ishe child from. In the child form I have created a for loop to calculate all the parameters again with only one input varying. But on execution only the last iteration is getting...
| |
by: Tom Clavel |
last post by:
Scratching my head.
I am using the filter property on a combo box .AfterUpdate event to
get to a single client record. This is causing a some strange
behavior: As I enter a subform, I get a no current record error. This
is strange to me because: I can see the record contents displayed on
the form, and debug.printing them gets me the values. Only the
form.recordset is giving me this error. form.recordset .bof and .eof
are false. ;...
|
by: Blue10 |
last post by:
Hi, I'm new.
Many of my old pages get listed on search engines, but once the record they call is deleted the page is no longer available.
I was wondering if there was some ASP code for where a record doesn't exist, the browser is refreshed to another page please?
Blue10
|
by: leeg |
last post by:
Hi all,
I am having trouble finding out how to stop a new record showing on my form when there are no records showing in my underlying query
Query criteria is populated from a form text box and then I use a cmd button to open the form.
cmd button on click
Dim stDocName As String
Dim stLinkCriteria As String
|
by: maxx429 |
last post by:
Good day all,
Using Access 2007 but DB is created in Access 200o format so I can still use User Level security.
I have what am sure is a very newbie question. I want to add a control to a form which allows the user to type in a value, in this case a site #, and have the form navigate to the corresponding record.
I found some sample code that does this using a Combo Box. I tried modifying this code to use an unbound Text Box but I keep...
|
by: evildracko |
last post by:
first a write error prompt
Title: Write Conflict
Text: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make the changes.
Options:
<Save REcord> <Copy to clipboard> <Drop changes>
Then...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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...
|
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,...
|
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...
|
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...
|
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...
| |
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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...
| |