Search results for query: *

Whenever I try to do certain things, such as add a new entry to a list, Internet Explorer hangs up on me. It doesn't matter what list it is, every time I click 'New Item', I get a dialog box saying that "Internet Explorer has encountered a problem and needs to close." How do I get this...

I am currently documenting my Access application and would like to list the tables and their definitions for my systems manual. Is there a way to export the table definitions alone (and not the data) into a document that I can use? What? Who? ME????

How can I access a CommandButton's properties etc via code? I want to disable or hide the command button based on a condition (tested by an IF-THEN-ELSE statement) but I don't know how to access the CommandButton1.enabled or .visible properties using code What? Who? ME????

Is there any VBA function to test if a cell is blank? What? Who? ME????

I'm trying to get some external queries to work in the background without asking the user if they want to enable or disable automatic refresh. I want the user to save the purchase order as a new file, but I don't want the new file to open and keep asking if the refresh should be enable or...

I'm still trying to get the external queries to work in the background without asking the user if they want to enable or disable automatic refresh. I want the user to save the purchase order as a new file, but I don't want the new file to open and keep asking if the refresh should be enable...

I removed the Quick Launch Bar from my website, and now I want to replace it. How do I change the layout in my website so that I can manually put back in the link bars that made the Quick Launch bar work? What? Who? ME????

I would like to store the date a purchase order is generated in a spreadsheet. I was trying to use this code in the spreadsheet to store the date in cell E3 Worksheets("LPO").E3.Value = Date but I was getting this error message: Object doesn't support this property or method. What gives? If...

I want to place some web parts on my website, but when I do the web parts are always too big. I would like to specifically size these web parts, but I have been unable to figure out something that works. I tried setting the Height and Width explicitly in the webpart's properties, but this...

I want to place some web parts on my website, but when I do the web parts are always too big. I would like to specifically size these web parts, but I have been unable to figure out something that works. I tried setting the Height and Width explicitly in the webpart's properties, but this...

Is there a way to force an Excel spreadsheet to save as read only but need a password to make it read-write so that only management can change the data in the spreadsheet? All staff should be able to view the spreadsheet but only the director has permission to change anything. What? Who? ME????

I want to run queries that I have saved in the Queries tab of my *.mdb file by affixing the queries to the .RecordSource of a View all form so that the same form can be used to view different sets of data. The user is to be presented with a form with option buttons where they can choose an...

I've added some code to a button in Excel to save the spreadsheet as a *.mht file. The file is a purchase order, with three sections: the second and third sections are duplications of the first (Duplicate and Triplicate sections). All of the cells in the last two sections have IF statements in...

My main form in my application generates sequential IDs for requisitions using an Autonumber. The problem that has been reported to me by my users is that requisitions that have been assigned an ID number sometimes get deleted or aborted by the user or the system during routine contraction of...

How do I use VBA code to save an Excel file as a single file webpage(*.MHT file) so that my users have a copy of the data without being able to chage it? I would put that into a command button on the side of the spreadsheet. Any ideas? (Or is there another way of protecting the data after the...

Whenever the external queries in my Excel document refresh, the date (which I have displayed using Now() changes from whatever it was to the current date. How do I get this to stop happening? Is there a way that I can automatically generate the date when the file opens but then stop it from...

Currently if I make a change to a form in my Access application I ask the user to replace the entire *.mdb file. Is there a way that I could create an update procedure that makes the small changes within one form in the *.mdb file without me having to ask the user to download the entire *.mdb...

I've been getting this error intermittently when I'm trying to move between records "Can't set value to Null When Checkbox property = False" What does this mean and how do I get over it? What? Who? ME????

I'm trying to create an SQL statement that shows all of the records in the Requisition table (and the associated Items table) for Requisitions that are not authorized I've already gotten the query to display the info that I need - this code shows all the records that are related to...

How would I create a query in access that adds all the Total Costs of a set of products (Total Cost being a calculated field in the query of Qty * Unit Cost) so that the Total Cost is displayed in a msgbox()? I'm trying to allow the staff to see the total cost of the requisitions. If I create...