473,320 Members | 1,746 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,320 software developers and data experts.

Refresh/Requery ODBC linked queries on forms

24
Hi. Hope someone can help me. First off, I am not a developer and everything I know about VBA I taught myself.

I have 2 forms that have quite a bit of data on them. On a form called "Move Stock", I am creating a stock transfer in another database without any issues, but after this transaction has been completed (It is a basic Insert SQL query that I am running), I need the form to requery the available stock quantities. On Form Load, the available quantities are displayed by running a select from an ODBC Linked view in SQL using form text box values as parameters.

I have tried executing
Expand|Select|Wrap|Line Numbers
  1. Me.Requery
and
Expand|Select|Wrap|Line Numbers
  1. Me.Refresh
and the same on the actual controls, but the available quantities still stay exactly the same.

Can someone please try and assist me?
Jun 12 '15 #1

✓ answered by Seth Schrock

You say that you are getting your values from a SELECT statement being run in your Load event. Try running that same code as a replacement for you Me.Requery.

3 1533
Seth Schrock
2,965 Expert 2GB
The first thing that I would do is to make sure that your changes have been saved. Try going straight to your backend and run your query and see if it has the data changes.
Jun 12 '15 #2
DoubleD
24
Hi Seth. The changes are definitely saved. I can see the data that was inserted to the database.
Jun 12 '15 #3
Seth Schrock
2,965 Expert 2GB
You say that you are getting your values from a SELECT statement being run in your Load event. Try running that same code as a replacement for you Me.Requery.
Jun 12 '15 #4

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

Similar topics

0
by: Katuil Katuil | last post by:
Hello All: Have a problem that I have never seen before and have not found anything on technet on how to resolve it. I have a SQL Server 2000 server that I have created a new database. I then...
6
by: PMBragg | last post by:
Thank you in advance for any and all assistance. Is there a way to hide the Main Access window with tables, queries, forms etc programmatically? Michael
0
by: Dalan | last post by:
I'm sure there is a workaround for this, but haven't found it yet. I have a mainform with two subforms and after one or both of the subforms are updated, then clicking the Refresh button on the...
1
by: Lumpierbritches | last post by:
Thank you in advance. Is there a way to update Runtime Versions of Access 97, with just the Queries, Forms, Macros, and Modules, leaving the tables in tact? Is there a bit of code to do this, or...
6
by: Tim Marshall | last post by:
Here's the situation. A form, frmSetUp, with a subform control called subExplain with a source object form frmSetUpSubDefineSides. The source object is a bound form, displaying a few records, no...
7
by: Joe | last post by:
I am using Access 2003 and are linking to an Oracle 9i ODBC datasource (using Oracle ODBC drivers). After linking the tables in Access, I inspect the data contained in the linked tables. For...
3
by: nzaiser | last post by:
Hello! This is my first time asking a question here, so please bear with me if I seem 'unconventional!' My issue is this..... OS: Windows_NT App: MS Access 2000 (also in 2003) ODBC linked...
1
by: titli | last post by:
Hi All, Please tell me the best solution to implemenet security in access databases , to save the tables, queries, forms , reports as well as the VBA code from user access. The users of the...
1
by: Cathy Hosek | last post by:
Hi all, I have an ODBC linked table with a 3-field combo key. I am trying to link to a local table using the relationships window. I can drag the first line fine, but when I try to drag the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.