Search results

I have a Function that I call whenever I need to lock down all of the controls and I use it in the form load event of my form. With this code, you can still navigate through your subform. Private Function Lockdown() 'locks controls at load For Each tb In Me.Controls If TypeOf...

Thanks again for the advise!

Ok, it is finally working! Thanks JHB for the help! This is what is looks like now: Private Sub cmdGenerateReport_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strCaseFieldSelected As String, strCaseValueSelected As String Set db = CurrentDb If...

JHB, The recordsource is the same query for the that supplies the subform: Here is the code that fills the subform strSQL = "SELECT [" & strQueryFieldSelected & "],* FROM QCaseReportFill WHERE [" & strQueryFieldSelected & "] = '" & strQueryValueSelected & "' ORDER BY '" &...

I tried your suggestion, but the report now shows #name? for all of the fields. Arrgh, this is so frustrating. It seems like it would be so easy that if the subform is getting the correct records that you can create a report from the subform.

JHB, Thanks for the reply! I have tried this, but it is not working yet: Private Sub cmdOpenReport_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strQueryFieldSelected As String, strQueryValueSelected As String If lstQValues.ListIndex <> -1 And...

Thanks for the reply The_Doc_Man! I am new to Access and did not know what the general practice was concerning the storing of Word forms.

Hello all, I have asked a similar question before and with the help of another member I was able to generate a report using querydefs, but it does not seem to work with my current query. The only difference between my other query and the new one is that the old one used a single source...

Anyone have any ideas why I have to click my "Generate Form" button twice to make the Word form open up? Also, how do I make the Word doc be on top of my access form?

Thanks again for the quick help Jiri!

Maybe I should just use a simple form with a textbox to populate the selection from formA to make things easy. I think I make things a little too complicated at times or better yet, I could just place the textbox below the search box

Jiri, Sorry for the confusion. I am not the best at trying to write what I am trying to accomplish. This is what I originally wanted and you have help me accomplish this, thank you! Now on the second form (formB) with the second listbox (listboxB), I have a subform that was populated by...

Jiri, I have the code working part way thanks to you. I appreciate the help. This is what I have now. When I click the "View Record" Button on formA, it opens formB and the record selected in formA listboxA is now selelcted in formB listboxB. Private Sub cmdSearchSelect_Click() 'opens form...

Hello all, Yet another question of many to come, lol. I have a listboxA on formA and a listboxB on formB. When the user clicks an item in listboxA and then presses the view record I want formB to open and the item selected in listboxA should select the same record in listboxB. This is the...

Thanks for the help jdraw!

jdraw, I get an automation error and it highlights this section: Set objProcesses = GetObject("winmgmts://" & Environ$("GB03300400005") _ & "/root/cimv2").ExecQuery("SELECT * from Win32_Process") Maybe something to do with the computer name? this is a network computer that I am on. Jiri...

jdraw, I'll try it when I get back into work in the morning. I appreciate the help.

jdraw, I get an error message "Ambiguous name detected: IsExeRunning" Also, I am suppose to place my computer name in the function ***UPDATE*** Scratch the Ambiguous part, I copied and pasted your code with the Public Function part. ***Another UPDATE*** -214217375 Automation Error

Thanks jdraw, I'll give it a try!

Sorry for the general question. It is with the code to generate a word from from access. Private Sub cmdPrintCCUForm_Click() Dim appWord As Word.Application Dim doc As Word.Document On Error GoTo errHandler 'Set appWord object variable to running instance of Word...