Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
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



 
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




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





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