Search results for query: *

Outlook/Exchange 2000 environment. User1 has givin permissions to user2 to view her calendar. The permissions are right, I verified this with another user she has granted rights to. The problem is when user2 views the calendar she can see the days in Bold on the right indicating entries on...

Hello All - I have several word doc's with linked worksheet object in them. When you do a print preview all is well, nice and colourful. However whenever you print it, it comes out black instead of colour? It doesn't do it all the time but most of the time. I am running Office 2000 SP3 The...

I would like to reference the properties of one shape frmo a different shapes shapesheet so I can display it on the drawing. I'll explain a little more. I have some network shapes on a WAN diagram that are linked to an access db. I have set the text of the shape to display the the sitename...

Hello All, Sorry for the long post I am prety new to Visio and want to explain this properly. I have been tasked to create a WAN diagram. We have more than 130 sites all over the country that I need to represent. I have a list of the sites and all of the pertinent data in a table in Access. I...

Here is my problem: I need to code an MS Access db I administer to send e-mail via Lotus Notes. I have read the help files, and dozens of code samples with regards to this and fully understand what they are saying to do. Now for the twist: all of these code samples and help files assume that...

Here is my problem: I need to code an MS Access db I administer to send e-mail via Lotus Notes. I have read the help files, and dozens of code samples with regards to this and fully understand what they are saying to do. Now for the twist: all of these code samples and help files assume that...

Hello All, I hope someone can help me with this. I have a fram with three servers(Metaframe XP, FR2 on Windows 2000 server SP3, IE6 SP1) that are load balanced desktops. My users all have roaming profiles stored on a file server that get loaded and unloaded each time they log on and off. On...

Heres my problem: I have to make several published applications bilingual(Access db's). Some of these app's make use ocx controls and specific functions to return dates for example. What I need to be able to do is have the english version of access installed with all of its libraries as well as...

i have a calendar control on a form that people make reservations with. It works great but now I have to translate it to french to appease the language cops. I don't want to change any of the underlying data structure al i want to do is change the text that is displayed for the month? Ie...

I would like to store 2 values in the same array index. I have to sum and to some calcutions on data that was entered by the hour. I need to sum these values for the day and use this value later in a calculation. THe problem I am running into is there are different formulas based on the day of...

Hello all, I am sure that the answer to my question has been posted before but for some reason I can't find it. I am currently in the process of bringing another group into a central Access97 db that I work on. In order to port there old data over I basicaly made an empty copy of the current...

This may be a silly queston but is their to comment out large sections of code without having to put a ' on every line? There must be something similar to C's /* */ style? Thanks in advance

I have report that contains a chart on it. What I need to do is make this chart completely customizable, thats part not so bad I have pretty much gotten most of that done. What I need some help is how do I change the RowSource of the chart through VBA??? I have it setup now that it will...

Does anyone know if Windows assigns OLE Objects a windows handle? And if so how can I get it that handle? Any help would be really appreciated. Chris

Ok heres my problem. I have setup a front end that access some spreadsheets so users can view some data in an easy to read format. I am doing by using an Excel object on a form and displaying named ranges specified in the code. The problem I am having is when the Me.Object.Action =...

I have setup a small db(no tables just a front end) that based on what the user chosses from a combo boxes and which buttons are pushed will open a second form that has on OLE frame on it and displayed in this frame is a specified portion of an Excel Spreadsheet. This part all works fine but the...

I have db setup that has a lot of customers in it. I have been asked to setup a query based on some specific criteria, that part is easy. The problem I am having is with the date. My users want a query that will return the most recent contact with one of these customers. Each Customer has a...

Hello, I need to create a crosstab query that gets its from a spreadsheet. The data itself will depend on the which spreadsheet is used and further more which named range is used so I cannot import into premaid tables. This will eventaully used to create graphs. I have tried many different...

I have setup a front end to view various portions of some spreadsheets. I bring them using an unbound OLE container and this works fine. Now I have to somehow give the users a way to Graph what they see. I have found some examples on how to do this but most of the are either not commented or the...

I have an Unbound OLE control on a form that I use to display a named region on an Excel spreadsheet. The problem I'm having is that it won't remove the link to the specified region. I have quite a few spreadsheets that I will need to access with about 300 different named regions. I don't want...