Search results

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 place an unbound textbox on my form and used the code for the control source but now I am getting an error in the new unbound textbox. Is there something else that I am doing wrong?

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

Thank you for your help. I am trying to balance my budget for the upcoming year. Certain purchase orders are paid over a few years instead of all at once. When I key an order for the current year, I need to show that although it originated in 2008, the payments will stretch for 2009 2010...

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:

Should I remove the reference of subform in the query the report is built on? Right now in the criteria of my id field its [forms]![frmsubform]![id]. Should I remove this so that I am not prompted for this information. The code you sent will reference it at the form/report level without...

docmd.openreport "report name", acpreview

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

I have a report with an if then statement for a checkbox. If checkbox is true...etc versus if checkbox is false...etc When there isn't a record that has this checkbox checked, I get the error "You entered an expression that has no value." (Runtime error 2427) How can I ignore this error...

I am adding fields with numeric values in design view of my query. The only issue I am having is that the query is not showing totals when one of the fields does not have a numeric value in it. How can I show the total numeric value regardless of the null value? Thank you:cool:

If I create a record for each date can I produce a report with the days of the week(my report has to show weekly delivery stats) along the top as column headings and my storerooms as row headings?

Can I setup a table to have 365 columns for dates &days of the week for the entire year? I would like to relate this table to another to show how material was delivered over the course of the year, including those days and weeks when material was not delivered to all my storerooms:confused: