Search results

Hi, Is it possible to access a tables data over multiple joins? For instance, for each row of Table A, I want the associated data from Table D. Is this possible in access? If it's not, could you suggest an alternative? Please see the example. Many Thanks. SELECT Table A.Person_Name, Table...

You're a star! That'll definitely work... right after I fix a problem I totally overlooked. I'll try and explain it as best I can. My SQL statement below retrieves the result based on matching the value assigned to "alpha" (which will eventually be a global variable which has the users network...

Hi guys, I'd like to set the controlsource of a subform's textbox. The subform is continuous. I declare an sql query on form load and wish to dynamically bind the fields from that query to the various objects on the form. Here is my code so far. Dim alpha As String Dim strSQL As...

Is it possible to update the "Source Object" of a subform dynamically? I'm using the below code to open an "edit" form based on a double click in some filtered results. I want to display the form that opens as the source object of a subform, is that possible? Private Sub...

Hi guys, I'm trying to print a report without actually viewing it and I've been messing around with this statement: 'DoCmd.RunCommand acCmdPrint' Is there anyway you can pass a report name to this command so it knows what to print (if printing what you're not viewing)? I would simply...

Sorry guys, nevermind. It turned out I had "Allow Edits" set to false. It's always the last place you look!! :D

Hi Guys, Background: I have a continuous subform within a form. The continuous form is used to display search results. Each search result (record) has a checkbox at the end to (hopefully) allow the user to select it to enter that record into a listbox which will allow the compilation of a...