You need to use the name of the > subform control, i.e. A blank page meaning, I get the report, but no text boxes are filled in. Similar Threads Re: Macro Error: & "Function is not available in expression in criteria expression" Douglas J. This is what I typed in: > > Option Compare Database > > Public Sub frInvDt() > > Select Case Me.frInvDt > Case 1 ' current invoice > DoCmd.OpenReport "rptInvDt", , http://knowaretech.com/access-cannot/access-cannot-connect.html
the "box" on the main form that houses the subform. textbox) named InvNum on the form? so that's where you enter the code in there. Screen shot attached seems to work, so Thank you, Rey. http://www.utteraccess.com/forum/index.php?showtopic=1967450
legalhustlerView Member Profile Nov 10 2014, 07:56 PM Post#9Posts: 371Joined: 4-September 14QUOTE (gemmathehusky @ Nov 10 2014, 07:19 PM) for something like this, I would put all these action types in Mark C--Users-Drelinger.D179434-Desktop-C.JPG 0 Message Author Closing Comment by:drelinger2015-12-08 much appreciated. I forgot with a macro you don't have to do the whole code. I keep getting the report, but it's blank.
the "box" on the main form that houses the subform. > > If you are in the VB Editor, and type Me.qry and see if the > "intellisense" autocompletion fills in Do you imagine that the error reference to LinkMasterFields relates to a subform on the form, or a subreport on the report? If you like, you can copy/paste the SQL view of the query into your reply here. -- Steve Schapel, Microsoft Access MVP Antney wrote: > Your code seems perfect. All rights reserved.
Ok, you said you tried that, and got the "invalid outside procedure" error message. BoHr Reply With Quote Quick Navigation Microsoft Access Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix So I changed the code a little and added > more parentheses. check these guys out Sign Up Now!
Maybe add a yes/no checkbox for whatever purpose you are selecting these. Thanks for your reply! My subform name is > > qryInvDt subform. U… MS Access Windows OS Visual Basic Classic Using a Criteria Form with an Access Report Video by: TechMommy Show developers how to use a criteria form to limit the data
Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 23 http://www.pcreview.co.uk/threads/re-access-cannot-parse-the-expression.2799609/ Private Sub frInvDt_Click() End Sub .... I expect the Click event of a command button on the form is likely what you are doing. Do I need to declare it?
These functions are part of the Windows API (Application Programming Interface). http://knowaretech.com/access-cannot/access-cannot-email.html By default, they are > named the same, but not necessarily. Steve Schapel, Dec 26, 2006 #8 Steve Schapel Guest Antney, Excellent! Join our community for more solutions or to ask questions.
I may have to change where I put this code??? Assuming it is a query, does it have any criteria "hard-wired" in there that might be excluding the required data. Got any ideas? this contact form Yes, my password is: Forgot your password?
Major kudos for > your perseverence and patience. For > > example, within my option group on the form. PC Review Home Newsgroups > Microsoft Access > Microsoft Access > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles Quick Links
I've looked at the code and the report and form. If I just program the toggles separately? > Here is what I have now: > > Option Compare Database > > Private Sub Toggle15_GotFocus() > Select Case Me.frInvDt > Case 1 the "box" on the main form that houses the subform. textbox) named InvNum on the form?
I can print all the invoices for the date showing > in the combo box, but for some reason, I can't print the current invoice > showing. By default, they are named the same, but not necessarily. Private Sub frInvDt_AfterUpdate() Select Case Me.frInvDt Case 1 ' current invoice DoCmd.OpenReport "rptInvDt", , , "[InvNum] =" & Me.YourSubform.Form!InvNum Case 2 ' selected date DoCmd.OpenReport "rptInvDt", , , "[InvDt] =" & navigate here kevinlawView Member Profile May 21 2011, 12:35 PM Post#5Posts: 1,283Joined: 15-April 04That's very good to know- that DCount is the choice for records- very useful in a lot of situations and
I don't > think I need the Cases anymore. HomeForumsWikiLinks HelpGuidelinesActive TopicsSearch Search this forum only?More Search Options [X]My Assistant Loading. I just forgot the underscore: qryInvDt_subform. Login with LinkedIN Or Log In Locally Email Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find A Forum Thread Number Find An Expert Resources Jobs
It > seems to be working. The user can press down Toggle > > 15, print invoice shown, or press down Toggle 16, print all invoices for this > > date. > Guest, Dec 26, 2006 Sorry, I just assumed the InvNum was a number - I should have checked that out. You'll be able to ask questions about MS Office or chat with the community and help others.
I do think that this has to do with the > subform's Masterfield. RBrandt at Hunter dot com Rick Brandt, Dec 26, 2006 #1 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? Try VB code. It's a separate question.
I keep getting method or data member > > not found where my subform name is supposed to go. Log in or Sign up PC Review Home Newsgroups > Microsoft Access > Microsoft Access > Re: Access cannot parse the expression Discussion in 'Microsoft Access' started by Steve Schapel, Dec I believe macro's (not VB) also know the MsgBox function, but its different, because it only shows a message with only OK.