what should be Done to Make sure that the Check box in ms access will be unchecked wh

I'm student in aviation management. I don't have any background on IT/VBA. I were ask to do Questionnaire Using ms access but the problem is i have done the Questionnaire when the person answer and submit the answer. the answer save to the table and the problem start when the second person open the questionnaire there is still answer that have been answer. how can it be refresh when the second person enter the questionnaire will be clear.

Dec 4 '14 #1

Subscribe Post Reply

1104

twinnyfo

3,653

Expert Mod 2GB

Knight02,

If your Questionnaire is on a new record, all the responses should be blank. Is your form bound or unbound? A bound form should have no problems like this.

Dec 4 '14 #2

Dpot

If your form is bound to your table and still having this issue, try putting this code in your "Submit" button on click event.

Expand|Select|Wrap|Line Numbers

DoCmd.GoToRecord , , acNewRec

Dec 4 '14 #3

Knight02

Twinnyfo Sorry i don't quite understand... what do you mean by my form is bound or unbound? if the form is attach with the table mean it bound... yes my form is bound...

Dec 5 '14 #4

Knight02

Dpot may I know where to enter this code... sorry i have no IT nor VBA knowledge...

Dec 5 '14 #5

twinnyfo

3,653

Expert Mod 2GB

Knight,

Dpot has the right idea--as long as you go to a new record, your values should be clear for the new responses.

Dec 5 '14 #6

Knight02

twinnyfo okey... I don't know where to put the code given by the Dpot. If its in VB. I have tried so but no changes...

Dec 8 '14 #7

Dpot

Knight02,

Do you have a button on the form that must be clicked to submit your answers? If so go to the buttons "onclick" event in the properties menu, you paste the code in there.

Dec 8 '14 #8

by: BKM | last post by:

I've been using the following 2 ways to make sure my WebBrowser is finished loading a page before continuing with the next code. do:doevents:loop while WebBrowser.Busy do:doevents:loop until...

Visual Basic 4 / 5 / 6

Open Source DRM? What does everyone think about it? Will Open Source DRM ever catch up to MS DRM?

by: greatbooksclassics | last post by:

Open Source DRM? What does everyone think about it? Will Open Source DRM ever catch up to MS DRM? Will DRM ever be integrated into common LAMP applications?...

PHP

Access will not close

by: Jeff | last post by:

I have an access application that worked fine under access 97, however, when it was converted to access 2002, access would no longer close when the application was closed (using application.quit)....

Microsoft Access / VBA

How can I pad a number to make sure it's 5 chars in length?

by: jj | last post by:

example is I'm finding the max number within a certain criteria, and then adding one to that. However, most IDs are something like K00001 or R00223 So I want the next ID to be either K00002 or...

Microsoft Access / VBA

What techniques are key to Access performance with separate front-endand back-end Access implementation via a LAN?

by: Bob Alston | last post by:

Most of my Access database implementations have been fairly small in terms of data volume and number of concurrent users. So far I haven't had performance issues to worry about. <knock on wood> ...

Microsoft Access / VBA

How to make sure that data displayed on a form is the newest data?

by: Dino Buljubasic | last post by:

Hi, I am using VS2005 (C#) and SQL Server 2000. How can I make sure that: 1. Client A queries info from database and displays it in a list view or other controls on a form. If Client B...

C# / C Sharp

How to make sure an iFrame is referenced before pasting html into it (ping Martin Honen)

by: Laphan | last post by:

Hi The god that is Martin Honnen gave me a great tip to DOM/JS some HTML data into an iframe, but I need to make sure that the iframe is ready to take it before I paste it in. At the moment,...

Javascript

how to make sure this.Test() call base class method in base class constructor

by: Ryan Liu | last post by:

Hi, There is a method Test() implemented in base class and override in subclass. In base class itself, how to make sure this.Test() will just call implementation in base class only? ...

C# / C Sharp

Compile error: Make sure that the class defined in this code file.

by: Larry Epn | last post by:

I've created a project from Microsoft's "club.vsi". I don't want inline code so I've separated all aspx and ascx pages into code-behind pages. I'm compiling the project and continue to get this...

.NET Framework

How do I make sure that a asp page expires immediately and is not stored in the history ???

by: divya | last post by:

I have a page name edit.asp which should expire immediately .The user cannot open this page directly he has to provide a password for entering this page.thus when the user enters edit.asp , it has...

ASP / Active Server Pages

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

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

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

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...

Computer Hardware

What is ONU?

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,...

General

Changing the language in Windows 10

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...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

AI Job Threat for Devs

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,...

Career Advice

what should be Done to Make sure that the Check box in ms access will be unchecked wh

Similar topics