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

I was trying to do it using VB code. The PDF995 site says to place the code below in an access module. Then refer to the function like this: To create your pdf file, call the function pdfwrite "report name","report filter(may be "")","Path to put the pdf" This is the syntax I used to refer...

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

thanks, sorry wrong forum.

No there is no row number field because it is a UNION query that was pulling from external data that also does not have any kind of ID field. What are temp tables? Or could I add rownumbers to a UNION query? Then I could treat the UNION query as if it were a true table.

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

Thank you for replying. I tried the following query but it did not work. When I ran it, the 'Enter Parameter Value' for 'rownumber' pops up. I must not be using the correct syntax: SELECT * FROM getAllRecords WHERE SiteCityState="CORONA CA" AND rownumber between 5 AND 10 ORDER BY SiteAddress;

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

thank you

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

Hi, Here are all the different reference syntax I have tried to use: <!-- #include file="\myFiles\SimpleChart2_1_VB.inc" --> <!-- #include virtual="\myFiles\SimpleChart2_1_VB.inc" --> <!-- #include virtual="/myFiles/SimpleChart2_1_VB.inc" --> I cannot access the page via URL if I use 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...

This is the exact page I read in order to get the syntax down correctly. Maybe I did something wrong with setting up the virtual directory. I'll post my question in the IIS forum. Thanks.

I received the same exact error 'The include file '/myFiles/SimpleChart2_1_VB.inc' was not found.' This 'SimpleChart2_1_VB.inc' files is actually in a physical directory called 'includes' that I desisnated as the virtual directory with an alias of 'myFiles'. When I go to IIS Admin, I can see...

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

I tried this and unfortunately the prompt comes up again if I later try to refresh the linked tables.

I figured it out, I cannot use the constants in this method, so this worked: MySQL3 = "UPDATE test_sp SET test_sp.[Status] = 'Draft' WHERE HyperlinkPart(test_sp.[PDP deliverable], 0) = '" & fileName & "'" Thanks again PHV.