Search results for query: *

I am fairly new to SharePoint and I am trying to create a registration system in SharePoint by combining two lists: 1. Class Calendar 2. Class Attendees This will be used to setup learning and development classes for the department. The administrator of the program will use List #1 to setup...

Ok, so the document gets posted to the sharepoint site, hence the working perfectly. The exception is, the library it gets posted to is Grouped by a field named "Report". When it gets uploaded, it is Grouped under a blank report type because the "Report" is not specified at the time of the...

Hello All, Below is some code I have in MS Access 2007 VBA that uploads documents to our SharePoint site. It works perfectly with one exception. What I would like it to do once it is loaded to the site is to be placed in a master document library that is grouped by the report name. The report...

I have full access and control of the data, code and database.

Thanks MajP, I'll give it a try. I appreciate the all the feedback. You hit it on the head. The data is stored in an Access database, then exported to Excel via VBA. From there I have VBA that reads Excel and copies and pastes the items in PPT. Once in PPT I would like to create and...

Thanks for the feedback. Unfortunately due to privacy I had to remove some of the data and paste it as an image. In the real presentation, the objects are not locked down. The report is sourced through MS Excel and there is VBA in Access that copies and pastes the information into a...

Good Morning,Was looking for some assistance with some VBA code to create a catalogue of items in a PowerPoint report. For example I have a list of customer numbers that I want to lookup in the report and list the page # they are on for quick reference. Please see attachment Thank you in...

Dan08 Try holding down the SHIFT key while opening the database. Also, depending on the security settings for your database, you might see one or more security messages on startup. You need to continue holding down the SHIFT key until you close the security messages, or the startup options...

Thanks dhookom, my biggest obstacle was to get the dates on the same row for the calculation. Worked great!! PH, thanks for the input also. I will be sure to provide more information going forward Thanks again to you both Rico

Unfortunately I have not started the code as I am not 100% sure where to begin. I have written the queries that group the IDs and the dates together, but because they are seperate entities, I am unsure how to apply the DateDiff function to the records. I apologize if there wasn't enough...

Good afternoon All, I am trying to calculate the incremental increase (in months) at each change of the CURRENT_TARGET_DT for a given ISSUE_ID with multiple occurances on different rows. Can anyone give me an idea? Basically, looking at the data below I would need to calculate the difference...

I apologize it was formatted better before i posted it.

Hello All, I am trying to do a year over year calculation based on month to month data which is represented in another cell for a dashboard. I have the YoY calculations working but because that % needs to be represented on a seperate worksheet in a dashboard I can only get the current month %...

Good Morning All, quick question! My system default printer is a Lexmark Black & White (Lexmark BW). I want to print out a report in color and have the following code that I use for another routine for Adobe which works fine. But using it for this routine, it still defaults to the BW printer...

I will do the step thru and see if I can figure out what's happening. Thanks for your time and attention

Thanks, I did not notice that. It's fixed. The error is showing up on a form data field that i am trying to populate with the autogenerated number Thanks again

Hello All, I have the below code and I basically want module 1 to run to generate a unique report number based on the item type, current year, and then a sequential number starting with 1 so it would look like this - IN12-0001 etc. That report # should also automatically populate in the...

Thanks for all the responses. I read the FAQ section and found what I needed and it worked like a charm. Thank you all very much!!

Hello, I am trying to create a form that has a combo box with certain values for a given category and once a value is selected, a 2nd combo box gets populated with the sub-categories from the 1st combo box. Is this possible? Thanks in advance

Lilliabeth, Absolutely awesome!! I had something similar but had the dateadd and datediff functions reversed and couldn't figure it out for the life of me. Thank you so much, this saves me hours of work!