Recent content by velcrowe

Would the code look something like this: If forms!FormB.isloaded then docmd.close acform "formB" Else... Thank you

I have a search field on my form A that opens another form B to show the list of records I'm looking for in the database. I can click on a list item in form B and it will open the record in form A. Once an item is clicked in form B it hides in the background of form A so I can refer back to the...

I have a database that is split with the forms, queries, and reports representing the front end and linked to tables my users cannot access on the back end. I've compacted the database and due to the number of forms, queries, and reports the front end is 55mb. I have to keep the database in MS...

I am using a simple macro with sendobject to automatically send an e-mail message to my user group. I downloaded Redemption and checked off the reference in MS Outlook and MS Access. When I run the macro I still get the Outlook warning. How can I adjust Access or Outlook to have it work...

I am trying to place a command button on my form that will convert a report to pdf. I can e-mail through adobe. My issue that I don't want to select a report from a list as setup successfully by Leban. I would like the code to be setup to print the only report needed from my form. In this...

The code now is Private Sub List109_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.frmConsultantsSubform.Form.Recordset.Clone rs.FindFirst "[txtPurchaseOrderNo] = '" & Me![List109] & "'" If Not rs.EOF Then Me.Bookmark =...

When I click on the consultant name, why doesn't Access go the the record where the consultant name appears on the subform.

Sorry about that, I added the form.recordset.clone and I no longer receive the data member message but as I click the consultant name it's not taking me to that actual record, but i am working on it. thank boblarson and pbaldy

I am sorry but I think I making this more difficult than necessary I changed the syntax and now I get that the Method or Data Member is not found, because me.frmConsultantSubform.recordset is not an available method. I don't know what to do

I tried this and get the error message Access can't find the subform Set rs = Forms!frmConsultantSubform.Recordset.Clone rs.FindFirst "[txtPurchaseOrderNo] = '" & Me![List109] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark I am trying to set the rs to the txtpurchaseOrderNo...

I am using this Access code (as provided by the lookup wizard) to search a field on my form and on the click event of the lookup list, i will go to that record. ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst...

I combined some of all your post to come up with this answer: In the onclick event of my command button for the report I typed If me.checkbox = true then me.checkbox.value = 2007 and so on for each box. There's only five and it's working great. I get the value and the check and clear check...

Thank you so much for all your help. As I click the box it sets the value to 2007 so that I can run filter the results for my report. That works fine. I just don't know how to say that if it's check or the field has a value then set the value to null or clear the check. If I make the default...

If I check the box so that the value = 2007, like this me.checkbox.value = 2007, what code would I use to click on the box again and remove the value. If me.checkbox.value = 2007 then me.checkbox.value = null does not work. Any help is greatly appreciated. :o

How would I then clear a box that's selected without using an event from the other check boxes? For instance, I select box 1, change my mind and need to clear the check from box 1...without clicking on box 2 or 3. Almost like turning on a switch and then turning it off. I ask because I need...