Search results

Hello there! I have a main report with 2 subreports. For the main report, I assign the SQL code to the record source in the Report Module: Private Sub Report_Open(Cancel As Integer) RecordSource = gs_rpt_Recordsource_Parent End Sub However, I am not sure what code to use in order...

Hi there, I think this is a simple question. I want to do the following programmatically: I have a report with 2 subreports in it. I want to assign my SQL code to the recordsource for each report (3 total). I want to use the values from two text boxes (the start and end dates) in my SQL...

Hi there, I removed all the toolbars while I was in StartUp mode for my Access program. But now when I run it, it hides everything (I can't access the Tables, Design Mode...nothing). It's acting like I want it to when the user uses the program, but now I need to go back into the program and...

Hi there! When the user double-clicks on the 1st panel of my status bar, I want my whole program to end (it will have an "exit" icon on the panel), but I'm not sure how to write this. So far, I have: Private Sub sbStatusBar_DblClick() 'If user clicks on the first panel of the status bar then...

Hi there! I'm used to writing SQL stored procedures for SQL Server, so I'm not sure how to approach Access. I'd like to use a SQL statement, let's say SELECT * FROM ThisTable and then loop through the results of one field. I know how to do it with a stored procedure and Visual Basic, but not...