Search results for query: *

I already have this code. On Error GoTo Err_cmdRunReport_Click Dim stDocName As String Dim strWhere As String If Not IsNull(Me.List37) Then Select Case Me.List37 Case Else ' strWhere = strWhere & BuildWhere() stDocName =...

I put the code in a module and on the textbox I put =GetDateLastModified and I still get the same error. What am I doing wrong?

How do I get the date listed as in a text box on the report?

I need a way to get the FileDateTime of a html file that I am importing to a table. I am basically wanting to show on a report the last date and time the data was updated. I tried putting a text box on the report and putting =FileDateTime("filename.html") but that didn't work. I then get an...

IT WORKS!!!! YAAAAAHHHHHH!!!! Thanks for being patient with me!!!!

Well this about my 2nd time using code in access. I usually use the tools and expression builders. I'm learning. Have any recommended reading on how to layout your names, etc? I really appreciate your help!!

Ok it's saying Compile Error: Sub or Function not defined Here is what I have now... ******************************** Private Sub Command36_Click() On Error GoTo cmdRunReport_Click_Error On Error GoTo Err_cmdRunReport_Click Dim stDocName As String Dim strWhere As String If...

Ok I'm getting closer. Should lboReport be replaced with my table where the reports are housed? I really appreciate your help! Sorry I don't have a good understanding of this!

Ok my problem is know how to set up my table with report names. It currently is like this: ***************************** Report (column header) Cumulative Customer Accuracy Weekly Customer Accuracy Cum/Weekly Customer Accuracy ***************************** I don't have two columns. So do I have...

Where do I put the code? I currently have it in the subform: Private Sub Form_Open(Cancel As Integer) The other is in my list box: Private Sub List32_AfterUpdate() Sorry I'm not very good with VBA yet...

I can't get it. Is there an easier way to list reports in a table bind the listbox to that table and click the report you want to preview and it automatically run it?

Do you have any sample code?

I have an Access Database that I am trying to list reports that can be run in a Listbox that is linked by the control source to a table. When a report is clicked on I want it to come up with Output To selection. I am using this code to do that: DoCmd.OpenReport List32, acViewPreview I am also...