A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need query to separate 2 entry types in a table field



 
 
Thread Tools Display Modes
  #31  
Old November 23rd, 2004, 06:37 PM
Jan Il
external usenet poster
 
Posts: n/a
Default

Hi Steve :-)

Jan,

Is frmCheckRegister open at the time? You might need a line like this
at the beginning of the procedure...
DoCmd.OpenForm "frmCheckRegister"


Blue Eagle 1, this is Blue Eagle 2, we have now neutralized the 'Bugger...
YES!! ;o))

And, what's the difference between a gizmo and a wazoolie?


Oh.....w'll....a gizmo is a thing....and.... a wazoolie is....eh...
everything. See...?


Thank you very much for all your time and help, and patience. I really do
appreciate it. :-)


Jan
Smiles are meant to be shared,
that's why they're so contagious.


Jan Il wrote:
Hi Steve :-)

No..sorry, that did get in there twice, a carry over I missed I guess.

I
have removed the one in the first line, and now have this code. I got

the
whole wazoolie this time. :-)

Private Sub fmeOptionGrp_AfterUpdate()

With Forms!frmCheckRegister
Select Case Me.fmeOptionGrp

Case 1
.RecordSource = "SELECT * FROM qryCkRegisterDan WHERE CheckNo

Not
Like 'DBT*'"
Case 2
.RecordSource = "SELECT * FROM qryCkRegisterDan WHERE CheckNo

Like
'DBT*'"
Case 3
.RecordSource = "qryCkRegisterDan"
End Select
End With

End Sub


But, the debugger is still barking at the line:
With Forms!frmCheckRegister

Clicking on the buttons is now firing a Runtime error 2450, and the

message
"Microsoft Access can't find the form 'frmCheckRegister' referred to in

a
Macro expression or Visual Basic code.

But, frmCheckRegister *is* the name of the Record Form to be opened and

the
data is to be displayed. I'm not sure I understand what is causing this
error message.

Thank you.

Jan



  #32  
Old November 23rd, 2004, 06:57 PM
Steve Schapel
external usenet poster
 
Posts: n/a
Default

Roger, 2. Very nice,

--
Steve Schapel, Microsoft Access MVP


Jan Il wrote:
Hi Steve :-)

Blue Eagle 1, this is Blue Eagle 2, we have now neutralized the 'Bugger...
YES!! ;o))

 




Thread Tools
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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Still Hoping for help with a Query problem Don Sealer Using Forms 15 November 13th, 2004 07:24 AM
Union Query Not Returning A Value Jeff G Running & Setting Up Queries 2 October 19th, 2004 05:47 PM
query a number stored as text Lee Running & Setting Up Queries 19 October 13th, 2004 04:10 AM
Using Start Date and End Date in Query ChuckW Running & Setting Up Queries 5 July 20th, 2004 02:52 AM
I can see the data but... David F-B General Discussion 3 June 24th, 2004 06:15 AM


All times are GMT +1. The time now is 01:11 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.