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

Can anyone help me with this???

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!

The only problem is that I somtimes need 4 of these vendors to show up as one record on a report. I thought that I might need to add address2, vendor2, city2... fields to my table so that I can get the report to show the four vendors. Is there any other way for 4 vendors to be assigned to one...

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

Can anyone help me with this?

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

What is the best way to fix this problem when you get this error message? I did not think that my database was so complex. Do linked databases also count towards this limit??

Does anyone know what might be causing this?????

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 got it to work. Thanks.

That code does not seem to work. I entered this in my query: Bushels: Format(([Pounds]/60),0.00) but access automatically changes it to Bushels: Format(([Pounds]/60),0) so the number shows up as 8677 instead of 8677.67 Is there anything else I can do?

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 tried copying and pasting, but I get the following error message: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. I have a backup of these records so I would just like to delete the records that have...

I tried to repair it, but that did not seem to help.

What do you mean by a hyperlink?

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.

Pat: Thanks for the help. I am still having trouble with one more part. I am trying to calculate the total of a field on a subform I added the following code in a text box on my Main form footer. =Sum([ScheduleSubForm].Form![Total Bushels]) I get a #Error message. Do you have any idea what...

Doug, I tried that code, but when the combo box is blank the query does not show any records. What criteria do I need so that when the combo box is blank, all records come up?