Refresh Form Bound table in VBA help - Microsoft Access / VBA

KayC

Hi
Background info:
I am running Access 2000
I have a form bound to a blank table
When a user clicks a button the form opens in datasheet view
User enters data into form and closes form
User clicks button which then creates an inner join between form bound
table and master table and updates records in master table where values

are equal to form bound table
My problem is that when the form is closed Access does not recognise
that there is data in the bound table, I have tried refreshing the
tabledef to no avail

Can anyone help?
Regards
Kay

Sep 26 '06 #1

Subscribe Reply

6183

Arno R

"KayC" <ka******@yahoo .co.ukschreef in bericht news:11******** **************@ i42g2000cwa.goo glegroups.com.. .

Hi
Background info:
I am running Access 2000
I have a form bound to a blank table
When a user clicks a button the form opens in datasheet view
User enters data into form and closes form
User clicks button which then creates an inner join between form bound
table and master table and updates records in master table where values

are equal to form bound table
My problem is that when the form is closed Access does not recognise
that there is data in the bound table, I have tried refreshing the
tabledef to no avail

Can anyone help?
Regards

Are you sure the data is still in the table after closing the form ??
Check: Can you see the records when opening the table??

If you can see them, Access can also ....
I guess 'something else' is wrong.

Arno R

Kay

Sep 26 '06 #2

Jamey Shuemaker

You lost me at "Background info:"

1. Why is the table blank? Is it some sort of temporary data container
that is populated by the form you mention, then has its data
transferred elsewhere, and finally all records deleted?

2. What's up with the dynamic relationship settings? Why not just
define the relationship as a left or right to achieve what you need and
skip the coding of the relationships?

Somehow the data in that table is getting deleted or the update to the
underlying table is never happening. It's possible that Access
encounters an error when the form is closed and never saves the data in
the modified record.

More details, please...

KayC wrote:

Hi
Background info:
I am running Access 2000
I have a form bound to a blank table
When a user clicks a button the form opens in datasheet view
User enters data into form and closes form
User clicks button which then creates an inner join between form bound
table and master table and updates records in master table where values

are equal to form bound table
My problem is that when the form is closed Access does not recognise
that there is data in the bound table, I have tried refreshing the
tabledef to no avail

Can anyone help?
Regards
Kay

Sep 26 '06 #3

KayC

Hi Arno, Jamey
That is correct the table is a temporary one (used as temp mapping
table) to update Master table
I think you guys are right... must be some action connected to the form
event
I will take a look
Thanks
Kay

Jamey Shuemaker wrote:

You lost me at "Background info:"

1. Why is the table blank? Is it some sort of temporary data container
that is populated by the form you mention, then has its data
transferred elsewhere, and finally all records deleted?

2. What's up with the dynamic relationship settings? Why not just
define the relationship as a left or right to achieve what you need and
skip the coding of the relationships?

Somehow the data in that table is getting deleted or the update to the
underlying table is never happening. It's possible that Access
encounters an error when the form is closed and never saves the data in
the modified record.

More details, please...

KayC wrote:
Hi
Background info:
I am running Access 2000
I have a form bound to a blank table
When a user clicks a button the form opens in datasheet view
User enters data into form and closes form
User clicks button which then creates an inner join between form bound
table and master table and updates records in master table where values

are equal to form bound table
My problem is that when the form is closed Access does not recognise
that there is data in the bound table, I have tried refreshing the
tabledef to no avail

Can anyone help?
Regards
Kay

Sep 27 '06 #4

Similar topics

4130

Access 97 Data entry form questions

by: Iain Miller | last post by:

Struggling a bit here & would be grateful for any help. I have a table which has a list of people in it. Each person has a unique ID automatically allocated by Access but also belongs to one of 5 Groups - call them A to E. I'd like to generate a further automatic reference number based on something like Group/Unique ID so when I create a...

Microsoft Access / VBA

3460

DLookup in TabControl in Form

by: LSemos | last post by:

I am trying to lookup phone numbers in a separate table based on the name in the current Tab control tblContacts has the fields: Name, Phone, Fax, and Email In my Form's Tab control, I have the fields: DVP, Phone, Fax and Email. In the On Click properties of the Phone field, I have the following: =DLookUp("","","='" & & "'")

Microsoft Access / VBA

4895

Data Binding GUI refresh

by: Matthias | last post by:

Hi Team this may be a newbie question. I have searched the discussions before posting: I'd like to re-use a form instance to edit record details. My data binding (a DataTable bound to TextBoxes) works fine the first time round. I can see, edit and update the details from my form, then close the form. I then like to select and refill...

Visual Basic .NET

6320

Refresh BindingSource .net 2005

by: Bryan Shaw | last post by:

I have a Windows app I am developing in VS .NET 2005 that is required to periodically look at the data in a table in an MS SQL 2000 database. The data is being changed from an external stored procedure. All I want the app to do is refresh the data bound controls on a timer tick. I am using the new TableAdapter and BindingSource controls...

C# / C Sharp

2248

Sometimes when I attempt to refresh records in a subform control on the main form - it doesn't work

by: MLH | last post by:

I don't always get what I want when I invoke the following Me!MySubFormControl.Refresh from code running in the main form. Am I doing something wrong here? Someone suggested that I open the subform itself (as a separate form) in hidden view anytime I open the main form and attempt my refreshes there. I think that is somewhat redundant...

Microsoft Access / VBA

7507

DataGridView.Refresh() hangs on cross-thread call

by: David Cartwright | last post by:

Hi all, I'm having a weird time with a call to the Refresh() method of a DataGridView. I have a VB.NET 2005 Windows application with a main form and a "worker" thread. The main form delegates a Sub to the worker so that the latter can refresh the DataGrid after updating the DataTable driving it. When I run the app under the debugger,...

.NET Framework

59097

Example Filtering on a Form.

by: NeoPa | last post by:

CHAPTER 1 - TABLE OF CONTENTS (Including attached database) CHAPTER 2 - INTRODUCTION CHAPTER 3 - TABLE LAYOUT CHAPTER 4 - FORM LAYOUT CHAPTER 5 - FORM MODULE CHAPTER 6 - CODE DISCUSSION (FILTER CONTROLS) CHAPTER 7 - CODE DISCUSSION (THE REST) --------------------------------------------------------------------------------

Microsoft Access / VBA

2343

Refresh Listbox from Other Form

by: Randy | last post by:

Hi, I've got a listbox on a form that gets updated by opening another form for data entry. Once the user enters the new item name and clicks "accept", the data entry form closes and the original form with the listbox displays. I'm having trouble getting the listbox to reflect the additional entry. If I close the form and reopen it, the new...

Visual Basic .NET

5412

How to Refresh Datagrid Control?

by: =?Utf-8?B?TWFyaw==?= | last post by:

Hi - I'm having trouble refreshing a datagrid control bound to a dataset that was created from the New Data Source wizard. What is the code required to refresh the datagrid with data from the data source (sql db)? More Details: The application is C# Windows (VS 2005).

C# / C Sharp

7665

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

General

7583

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7888

Problem With Comparison Operator <=> in G++

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

C / C++

7950

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

General

6255

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5484

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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

Microsoft Access / VBA

3626

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1200

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

924

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General