UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Run Time Error '2103'    
 
   
PhilTFC
post Nov 6 2011, 01:06 PM
Post#1



Posts: 10
Joined: 16-July 11



Hi
I am trying to preview a report (selected from a list box). my command button has this code attached
Private Sub Open_Report_Click()
DoCmd.OpenReport Me.qmyrpt.Value, acViewReport
End Sub
The list box is populated from........ SELECT MSysObjects.Type, MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=-32764));
When i select the command button i get a "Run time error '2103' iconfused.gif
I am using Access 2007
any help will be very much appreciated
Go to the top of the page
 
theDBguy
post Nov 6 2011, 01:08 PM
Post#2


Access Wiki and Forums Moderator
Posts: 74,177
Joined: 19-June 07
From: SunnySandyEggo


Hi,
welcome2UA.gif
Not sure what error 2103 means but try changing your listbox Bound Column property to 2.
Just my 2 cents... 2cents.gif
Go to the top of the page
 
PhilTFC
post Nov 6 2011, 02:03 PM
Post#3



Posts: 10
Joined: 16-July 11



thank you so much.. it works a treat
Go to the top of the page
 
theDBguy
post Nov 6 2011, 02:34 PM
Post#4


Access Wiki and Forums Moderator
Posts: 74,177
Joined: 19-June 07
From: SunnySandyEggo


Hi,
Glad to hear it worked for you. Good luck with your project.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    17th January 2019 - 04:12 PM