Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Databases Basics
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 9th, 2006, 11:50 AM
Authorized User
 
Join Date: Apr 2004
Location: Cape Town, , South Africa.
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to lizhaskin
Default URGENT Problems in Access 2000

Hi there
Can someone give me some URGENT advice? I have written a database in Access 2003, which for some of the users is used in Access 2000. For these users, I have converted it to 2000 format, but am experiencing some problems. One situation in particular is a form (Bookings) which has a sub form (SalesInput) which in turn has another sub form (SalesSub) . On the Form SalesInput, I have a command button (Command34) which when clicked updates the data in the SalesSub form. In 2003, I use the following code very successfully.

Private Sub Command34_Click()
Dim strMsg As String

DoCmd.SetWarnings False

If IsNull(Me!InvNo) Then
    Label35.Visible = True

Else
    Label35.Visible = False
    DoCmd.GoToControl "SalesSub"
    DoCmd.OpenQuery "InvoiceAppend"
    DoCmd.Requery
End If
End Sub

However in 2000, it gives me an error on the “DoCmd.Requery” line. Is there a different syntax I should use for 2000?
Thanks to anyone who can help
Liz



Reply With Quote
  #2 (permalink)  
Old February 10th, 2006, 08:52 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Please post in Microsoft Office > Access VBA

I think the Requery needs a reference. Can you refer to the control in this code? If you are requerying the recordsource for one of your subfoms, I am not sure how you might do that.

A hardcore approach might be to freeze the screen, then close and reopen the whole form system while referring to the current PK on the main form.

HTH


mmcdonal
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems after upgrading to Windows 2000 morphy Beginning VB 6 2 March 10th, 2005 08:15 PM
Excel 2000 VBA Problems drsammyb Excel VBA 0 January 17th, 2005 11:41 AM
Heeeelppp !!! Problems Compacting Access 2000 timmaher Access 2 August 13th, 2004 05:32 AM
SQL SERVER 2000 AND ACCESS 2000 ckentebe SQL Server 2000 3 June 17th, 2004 08:50 PM
Problems with string functions and Access 2000 giggs Access VBA 5 February 25th, 2004 09:43 AM



All times are GMT -4. The time now is 12:40 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.