Access 2010
I am using a list box to export with formatting report to PDF but I would like to include the selected item from the list box into the final report path name. Is this possible?
Thank you for your review.
Access 2010
I am using a list box to export with formatting report to PDF but I would like to include the selected item from the list box into the final report path name. Is this possible?
Thank you for your review.
We have approximately 3000 attachments that we have to hyperlink into different word documents with the final product in pdf (maintaining the hyperlinks). The final documentation will be on flash drives to 7 different reviewers.
We can save the word to pdf and maintain the links in pdf, but...
We have over 1400 links in a pdf document that points to other documents in a folder. Every time we use different computers the links follow that path. Any ideas of how to make this process work?
I have developed 5 separate reports from 5 different queries and I made 1 macro to output the reports into pdf format on my local drive.
I was going to add prompts to the queries to let others pull the years they need but then they would have to run the macro and enter the Year into the prompt...
I am trying to figure out if I can insert a graphic or a data table into a text/memo field in an access database form. I didn't create this so I can not do any back end programming.
Any ideas?
I have a word document WITH hyperlinks pointing at a folder with lots of pdf files.
I can convert the word to pdf and keep the hyperlinks but on some machines it doesn't work but some machines it does work.
Can anyone tell me if I can set up the links to point to any drive on a cd when I burn it?
I have a few reports in access that I created a macro to run the reports and save them to a folder on my computer. The problem is that I am now going to share the output macro with others that might have a different directory then me but access to the same folder.
Example
MY DIRECTORY...
I am trying to produce a report based on 3 queries and combined into one Union query for the report but my text cuts off at 255 after I add the second query.
Here is the SQL statement - any ideas?
SELECT comment1, sortmemo, selection, QNAME,Emplid,GROUP
FROM [qryBest-COMMENTS]
UNION ALL...
I have 150 fields on a table organized by
Course. Section. ICS. 1.1.a ,1.1.b., 1.1.c, 1.1.d, 2.1.a ,2.1.b etc.
I need to label each of the 1.1.a with text example:
1.1.a. Are you teaching math
1.1.b. Are you learning math
1.1.c. Are you enrolled in this course
In the fields it would by Y/N...
I have a spreadsheet that needs to get updated daily. I enter the new data into a row and then copy and paste the same data into the top of the sheet so we can look at it at a glance and the details under it.
The data is organized like this
Day - HeadcountTtl - HeadcountCampus1-HeadcountCampus2...
I have built multiple queries and crosstabs and then merged them back into a make table query
The data looks like this:
Learning courses......................Equilvant course
Make Table
Course Section Location Ttl Pass Fail Course ttl PASS FAIL
ABC123 1234 Campus1 100 80 20 ABC123...
Should be a simple fix but my 1st GroupHeader is showing with a blank page except for the Header at the beginning of the report.
I tried changing the properties force new page before, after,or before and after and it stills shows up.
There are no blanks rows to make it show an extra page.
I would like to collect data to several different employees and I noticed in access 2007 external data there is now a tab to collect data but when i click on create e-mail it only wants to use Outlook for this function. We currently use Groupwise.
Is there a way to use groupwise and bypass...
Someone told me that I can produce a pdf file with tab dividers off to the right side of the document. I am thinking they meant the visual tabs like the one on the left (pages,bookmarks,etc.) Does anyone know how or if this exists?
Thank you in advance.
Sample Cell data ALL IN ONE CELL WITH Word wrap:
SUE THOMAS
234 EXCEL ST
WINTER SPRINGS, FL 32789
I need to separate it into
Name(Column) Street(Column) City (Column) STATE AND ZIP
any ideas - i can't find the symbol for alt enter to do a delimited file
I have a query that has a preferred email address field and a Home email address field.
I want to query and find only those that have different values in both fields.
Hope this makes sense.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.