How To Add A Site Or Publisher To Trusted List
Oct 22, 2011In 2007 how do you add a site or publisher to your trusted list.
View Replies
ADVERTISEMENT
Modules & VBA :: Database Is In A Trusted Location
Feb 7, 2014how to stop this error from occuring. "Potential Security Concern" I get this everytime a query runs that is creating a file for exporting. The database is in a trusted location, the query is a make table query if that makes a difference.
View 1 Replies View RelatedAdd A Trusted Location With Access 2007 Runtime
Oct 2, 2007How in the world do I add a trusted location with only the Runtime version of Access 2007 installed on the PC?
I am in the process of distributing some new runtime-only applications; how do I stop the irritating "potential security risk" warning from coming up everytime the user logs in??? I can't figure out how to get to the "trust center" with only Access Runtime installed. Users don't have any other 2007 applications like Word or Excel either, and are running Windows XP, NOT Vista.
Access 2007 Trusted Locations All Users TS
Jan 15, 2008At work we have a terminal services setup for most of the staff which is being configured now. We have hit a snag with access security settings basically we need macros to run for relinking odbc databases and various vba functions (some run overnight so we don't want to deal with the security dialogs). We though the best way to do this would be setup trusted locations. We did this logged in to terminal server as admin hoping this would be a machine level setting but it seems to be on a per user basis.
Is there a way to set a trusted location for all users of a machine I have google and come up with nothing. The other option is enable all macros which I don't want to do.
General :: Configuring Trusted Locations Which Remain Valid On Different Machine
Aug 13, 2015I have developed a database in Microsoft Access 2013. I wish to install and run that database on another machine on which I have already installed the MS Access Runtime.
In order to allow the database to run correctly on the target machine, I need to add two Trusted Locations - one for the front-end database and another for the back-end database.
The folder paths on the runtime machine are different to those on the development machine, so how do I add Trusted Locations (on my development machine) which remain valid when the database is copied to the target machine?
Must I trick it by simply creating an identical, dummy folder structure on the development machine (would this even work?), or is there a more elegant way?
Publisher Could Not Be Verified
Jan 3, 2008Is there any way to get rid of this message?
I am running an Access 2003 mde file across an intranet and want to remove this error so the users do not have to contend with it.
The users are going to gain access to the file via link on the "home" page.
I know this is an issue with IE but I only have limited authority so any "backdoor" way of getting rid of this would be greatly appriciated.
Thanks
tgi171:confused:
Linking Photos To Publisher
Jan 29, 2006Hi,
I've got some id card templates in publisher than i want to merge in access.
i can merge the text details into access but i dont know how to link the photos. should i store the file path of the image in the database or should i embed the file.
would this work with publisher or do i need to use some code?
any help on this would be appriciated as i have no experience with pictures in access.
Thanks
Hyperlink To Publisher Doco
Jan 17, 2007In an access table I have hyperlinks to various documents mainly word docs. I have recently added a Publisher doc and when I H/L to it it will open the application but not the doco.
Obviously Publisher behaves differently than Word in this regard.
I do need the link to open the doc. Is there a way around this please?
Thanks
Peter
Publisher Displaying Name.. Now Just Displays Numbers?
Apr 4, 2005I have a list of publishers for software titles in a table.
1=Adobe
2=Macromedia
and so on and so forth.
I have a form that pulls the publisher name and displays it, and it used to display correctly with the NAME but now all of a sudden it's displaying the publisher number "1" instead of "Adobe"
what's going on?
Modules & VBA :: How To Edit A Publisher Text Box
Jun 25, 2014I'm currently using the following to edit a publisher document using access VBA.
Code:
For Each pubShape In pubDoc.Pages(1).Shapes
If pubShape.HasTextFrame Then
If pubShape.Name = "Text Box 440" Then pubShape.TextFrame.TextRange.Text = Item1
If pubShape.Name = "Text Box 441" Then pubShape.TextFrame.TextRange.Text = Item2
If pubShape.Name = "Text Box 442" Then pubShape.TextFrame.TextRange.Text = Item3
If pubShape.Name = "Text Box 443" Then pubShape.TextFrame.TextRange.Text = Item4
If pubShape.Name = "Text Box 444" Then pubShape.TextFrame.TextRange.Text = Item5
If pubShape.Name = "Text Box 445" Then pubShape.TextFrame.TextRange.Text = Item6
If pubShape.Name = "Text Box 446" Then pubShape.TextFrame.TextRange.Text = Item7
If pubShape.Name = "Text Box 447" Then pubShape.TextFrame.TextRange.Text = Item8
End If
Next
Obviously there are a lot of shapes/boxes etc in the document and this code is very inefficient and takes a few moments to complete. Is there a way to directly reference a text box and change its value. For word I have been using bookmarks but this doesn't seem to work with publisher.
I'm looking for something like pubshape.Value("text Box 440") = Item1 but cannot find the correct syntax.
General :: MS Publisher And MS Access Mail Merge?
Feb 22, 2013I am running windows 7 and access 2007 same with pub When I do a mail-merge from pub I can see some Queries but not all. and thoughts?
View 1 Replies View RelatedModules & VBA :: Open Specific Publisher Document If Criteria Is Met
Jul 16, 2014The code below allows me to open a publisher document that is already merged to the current record. What I need is to allow the user to open the document according to the group they are reviewing. How to accomplish this?
For example:
IF Group = A1 OR B1 THEN OPEN AB_1.pub
IF Group = A2 OR B2 THEN OPEN AB_2.pub
IF Group = A3 OR B3 THEN OPEN AB_3.pub
Dim pubApp As Publisher.Application
Dim pubDoc As Publisher.Document
Set pubApp = New Publisher.Application
Set pubDoc = pubApp.Documents.Add.Application.Open("c:Publishe rAB_1.pub)
pubDoc.ActiveWindow.Visible = True
General :: Pinned Database Won't Open - Unknown Publisher
Jun 16, 2015I work in three different databases, but for one of them (the main company db), if I right clicked the pinned Access program on the taskbar and click the pinned database, it does nothing if someone else has the file open already. If the file isn't open, it'll pop up with an "Unknown publisher" warning (new, never happened before this), but it'll open the file. If someone has the database open, it doesn't flicker or even try, it just does nothing.
I am able to open Access and click on the database in the "Recent files" and have it open that way. I don't know what to troubleshoot, its like it's not seeing the file, but I can go to the properties on the pinned db and it shows the correct file location. I'm the only one having this issue, the other users here can right click the pinned program and open the file like normal.
I've rebooted my computer; unpinned and removed from list; compacted and repaired; nothing is making a difference.
New To Site Need Some Help
Jul 25, 2005I Work For a school district and have been assigned the project of creating a Campus Improvement Plan Strictly using an access back end. I'm having some trouble sorting my data I designed the Report exactly how it has to look but I cannot get more than one entry per form on the report. So i was wondering if anyone knew a quick fix for appending to the report. Thank you
View 2 Replies View RelatedUntrusted Site
Nov 25, 2007I am working on a laptop computer running MS Access version 2002. I'm trying to access a data file located on my desktop computer via my wireless network. (Same version of Access).
I can see the file without any problems, but when I try to open it I just get the following error message:
this file is located outside your Intranet or on an untrusted site. Microsoft Access cannot open this file.
Both computers are running under Windows XP. O/S: MS Windows 5.1 service pack 2
How do I resolve this?
Web Site And Access
Aug 20, 2004I want to build a web site that people can access over the internet. I want the user to have the ability to run one of my Microsoft Access databases just as they would if the database was loaded on there PC. Is Microsoft Frontpage the answer or do you have any other recommendations of a web building software package?
THANK YOU IN ADVANCE - jOHN
1 To Many Relation, 1-site Is Not Yet Created
Apr 11, 2006The problem:
I have a table: TBL_INVOICES
and I have table TBL_SHIPMENT_NOTES
One invoice can have many shipment notes, so a created a
One to many relation between TBL_INVOICES and TBL_SHIPMENT_NOTES
However, the shipment notes are created earlier, thus there is no
invoice_ID when I create a shipment note.
How to deal with this problem ? Please, help ...
To Untwist A Site Traffic!
Nov 22, 2006Наверняка ниже должна быть масса профессиональных терминов: про регистрацию в каталогах, поисковую оптимизацию, релевантность запросов, целевую аудиторию, продвижение бизнеса в сети, результаты поиска, исследования поисковых систем...
По идее текст должен содержать: Узнаваемость сайта, стратегии интернет маркетинга, контекстная интернет реклама и пр.
Документов должно быть много. Статьи по темам, помощь в раскрутке, советы профессионалов и прочее, что может быть полезно начинающему веб-мастеру самому освоить "науку раскрутки" (а фигли, мы ж не жадные ;) ). Обязательно по всему тексту должны быть расставлены ссылки на самых "вкусных" словах:
Регистрация сайта в поисковиках и каталогах
Уверен, будет текст, призванный окончательно убедить клиента сразу оплатить услугу и получить гору клиентов. Примерно такой: Мы обладаем огромным опытом в оптимизации сайтов, ведьу нас работают только признанные специалисты интернет маркетинга и рекламы. Используйте опыт специалистов в области оптимизации сайтов, знающих свое дело.
Ну вот примерно так. Представили? А теперь к делу!
оптимизация сайта (http://www.mulka.ru)
раскрутка сайта (http://www.mulka.ru)
раскрутка сайта (http://www.mulka.ru)
оптимизация сайта (http://www.mulka.ru)
оптимизация (http://www.mulka.ru)
интернет реклама (http://www.mulka.ru)
создание сайтов (http://www.mulka.ru)
создание сайтов (http://www.mulka.ru)
раскрутка сайта (http://www.mulka.ru)
раскрутка (http://www.mulka.ru)
поисковое продвижение (http://www.mulka.ru)
Site Map Table Design Help
Sep 22, 2006If you're building a database to represent a web site architecture, what's a good way to design the tables?
Would you make a table for parent sections, and then another table for the first child of those sections, and then another table for children of that child and so on? Sounds clumsy to me. What happens if a parent section can be drilled down into 15 pages deep? You'd need 16 tables.
What I'm doing is building a test plan manager for a site that has varying levels of depth in each parent category and I'm trying to decide how to develop the input/browse form.
How Can I Publish A Database On My Web Site?
Nov 1, 2006Hi!
I need help!!!
I have made a books-database in MS access. I want to publish it on my web site. It should be possible for the visitor that search different books on my database.
I am able to write HTML code (using MS FrontPage) but how make a search form and how would the HTML contact my database (book.mdb) on my web-server?
I have find some HTML code.. for search-form but here it is used kbook.asp what I don’t understand it . I have tried to replace kbook.asp with book.mdb, but it does not working.
I have heard that there are some software that you can easily publish your database on your homesite but which software???
Kind regards, sofi
Code:<HTML dir=rtl><HEAD><TITLE>K</TITLE><META content="text/html; charset=windows-1256" http-equiv=Content-Type><LINK href="kformat.css" rel=STYLESHEET type=text/css><META content="Microsoft FrontPage 5.0" name=GENERATOR></HEAD><base target=kDown ><BODY bgColor=#EDF2EC text=#000000><FORM action=kbook.asp method=post name=SEARCH><TABLE align=center bgColor=BDCEB9 width=420><TBODY><TR><TD width=120>Choose</TD><TD width=220><SELECT name=Kids><OPTION selected value=DIV>Kids<OPTION value=CHD>History</OPTION><OPTION value=CIN>Animales</OPTION></SELECT> </TD><TD align=right width=80><INPUT type=submit value=Show></TD></TR></TBODY></TABLE></FORM></BODY></HTML>
Connecting Remote Site (setup Help)
Mar 5, 2008I just found out that this years project wil be setting up a remote office location. There will be about 5 users at this location. They want complete control over all equipment. What they have in place here is Terminal Services and thin clients.
Our db is Access front end with SQL backend.
My initial thought for the remote office is:
High Speed Internet
Either CAT5 to each desk or Wireless Access Point
5 thin clients.
Using RDP they should have no problem accessing our network unless they can't all use the same public IP address for our main office.
The other thought is Setting up a Point-to-point VPN. My biggest problem is I havn't worked with thin clients until I started working here. I don't know what I would need at the remote end in order to connect the thin clients through the VPN. They don't want any servers or desktops if we can help it.
Does any one have any suggestion or thoughts on this?
Thanks,
Dan
Using Two Dates To Determine If Someones On Site...
May 3, 2007Hi,
I need a little help with my Query design.
I have an Arrival Date and a Departure Date for campers checking in on a campsite. I need to produce a report for the warden to have to check who's on site.
So far, the best way I though was using a new field in the query for "On Site" (which isnt in the control table) and then using an expression such as...
[Date of Departure] < Date()
However this isnt working, probably for some silly oversight on my behalf.
Any help?
Thanks, Adzi.
VBA Access To Gather Info From External Site
Dec 29, 2006Hello All
I am doing an assignment, which is fantasy football database and instead of entering the data i thought could i import the data from say another site which is updated regularly. Can it be done with VBA Access also wanted to link the database to a apache server. Any pointers on how to do this would be appreciated or if it is feasable. Have to have assignment in before Aprial.
John
Looking For Good Tutorial On Feeding A Site With A Database.
Oct 25, 2004I am very new to ASP and Access. I need to learn how to create a database full of images and text to feed dozens of webpages for a new site I am doing. I have googled many times and can't really find what I am looking for. I've come across ADO several times. Is this similar to what I am looking for? Thanks.
View 5 Replies View RelatedModules & VBA :: Get XML From A Site And Import Data To Access
Dec 4, 2014I get XML's from a site and want to import the data to Access. If I use the native import then I get multiple tables and the data is a little jumbled. For instance: I get 1 table with track names and a different table for track numbers with no way to relate the to accurately. I would like to be able to parse out the XML and have it update my table as it goes so I have less "junk" in my DB. I just can't figure out how to call out the XML tag and tell it to copy that info to the correct field.
View 1 Replies View RelatedGeneral :: How To Split A Database For Uploading To Sharepoint Site
Dec 14, 2012Is there a tutorial on how to split a database so that it can be uploaded to a sharepoint site and one part of it allows updates and the other part only viewing?
View 3 Replies View Related