Thanks all! I will look into the references that you have given. I am luck enough to have Adobe Pro, so I will play with that. The key is figuring out how to export the data so that the customer just has to press the button and it will show up in the printer! But I have a place to go now. Thanks again
M
isben22
Last Activity: Jan 11 '08, 07:37 AM
Joined: May 6 '07
Location:
-
Extra Advanced Reports - Art of the Booklet
I have been searching through references trying to find methods for developing reports. Many of the "advanced" reports talk about GROUPING and ORDERING.
What about special printing requirements? I have such a need. I am trying to print a report in a booklet style. This booklet is produced as many as three to five times a week, and is 3x5 inches when folded.
I have been unable to recreate this as report and... -
From what I understand, this is hard to do. Even on a few sharepoint sites there were not many cross-functional experts. If I find out anything I will post.
thanks!
M...Leave a comment:
-
Integrating SPS Portal Events List to an MS Access Relational DB
I am running SP Portal 2 and MS Access 2003.
Our SPP has a LIST of events that many departments contribute to. I want to use MS Access to develop custom itineraries based off this calendar of events.
Problem: I have linked to the SPS List without trouble, however when it comes to building relationships on an SPS List I am having no luck.
I have tried:
1. Linking to SPS LIST
2. Building... -
Well it worked, only not the way I had intended. I have learned a little more about the SQL I have been trying to avoid ;)
I am back at the drawing board. I am trying to use a Share Point List as a master table (Linked) and use Access Tables as subTables. For some reason you cannot make a one to many join to a SharePoints2 List which is why I was importing data to an access table. I will have to do more research in SPS2.
...Leave a comment:
-
All that and the "sample table did not come out as I typed it... should I be clearer?...Leave a comment:
-
PDog,
I understand your question and maybe I am not attacking this logically.
The large scale event is to create a personnel schedual with a running date.
1 APR 2 APR 3APR
John X / Q
Marry X Q /
Jean Q / ...Leave a comment:
-
Thanks a Million! I will try it first thing tomorrow! The 'Z:\Operations File\DB\DailyCa rds_be.mdb" is the location of the back end. I have a split database. However, if this works on a "uni-base" then I may be able to work the back end...
thank you so much:...Leave a comment:
-
Getting there! Ok got it to work without error. I had to add a comumn to the form (not an issue as there will naturally be other columns) But it has an interesting result.
it lists each date twice like:
ID Date
1 2/2/2007
2 3/2/2007
3 3/2/2007
4 4/2/2007 and so on...
what could be causing this doubling? I really only want one day per record. I will then...Leave a comment:
-
Sorry. New to the posting world. I should have specified that I am working with MS Access 2003.
This has led me to the idea of using a form to add a date to the default value but returned an error.
I used this line (from the help file) to try and return a default value:
=DMax([ID],[Date],+1)
But came up with the #Error.
Where should I go?...Leave a comment:
-
Default value of a record equal to previous record in date format
I had a resource for this in the past but lost it somewhere...
I have a need to enter daily information. Every day has to be accounted for, 24/7.
I would like to make the default value of the date record, sequential; i.e. each new record is +1 day of the record before it.
I know I cannot refference a record in the same table, but I cannot seem to find the reference on how to build the query.
... -
Absolutely!
INSERT INTO Mission ( ID, Edit, MissionName, MissionDateFrom , MissionDateTo, Notes, MissionPlanner, ItineraryID ) IN 'Z:\Operations File\DB\DailyCa rds_be.mdb' SELECT Missions.ID, Missions.Edit, Missions.Missio nName, Mission.Mission DateFrom, Missions.Missio nDateTo, Missions.Notes, Missions.Missio nPlanner,Missio ns.ItineraryID FROM Missions;
This SQL is computer generated.
I have a link from...Leave a comment:
-
Access from SharePoint; Type Conversion Failure with Dates
I am a beginning developer using ACCESS 03 and Share Point Portal 2003.
I have a list of events with start and stop dates in SharePoint that I want to pass to and Access Data Base.
Ultimatly I want to create an itinerary program that has an event and many subEvents as in a relational database. But I have not been able to find information to show me how to turn a SPS List into a relational table.
I have...
No activity results to display
Leave a comment: