Search results

I was wondering how you protect a report so that it can only be changed by entering a password. Thanks, Brad

I deselected the full menu option in the startup box so that a limited menu is available to users. The only problem is that I lost the Tools Option->Office Links->Analyze with Excel. How can I get this option back??? Thanks, Brad

I am trying to insert a 8 page Word document into a report in my database. There is only room for 6 pages. Is this the maximum setting? Is there anyway to change this? If not, is there a way for both reports to show up under the same print preview? Also, can they both print together? Thanks!

I have a form where I select a vendor name out of a combo box. The rest of the vendor information then defaults into combo boxes below. I want these to actually be list boxes so that the user does not have to select the rest of the vendor information. The only problem is that when I turn...

I currently have a database that maintains vendor information. The vendor is the primary key. I have a combo box when you select a vendor name and then a form comes up with all of the vendor information. I would now like to print contracts off of the database. These contracts could have up...

I have a two page report with numerous data fields throughout. The report prints out fine on some computers, but on other computers, all of the data fields on the second page are blank! Does anyone know why this would occur? Thanks!

I have a calculatated field in my query and I am not able to format the result of the calculation. When I go to properties, there is not anything in the format drop down box. Is there any way to format the result of the query? Thanks, Brad

I have one table where I have an error message that says: "Not a valid bookmark" It then places a #error message in each field of the table. This message occurs throughout the middle records of my table only. I was just wondering what the problem may be and if there is any way to fix it.

I have a query with criteria captured from two fields in a form. For example: [Forms]![ScaleLogSpreadsheet]![ComboName] [Forms]![ScaleLogSpreadsheet]![ComboBatch] How do I get the criteria to work so that it shows all records if both fields are blank and also works if one of the fields is...

I have a couple questions. How do I calculate the total of a field on a form? I also want the total to show up on a page footer on a report. Should I calculate this in a quey? Also, I have a button on a subform that opens another form. This form is based on a query that has a filter based...

I have a table with vendor number and customer name. I then have another table that lists the vendor number and all of the customer's contract numbers. I also have a year column added to the table so that I can query out only the contracts for a certain year. The problem is that I need to...

I have a calculated field in a report. The value shows up in the report as #Error until I enter the values in the other cells for the calculation. Is there any was to prevent this #Error message to show up? Thanks

I have a query where I want to average columns 1, 2, 3, and 4. I want the average to show up in column 5. There may not always be values in all of the columns so I cannot just divide by 4. How do I set up this formula? Thanks for the help!

I have an unbound combo box with last name and first name. When I click on a name I want it to open a form with the employees information. I want the form to open up by the employee ID number. Otherwise if there are two employees with the same last name the correct one will not come up. I do...

I created a pivot table by using the form wizard. I cannot figure out how to get the form to refresh every time I open it. When I click the edit pivot table button, I then go into excel but I still cannot get it to refresh on open. I have checked the refresh on open check box in Excel, but it...

I am having trouble formating a field in a form. The field is from a query. The field has a percent format with no decimal places. The table has the same format. When I type in 14 the field in the form changes to 1400%. What do I need to change so that it reads 14%. Thanks in advance for...

I have a query that has a yes/no check box. I want the yes/no boxes to reset to "no" each time I open the query. I am opening the query with a click button on a form. Once the query opens I then want to select which records I need. Is there a code that will either clear the boxes or reset...

I am trying to add a formula to my query that adds three fields together. In my query I entered a new column and put SUM:[Field1]+[Field2]+[Field3] I have already entered in a lot of the data and some of the fields are blank. The formula will not work unless there are zero's in these fields...

I have several Word documents that I would like to use as a report. So far I have opened a report in design view and then I copy and pasted the Word document into the report. I cannot figure how to insert the information that I want pulled from the database into the report. When I insert a...

I have a form that has customer information and their customer number. I then have a subform that has a drop down field that lists all of the product numbers that they have previously ordered. I want to select the product number from the drop down field and then have this number automatically...