Search results

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

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 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 have a hyperlink field that allows my users to click the link and see the actual order (hardcopy) they submitted. When I set the hyperlink to open a .jpeg it works but I am using too much memory. Also, the users use various software to open .jpegs so I need to streamline the process to Adobe...

I have a subform and form that I want to link by purchase order numbers. My form has the main purchase order numbers such as WidgetsA, WidgetsB, WidgetsC, and so on. My subform also has purchase numbers but are enumerated based on the purchasing sequence of the Widget. So everytime I order a...

I have a textbox field on a report that I need to evaluate. I would like to evaluate the field to show N/A whenever the report is run and the field is null. I cannot set the default value to N/A because it stores numbers. Is there a way to do this at the time the report is run? I tried this...

I created a form to print reports based on the values selected from a series of check boxes in my option group. I do not want the user to get an empty report so I only want the print command button enabled if the check box shows that is has been selected. Is this possible? I thought the code...

I am working a reports but have never used an option group on a form so that I can change the criteria to print the same report for different parameters. I have my orders items (5 items) in one group and my years (2006-2009) in a second option group. How can I set up code with a print command...

My database is linked to jpegs. Every time I click on the hyperlink to view the jpeg, I receive a hyperlink (make sure it's trusted) warning. Is there a way to turn off the warning? Thank you :confused:

I have a report that shows job numbers for most of my orders. Whenever an order doesn't require a job number I key in three zeros for the job number. On my report I do not want to show the zero value. I would like to set the forecolor to white so it appears blank to the reader. Can that be...

I have a purchase order where I tracked how much is ordered for a particular item. I track the order by year. Sometimes however, an order is paid over multiple years. So I have a 240K order that is being paid in 2008 2009 2010. Is there anyway to key the order in my received in 2008 table...

I know how set a field on the subform equal to a field on the mainform by forms!subformName.subformField = mainformName.mainformField, but is there a way to disable a control(a comman button)on the subform if a field on the main form is null. I've tried using the same code above and have had...

I would like to limit the number records entered per main form on my subform. Is this possible? For instance, for every order placed, I only want the customer to add three items and their descriptions the subform. ;)

I have a report with a currency field storing dollar values. I would like to say that if the value in that field is less than $100 then hide or show another field. Can this be done? ex. If me.salesvalue <100 then me.salessticker.visible = false Thank you in advance:rolleyes:

I have a subform in my main contracts form for each record that I enter against my main contract. I would like to print each record in the subform without having to enter in the subform number. I created a print button that shows for every record entered in the subform. I've set the query...