When i edit the data in the database, the form doesnt show the effect unless i scroll back and then forward. Please can you help.
Below is the code am using
If (MsgBox("Are you sure you want to Edit Vehicle Type: " & RsVehType("txtV EHTYPE"), vbYesNo, "VEHICLE TRACKER") = vbYes) Then
response = InputBox("Enter the new Vehicle Type", "VEHICLE TRACKER")
response = UCase(response)
AdVehType.Execu te "UPDATE tblVEHTYPE SET txtVEHTYPE = '" & response & "' WHERE txtVEHTYPE = '" & TxtType.Text & "';"
RsVehType.Reque ry
End If
4 873
G'day
This is a guess: refresh the form that is displaying the data (rather than moving around in the database so as to generate the relevant event)
Kind regards,
Bruce.
sashi 1,754
Recognized Expert Top Contributor
G'day
This is a guess: refresh the form that is displaying the data (rather than moving around in the database so as to generate the relevant event)
Kind regards,
Bruce.
Hi there,
Axtens's correct, refresh the form will solve the problem. Good luck & Take care.
RESOLVED
Thank you, the issue was resolved by refreshing the form and requerying the Database.
sashi 1,754
Recognized Expert Top Contributor RESOLVED
Thank you, the issue was resolved by refreshing the form and requerying the Database.
Hi there,
Good luck & Take care.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: DebbieG |
last post by:
I have a form based on this query:
SELECT Students.LastSerDT, OtherInfo.Served, OtherInfo.HSGradYr,
OtherInfo.ActivePart, OtherInfo.Served, Students.SSN, & ", " &
& " " & AS Name, Students.LastNM, Students.FirstNM,
Students.MI, Students.DOB, Students.GenderCD, Students.EthnicityCD,
Students.EligibilityCD, Students.UBInitiative, Students.NCESSchID,
Students.ProjEntryDT, Students.ProjReEntDT, Students.LastSerDT,
Students.Reason,...
|
by: K.N.Ranjit |
last post by:
Hi,
This is the 4th mail I'm sending regarding this problem.
I'm really not been able to sort this problem out.I'm not
been able to change my starting position of my cordinates
from top-left to bottom-left of my form.Thrice I got the
reply but unfortunately it did'nt work.Here is my coding.
private sub form_load(...)
dim y as integer
y=me.height
location.y = 0-y
|
by: Roger |
last post by:
Is this an easy thing to change?
I want to put an option button on a form and want to dynamically change the
color (Red, Yellow, Green) for
showing a status. I figured it would be an easy task, but am finding it a
little difficult as there isn't a simple property to set.
Thanks,
Rog
|
by: Marc R. |
last post by:
Hi all,
I edit records using a form that have multiple control bind on Dataview, But
I don't want to update right always to database, I would like to delay until
all Changes (add all new record using a form or edit various existing
records)
This way I could minimize transaction on server..
|
by: Tedmond |
last post by:
Dear all,
My application allows users to switch languages at run time. I use the
following code to change the UI Culture but all controls are remaining
unchanged.
Thread.CurrentThread.CurrentUICulture = new CultureInfo("en-US");
Why? Anything that I need to do in order to refresh the controls?
| |
by: Jim in Arizona |
last post by:
I have a gridview that's being populated from an access db query. The
problem I'm having is that the date/time fields in access that are
populating the gridview are showing both date and time, when the field
should only be showing one or the other (date or time).
Even on the back end of the database where the column properties are, I
have chosen the smallest date/time formats. When the aspx page runs, it
shows the date and time (ie:in a...
|
by: roshina |
last post by:
Hi
Iam facing a problem in my project, developing a web site for online shopping in ASP on windows XP using IIS server.
All the validations are ok but the new password is not upadated in the data base and also showing a error page.
the operating system we used is Windows XP,
the source code is ASP,
front end we used - HTML and
javascript and vb script for validations.
the inputs we used are :
old pasword :
|
by: =?Utf-8?B?a20=?= |
last post by:
I've got a simple C# app built in VS2005. When I click a menu item a modal
form opens and performs a lengthy operation in the Load event handler to
populate a text control, so it takes a few seconds before the modal form is
actually displayed. I would like to change the cursor to the WaitCursor
between the time that the menu item is clicked and the modal form is actually
visible.
I've tried setting the form's cursor in the Load event...
|
by: Robert S. |
last post by:
Searching some time now for documents on this but still did not find
anything about it:
Is it possible to replace the entry screen of MS Office Access 2007 -
that one presenting that default 'templates' (with that big graphic
buttons) - with some sort of own HTML-Page? I could imagine, that
somehow it is possible to change this construction (hopefully not
hardcoded in MS-Acc07), like it is possible to edit the 'Fluent Ribbon'?
If so...
|
by: Simon van Beek |
last post by:
Dear reader,
Under | Tools | Options | the form Options will open.
Under the tab you find the field "Default database folder".
By opening the form this field shows on my pc I:\.
I can't close the form because then the message pups up
"MS Office Access can't change the work directory to I:\ "
If I change it to D:\ I can close the form but by opening the form
again the field is still showing I:\.
|
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: 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...
|
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: 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...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |