Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
Login | Sign Up
Loading... 

Thread: Open report
Started 4 months, 1 week ago by Jayde
I have a form that contains a button to open a report of the current data that was entered. The code that opens the report: DoCmd****nCommand acCmdSaveRecord DoCmd.OpenReport "rptPatients", acViewPreview, , PatientID = " & Me![PatientID]" this code opens the report but when it opens it is blank. Can someone help me get this report to open the current record that was entered? ...
Site: dBforums - Database Support Community  dBforums - Database Support Community - site profile
Forum: Microsoft Access  Microsoft Access - forum profile
Total authors: 6 authors
Total thread posts: 12 posts
Thread activity: no new posts during last week
Domain info for: dbforums.com

Other posts in this thread:

Jayde Registered User replied 4 months, 1 week ago
I have a form that contains a button to open a report of the current data that was entered. The code that opens the report: DoCmd****nCommand acCmdSaveRecord DoCmd.OpenReport "rptPatients", acViewPreview, , PatientID = " & Me![PatientID]" this code opens the report but when it opens it is blank. Can someone help me get this report to open the current record that was entered? ...
Size: 625 bytes
Customize:  Customize "<b>Reply 1</b>: Open report :: Microsoft Access :: dBforums - Database Support Community"

NTC Registered User replied 4 months, 1 week ago
don't understand this at all: DoCmd****nCommand acCmdSaveRecord is your problem that it is a brand new record? - and thus the table isn't getting the record before the open report command?? if so add a me.dirty=false in the command event before the report open...
Size: 291 bytes
Customize:  Customize "<b>Reply 2</b>: Open report :: Microsoft Access :: dBforums - Database Support Community"

NTC replied 4 months, 1 week ago
don't understand this at all: DoCmd****nCommand acCmdSaveRecord is your problem that it is a brand new record? - and thus the table isn't getting the record before the open report command?? if so add a me.dirty=false in the command event before the report open...
Size: 291 bytes
Customize:  Customize "<b>Reply 3</b>: Open report :: Microsoft Access :: dBforums - Database Support Community"

Jayde Registered User replied 4 months, 1 week ago
DoCmd****nCommand acCmdSaveRecord im sorry about the stars but this line saves the record to the table(i think...) im a novice so excuse. Tried the Me.Dirty it doesn't work
Size: 172 bytes
Customize:  Customize "<b>Reply 4</b>: Open report :: Microsoft Access :: dBforums - Database Support Community"

Jayde replied 4 months, 1 week ago
DoCmd****nCommand acCmdSaveRecord im sorry about the stars but this line saves the record to the table(i think...) im a novice so excuse. Tried the Me.Dirty it doesn't work
Size: 172 bytes
Customize:  Customize "<b>Reply 5</b>: Open report :: Microsoft Access :: dBforums - Database Support Community"

Jayde Registered User replied 4 months, 1 week ago
its DoCmd****nCommand acSaveRecord i don't y the stars keep goin there
Size: 70 bytes
Customize:  Customize "<b>Reply 6</b>: Open report :: Microsoft Access :: dBforums - Database Support Community"

Jayde replied 4 months, 1 week ago
its DoCmd****nCommand acSaveRecord i don't y the stars keep goin there
Size: 70 bytes
Customize:  Customize "<b>Reply 7</b>: Open report :: Microsoft Access :: dBforums - Database Support Community"

NTC Registered User replied 4 months, 1 week ago
Dim strWhere as Integer strWhere = "[ID] = " & Me.[PatientID] DoCmd.OpenReport "rptPatients", acViewPreview, , strWhere If your primary key is a Text type field (not a Number type field), you need extra quotes: strWhere = "[ID] = """ & Me.[PatientID] & """" and of course Dim as a String
Size: 454 bytes
Customize:  Customize "<b>Reply 8</b>: Open report :: Microsoft Access :: dBforums - Database Support Community"

NTC replied 4 months, 1 week ago
Dim strWhere as Integer strWhere = "[ID] = " & Me.[PatientID] DoCmd.OpenReport "rptPatients", acViewPreview, , strWhere If your primary key is a Text type field (not a Number type field), you need extra quotes: strWhere = "[ID] = """ & Me.[PatientID] & """" and of course Dim as a String
Size: 454 bytes
Customize:  Customize "<b>Reply 9</b>: Open report :: Microsoft Access :: dBforums - Database Support Community"

healdem jaded developer replied 4 months, 1 week ago
Quote: Originally Posted by Jayde its DoCmd****nCommand acSaveRecord i don't y the stars keep goin there the asterisks appear becuase of a spam filtert installed when we were plagued with spam promotoing roumanian porn sites so the offendeing . r u was edited out so it shoud read dodmd. r u ncommand
Size: 953 bytes
Customize:  Customize "<b>Reply 10</b>: Open report :: Microsoft Access :: dBforums - Database Support Community"

 

Top contributing authors

Name
Posts
Jayde Registered User
3
user's latest post:
Open report
Published (2009-11-13 10:56:00)
its DoCmd****nCommand acSaveRecord i don't y the stars keep goin there
Jayde
3
user's latest post:
Open report
Published (2009-11-13 10:55:00)
DoCmd****nCommand acCmdSaveRecord im sorry about the stars but this line saves the record to the table(i think...) im a novice so excuse. Tried the Me.Dirty it doesn't work
NTC Registered User
2
user's latest post:
Open report
Published (2009-11-13 12:32:00)
Dim strWhere as Integer strWhere = &quot;[ID] = &quot; &amp; Me.[PatientID] DoCmd.OpenReport &quot;rptPatients&quot;, acViewPreview, , strWhere If your primary key is a Text type field (not a Number type field), you need extra quotes: strWhere = &quot;[ID] = &quot;&quot;&quot; &amp; Me.[PatientID] &amp; &quot;&quot;&quot;&quot; and of course Dim as a String
NTC
2
user's latest post:
Open report
Published (2009-11-13 12:32:00)
Dim strWhere as Integer strWhere = &quot;[ID] = &quot; &amp; Me.[PatientID] DoCmd.OpenReport &quot;rptPatients&quot;, acViewPreview, , strWhere If your primary key is a Text type field (not a Number type field), you need extra quotes: strWhere = &quot;[ID] = &quot;&quot;&quot; &amp; Me.[PatientID] &amp; &quot;&quot;&quot;&quot; and of course Dim as a String
healdem jaded developer
1
user's latest post:
Open report
Published (2009-11-13 12:43:00)
Quote: Originally Posted by Jayde its DoCmd****nCommand acSaveRecord i don't y the stars keep goin there the asterisks appear becuase of a spam filtert installed when we were plagued with spam promotoing roumanian porn sites so the offendeing . r u was edited out so it shoud read dodmd. r u ncommand
healdem
1
user's latest post:
Open report
Published (2009-11-13 12:43:00)
Quote: Originally Posted by Jayde its DoCmd****nCommand acSaveRecord i don't y the stars keep goin there the asterisks appear becuase of a spam filtert installed when we were plagued with spam promotoing roumanian porn sites so the offendeing . r u was edited out so it shoud read dodmd. r u ncommand

Related threads on "dBforums - Database Support Community":

Can't open report...any way to open without the data?  dBforums - Database Support Community - site profile Crystal Reports - forum profile Can't open report...any way to open without the data?
Can't open report...any way to open without the data?
Open Report to specific record  dBforums - Database Support Community - site profile microsoft.public.access.modulesdaovba - forum profile Open Report to specific record
Open Report to specific record
Open Report filted by value in a control  dBforums - Database Support Community - site profile Microsoft Access - forum profile Open Report filted by value in a control
Open Report filted by value in a control
Open Report Using a Forms Filter - and Sort  dBforums - Database Support Community - site profile Microsoft Access - forum profile Open Report Using a Forms Filter - and Sort
Open Report Using a Forms Filter - and Sort
Open a report from an open record  dBforums - Database Support Community - site profile Microsoft Access - forum profile Open a report from an open record
Open a report from an open record
Why can't I open a report using VB?  dBforums - Database Support Community - site profile microsoft.public.access.modulesdaovba - forum profile Why can't I open a report using VB?
Why can't I open a report using VB?
Open a report for a list query  dBforums - Database Support Community - site profile microsoft.public.access.modulesdaovba - forum profile Open a report for a list query
Open a report for a list query
Can A Form Be Created In Acces To Open A Crystal Report?  dBforums - Database Support Community - site profile Microsoft Access - forum profile Can A Form Be Created In Acces To Open A Crystal Report?
Can A Form Be Created In Acces To Open A Crystal Report?
Crosstab report cannot open - data not there  dBforums - Database Support Community - site profile Microsoft Access - forum profile Crosstab report cannot open - data not there
Crosstab report cannot open - data not there
Open a report using a listbox as a parameter  dBforums - Database Support Community - site profile Microsoft Access - forum profile Open a report using a listbox as a parameter
Open a report using a listbox as a parameter

Related threads on other sites:

Nachrichten-Magazin | Internetzeitung | OPEN-REPORT.de...  piratennews - Identi.ca - site profile piratennews - forum profile Nachrichten-Magazin | Internetzeitung | OPEN-REPORT.de - «Löschen statt sperren» | OPEN-REPORT.de - So haben wir... - http://is.gd/5d1XS
Nachrichten-Magazin | Internetzeitung | OPEN-REPORT.de - «Löschen statt sperren» | OPEN-REPORT.de - So haben wir... - http://is.gd/5d1XS
Cannot open report document. --- Failed to open report  BOB: BusinessObjects Board - site profile XI Servers - forum profile Cannot open report document. --- Failed to open report
Cannot open report document. --- Failed to open report
Macro to open report, and run the macro inside the report.  MrExcel Message Board - site profile Excel Questions - forum profile Macro to open report, and run the macro inside the report.
Macro to open report, and run the macro inside the report.
Report: London Stock Exchange will move to Linux...  scccpj - Identi.ca - site profile scccpj - forum profile Report: London Stock Exchange will move to Linux http://www.h-online.com/open/Report-London-Stock-Exchange-will-move-to-Linux--/news/114393
Report: London Stock Exchange will move to Linux http://www.h-online.com/open/Report-London-Stock-Exchange-will-move-to-Linux--/news/114393
On button click,print report,open report in pdf  Forums - ASP.NET Forums - site profile SQL Server Reporting Services - forum profile On button click,print report,open report in pdf
On button click,print report,open report in pdf
Cannot open report viewer control\u0027s report designer  MSDN Forums - site profile Visual Studio Report Controls - forum profile Cannot open report viewer control\u0027s report designer
Cannot open report viewer control\u0027s report designer
Can't open report...is there an option to open without data?  CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions - site profile Crystal Reports - forum profile Can't open report...is there an option to open without data?
Can't open report...is there an option to open without data?
Open report with "Save as" and "Open...  www.oracle.com - site profile Application Express - forum profile Open report with "Save as" and "Open with" dialogue
Open report with "Save as" and "Open with" dialogue
Not able to create New Report or open report in Edit mode!  BOB: BusinessObjects Board - site profile WebIntelligence Version 6 - forum profile Not able to create New Report or open report in Edit mode!
Not able to create New Report or open report in Edit mode!
When I open Report Center all it shows it text, how do i...  Forums - Intuit Community - site profile Reports - forum profile When I open Report Center all it shows it text, how do i fix it , to show my report again?
When I open Report Center all it shows it text, how do i fix it , to show my report again?
Thread profile page for "Open report" on http://www.dbforums.com. This report page is a snippet summary view from a single thread "Open report", located on the Message Board at http://www.dbforums.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity
 1   2   Next »