Search results

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...

Where would I place this code? Would I create an event procedure for the check box or would it go on the form? I have three check boxes on the form so I may need to select two out of three, and so on

I don't know how difficult this is but, I would like to uncheck a check box when I don't want that value filtered on my form. I know all the check boxes are cleared when the form is closed. I just want to select the value of the check box and if I don't want it, uncheck it. Thank you:rolleyes:

I have an option group I created by using the wizard for the form. Everything works fine. I selection the radio button and it filters the data for the report. I would like to be able to select multiple radio buttons and received the combined data on my report. Ex. I select records for 2007 &...

I have hyperlinks to my orders folder, all of which are PDF files. When I click the hyperlink it appears as if Abobe Acrobat will open but it disappears. I am not too familiar with the Shell Command but how can I use it and where would I place the code to open all of my pdf files from the...

I don't understand. Where would I place ShellExec() so that all the hyperlinks in my table would open the corresponding .pdf file? Would I create a module? Thank you for you help