Search results for query: *

Hi, Is it possible to display only certain events from a sharepoint calendar in outlook? If so, can it be done from outlook by 'inviting'? thank you Sal

HI everyone, Two things I am wondering about. Has anyone successfully passed a variable to the NewForm.aspx page? Has anyone ever been able to take that variable and insert it into a field on NewForm.aspx so that when a users clicks 'save and close', this variable would be entered into the...

hi everyone, I have a view of an issues list that I set up and it is showing duplicate versions of each issue. So if I look at the issues in a datasheet, I see the Issue ID duplicated for each issue, EXCEPT for the first person listed in my filter. The issues tied to the first person in my...

Hello, I have been reading the many posts on this subject, and have tried a couple with no luck. I have tried pdf995, it does not output a PDF file when I run the code. I downloaded A2000ReportToPDF but it has no instructions on how to use it. All I need to do is create a pdf from a report and...

Hello again, I have two queries that pull from the same pool of data. the main source of data is a UNION query that I have created which pulls from various Excel files. I need to send data, in the form of an access report to multiple people, but the data pulled from the UNION query CANNOT be...

Hi everyone, I have a UNION query that I would like to select certain rows based on the rownumber, or ID if it were an actual table. For example, lets say I have 20 records in my UNION query and I write another query that only selects records 5-10. How would i do that? I already know how to use...

Hi everyone, I have an asp application that displays a graph based on data from an Access database. The problem I noticed today is that when users try to view the graph while my macro is runnning, they receive a 'Page cannot be displayed error' (http 500 internal server error). I can view the...

Hello, I recently created a virtual directory underneath a virtual server on a Windows 2003 server. Whenever I try to access files within the virtual directory via ASP code, I get an 'include file not found' error. I posted my question in the asp forum to verify my syntax, it looks ok. I'm...

Hi, I created a virtual directory in IIS on a Windows 2003 server called 'myFiles'. I cannot get the <!--#include virtual--> tag to work.. If I do this: <!-- #include file="/myFiles/SimpleChart2_1_VB.inc" --> The include file '/myFiles/SimpleChart2_1_VB.inc' was not found. The .inc file...

Hi, Not sure if this is the correct forum but I have an MS Access 2003 database located on a Windows server. Part of the application I built requires some of the tables in this database to be 'linked' tables to .csv files. The problem is, the .csv files are located on a different server and are...

Hi, I have a linked table that contains a 'Hyperlink' column. Unfortunately for me, I cannot change the format of this column to another and I have to use it as my unique identifier. So far I cannot figure out how to compare it properly to a text value since as a hyperlink, it is not. For...

Hi, I have MS Access 2003 installed on a WINDOWS 2003 server. I have a scheduled task that needs to run on the access table every hour, all the task does is refreshed the linked tables from an external data source (sharepoint to be specific). The problem is, that a login prompt appears asking...

Is it possible to run MS Access 2003 on Windows Server 2003?

Hi, I tried to use a UNION query to get rid of duplicates between two tables. The problem is, each table has duplicates of their own and they are still showing up. I am using the SiteAddress field as the one to determine if there are duplicate records. The site address field contains home...

Hi everyone, The following query works just fine until I add the ORDER BY statement at the end. Then I recieve a 'You tried to execute a query that does not include the specified expression 'DaysLate' as part of an aggregate function.' What am I doing wrong? SELECT...

I have some code that I am trying to execute but I'm just not getting the correct results. I have modified the data so that it should find a match and it is not. When it gets to this piece of code: "If barcDocReport.RecordCount > 0 Then" it shows up as "0" in my MsgBox code. Is there something I...

Hi everyone, I have an imported table that contains a column that is a hyperlink. For example, one entry is 'PDP Dashboard', if you click on it, it will take you to a webpage. How do I extract the URL's from these entries? I can't just extract the value of the column since it would give me 'PDP...

hi everyone, I have a page that I need to link to that contains a menu that allows you to expand and collapse via javascript. I was wondering if I can attach something to my URL that would open that page with the appropriate option expanded? Here is the code snippet of javascript that operates...

HI everyone, I am wondering if it is possible to do the following in an Access query. I want to stay away from writing VB code if I can. I think the best way to describe is to show a sample. Here is a sampling from my table. The left column are my existing values (CBC) and the right column...

Is this at all possible? I am tasked with providing a directory structure for a specific doc library. I began digging around the library and there are a lot of sub-folders and docs. thanks,