Clicked Yes On "Block Unsafe Expressions" - How Is It Reversed?
Aug 25, 2006
OK, it was bound to happen eventually...
New user of Access 2003 has inadvertently clicked "yes" to "Block Unsafe Expressions" and now can't even click a simple command button to print a report. :confused: Db has not a single macro, nothing fancy, mostly wizard code.
Other folks logging onto that PC can still function fine.
I'm assuming it has set him into Sandbox mode & we need to back out of that setting. I've searched a ton of GHudson posts on this forum, read everything Jeff Conrad links to, looked at the following MS articles.
Understand how to enable or how to disable Sandbox mode
http://support.microsoft.com/default.aspx?kbid=294698
Enable or disable sandbox mode
http://office.microsoft.com/en-us/assistance/HP010504321033.aspx
One article issues a dire warning about dangers of setting registry keys and the other doesn't seem to fix the problem at all. We're in a severely locked down environment and cannot download anything or change system settings -heck, can't even run ScanDisk anymore.
Will re-installing Access solve this, or does anyone know of a solution that will work given our limitations?
Any help is appreciated!
View Replies
ADVERTISEMENT
Jul 13, 2005
I'm using Windows 2K SP4 and have just installed Office 2003. Everytime I open Access I get a message asking if I want to block unsafe expressions (presumably macros). How can I turn this off?
BTW I've downloaded all of the security updates, which are recommended by MS.
View 7 Replies
View Related
Apr 5, 2007
Hi,
Can anyone tell me why it is that when i have written a DB on one machine using Access 2003 and then subsequently put that DB on to another machine i get an error relating to unsafe expressions?
why does this happen and is there a away in which can stop this error message from appearing?
I am trying to implement the DB i have written at work but it does not look good when i get a constant error message appearing when ever i open the DB.
Thank you in advace for your help
Regards
Bev
View 3 Replies
View Related
Jan 9, 2007
I have recently deployed an application at work [work pcs all running A2K2], built with A2K3 on home computer.
I split the database housing the backend on our server, named server, and using frontends on users pcs.
I am running a VB script that takes information from another linked db on server (so everything would be housed together and not on users pc) this script runs a query converts to xml, opens FTP and uploads the query along with .pdfs to the internet.
I can get it to work from home, no problem. I can get it to work from my pc at work.
But when I try on other pcs it can not find the db (error msg) or opened by another user in exclusive mode, yes I explored this option I dont think this it. 1) Cause the frontend can see the backend and everything works from there. 2) That pc is the only one with an open frontend. 3) When I try opening the actual db from the networked shared folder I get an unsafe expressions alert and can not open. The VB needs to open pull from the 2nd db. Both the backend and 2nd db I get this message.
Can anyone tell me how I can change this, the msg box says its out of trusted network. So I copied and actually opened on local pc, I could open it. Move it back to server and no such luck.
Thanks for any posts, I am having to get this working before I load for other branch offices.
I have googled and searched forum, seems everything is geared towards "sandbox".
View 4 Replies
View Related
May 15, 2007
G’day all :D
I was wondering if there was a way to setup a Reversed Crosstab query:confused: . I am running a query which is pulling data from an import table. But the one thing is the data that I import is already setup like a Crosstab. Ex:
First Name, Last Name, Employee ID,Value 1,Value 2,Value 3,
Joe, Smith,38689, 4,2,8,
Bob, Smith,38957, 7,3,2,
Matt, Jones,38745, 4,7,7,
Jill, Brown,38467, 6,4,3,
Joan, Miller, 38058, 8,9,6,
I tried to setup multiple queries for each value then tried to pull it all into one query, but then I get all records multiplied 5 times.:eek:
Basicly I need the following results:
First Name,Last Name,Employee ID,Value,Number,
Joe, Smith, 38689, 1,4,
Joe, Smith, 38689, 2,2,
Joe, Smith, 38689, 3,8,
Bob, Smith, 38957, 1,7,
Bob, Smith, 38957, 2,3,
Bob, Smith, 38957, 3,2,
Matt, Jones, 38745, 1,4,
Matt, Jones, 38745, 2,7,
Matt, Jones, 38745, 3,7,
Jill, Brown, 38467, 1,6,
Jill, Brown, 38467, 2,4,
Jill, Brown, 38467, 3,3,
Anyone thing that will help, I will be very grateful,
Thanks in advance
Mur
View 6 Replies
View Related
Feb 14, 2008
Hi
This is my first post and i searched to try and find an answer on the forums but can't seem to find one so thought i'd ask to see if anyone is able to help. Sorry if this has been answered before and i've been a bit thick not been able to find it. anyway here's my question...
I have 2 fields i want to check in my database DOB1 and DOB2 (date of birth of applicant 1 and date of birth of applicant 2.
i've written a query that looks for any records where the data in DOB1 and DOB2 match the data in another record for DOB1 and DOB2. i hope that makes sense. this is what i've written.
In (SELECT [App1 DOB] FROM [Data] As Tmp GROUP BY [App1 DOB],[App2 DOB] HAVING Count(*)>1 And [App2 DOB] = [Data].[App2 DOB])
this seems to work but please feel free to correct me.
Now the part i'm struggling with is trying to find duplicates where the fields have been reversed. eg App1 DOB and App2 DOB are the same as App1 DOB and App2 DOB in another record but applicant 1's Date of birth has been stored as Applicant 2 and Applicant 2 is now stored as Applicant 1. i hope thats not to confusing.
Basically i'm trying to check for duplicate mortgage applications in the database but sometimes applicant 1 and applicant 2 are reversed.
Any help would be greatly appreciated.
Thanks
View 8 Replies
View Related
Jan 27, 2014
I'm running pro bono a linked file database for a wildlife hospital in Australia. I have a Form in which there are several fields for vets to enter data about a wildlife patient. One of these is the Collection Plan (for the patient). This is a memo field from the TBL_Accession. The Collection Plan is written in straight English on the input form, but the data entered into the table is completely reversed, reading "etinuer ot ovra siht pu/p ot ronod". Translation for the line here is "donor to p/up this arvo to reunite".
View 2 Replies
View Related
Sep 11, 2014
I have a data entry form which have a date field.This field retains the existing date after the record is saved with vba after update event.
Private Sub Form_AfterUpdate()
Me.ProductionDate.DefaultValue = Chr(35) & Me.ProductionDate.Value & Chr(35)
End Sub
Almost after a year of perfect working i am facing a problem.When i save the record , in date field my date and month values are reversed if date is between 1-12.although my database stores perfectly valid date. for example if date is "10-09-2014" (dd-mm-yyyy) after saving form date field becomes "09-10-2014". but if date is "13-09-2014" The date form field retains this value .
View 2 Replies
View Related
Jul 13, 2005
Hi-
I am a self taught beginner in Access applications, so excuse my lack of expertise and terminology. From reading through this forum, I realize how far I have to go. I am not a techy by any means.
My question: I have a database that keeps track of the delinquent taxes for our Town. One of the reports is set up from 2 queries, then 2 related tables (beginning balances and payments made). The query calculates the balance of each account based on the beginning balance minus the payments made, and returns a report which shows each account balance, and then another query returns a report showing the total balance of all the accounts due for the date the report is generated.
I am wondering if there is a way to generate the balances due on a previous date. For example today is July 13, and I want to know what the balances were on July 1. Both tables have a date field- beginning balance has a start date, and the payments table has the dates of any payments.
Thanks in advance for any advice
View 6 Replies
View Related
Oct 18, 2005
What is the condition or how should I write a VB code to block the command go to last empty record? I have a form which has three buttons : Go to Previous Record, Go to Next Record and Add New Record. If I add a new record, and I press "Go to Next Record" well, it goes to the next empty record this means it does the same job as the "Go to Add New Record" button. How can I stop this happen?
Thanks,
Le
View 2 Replies
View Related
Mar 13, 2006
I hope someone can help me. I have a report that prints out with the customers social security number on it. I need to change it so that only the last four digits of the SSN show, so it would like something like this XXX-XX-1234. I still want it to keep the full SSN in my Table though so we can search for the customers info with the SSN.
Is there a way that I can change it on the report only and not mess up any other forms that I have it on? Any help would be awesome!
View 4 Replies
View Related
Oct 20, 2005
I have a form for all my clients, and currently there's a separate field for each part of the address. This does not make it easy to cut and paste an entire address block. I therefore created an unbound text box with the control source as:
=[FMT-NAME] & Chr(13) & Chr(10) & [Pref1] & Chr(13) & Chr(10) & [Pref2] & Chr(13) & Chr(10) & [PrefStrt] & Chr(13) & Chr(10) & [PrefCity] & ", " & [PrefState] & " " & [PrefZip]
This works ok, but if someone doesn't have anything in the fields [Pref1] or [Pref2] it leaves blank lines. Is there a way to code it so that I can have a complete address block? Thank you.
View 4 Replies
View Related
Sep 25, 2006
I have a form displayed as data sheet, how can I block the column so that the final user will not modify the width of the columns?
M
View 1 Replies
View Related
Oct 12, 2004
I need to export a table as a text file but using the outputto or transfer text options do not produce the file format I want. If I export the file as Excel and then save it as text it's OK so I copied the following code to automate the procedure but get an error 'Object variable or With block variable not set.
Can anyone help?
Function Export()
Dim objExcel As Excel.Application
DoCmd.OutputTo acOutputTable, "MyTable", acFormatXLS, _
"c:dataMyExcelFile.xls", False
Set objExcel = Excel.Application
objExcel.ActiveWorkbook.SaveAs Filename:= _
"C:dataMyTextFile.txt", FileFormat:=xlText, _
CreateBackup:=False
objExcel.Quit
Set objExcel = Nothing
End Function
View 4 Replies
View Related
Jun 6, 2014
I have the below code that seemed to work until I tried to add the Loop to it. Now, every time it gets to the piece of the loop with the words Cells.Find, I get an error stating "With Block or Variable not set". I don't understand what the problem is. There is no "With Block" and the variable is set. How can I get this to work?
Code:
Function ClearColumns(xlWS As Object, ColumnRangeToClear As String)
xlWS.Range(ColumnRangeToClear).ClearContents
End Function
Public Function SendTQ2XLWbSheet(strTQName As String, strSheetName As String, Col As Integer, strFilePath As String, FirstCellStr As String)
[Code] .....
View 7 Replies
View Related
Jul 1, 2013
I Have a table votes where a user is able to vote for a specific campaign, when the user votes his username and the date and time is logged in the table votes.
After the user voted he is logged out, then displaying the login form for the next user.
At the login form I want to check if a user already voted and if so he should not be able to login again. How can you do this ?
View 3 Replies
View Related
Jun 10, 2005
Hi all
Please help. one of my table is confidential data and I don't want people from opening from the table. Can I block people from opening but people who has password can only access this information.
eg. please see my enclosed attachment file and the table is cost. I don;t want people to see the data by click the table filename.
Hope someone can help me.
View 1 Replies
View Related
Feb 25, 2006
I am developing one software in access 2000. Now where i stuck up is ... Customer is asking for " process flow chart" (steps in block diagram). The requirement is as below..
For a pen there are below operations
1. moulding
2. cleaning
3. polishing
4.assembly
Now these flow of operation is to be presented in block diagram. Please suggest me how do I do this in accesss? (in form or report)...
View 3 Replies
View Related
Nov 8, 2004
I have a table which has a primary key of 3 fields. Each individual fields is defined with duplicates OK but I want to block a record being added where the primary key value exists already. How can this be done - the way I have set up the database Access does not automatically stop this as I thought it might. Do I need somw vb also??
View 14 Replies
View Related
Mar 12, 2006
I've got this yes/no message box that deletes an appointment. When i click yes to confirm delete, the box just stays there. I have to click yes again before it works. Clicking no works fine. Its like its going round the else if statement for vbYes twice. Does anyone know why this is happening? Heres a snippet of the related code. Thanks in advance.
If myYesNoQuestion(strDelete) = vbNo Then
myDisplayInfoMessage "Appointment kept on file"
'If the user decides not to delete the customer then appointment kept
Calendar3.SetFocus
'Sets the focus away to allow the rooms to be disabled
lstRoom1.Enabled = False
lstRoom2.Enabled = False
lstRoom3.Enabled = False
lstRoom4.Enabled = False
'Disables the rooms again
ElseIf myYesNoQuestion(strDelete) = vbYes Then
strSQL = "DELETE * FROM tblAppointment where [AppointmentID]= " & .Column(2)
'SQL to delete appointment from table
DoCmd.SetWarnings False
DoCmd.RunSQL strSQL
DoCmd.SetWarnings True
'Turn warning off, run SQL, turn them back on again
myDisplayInfoMessage "Appointment Deleted OK"
'If the user decides to delete the customer then record is deleted and a message is shown to prove that
Calendar3.SetFocus
'Sets the focus away to allow the rooms to be disabled
lstRoom1.Enabled = False
lstRoom2.Enabled = False
lstRoom3.Enabled = False
lstRoom4.Enabled = False
'Disables the rooms again
End If
End If
View 5 Replies
View Related
Jun 22, 2014
I have a form, with just two buttons, say "Tyre" and "Engine". These buttons open the same form, say frmCar.
What I want to do is when I click the "Tyre" button, a tbo in the frmCar to get as value "Tyre" and when I click the "Engine" button, the same tbo in the frmCar to get the value "Engine".
View 10 Replies
View Related
Apr 27, 2006
Hi, in some application I have made using a switchboard after starting up, I saw that when the user holds the shift button, this switchboard does not show up automatically. How can i fix it that the user cannot interfere holding this button?
View 2 Replies
View Related
Sep 23, 2005
The Return of the dreaded mousewheel! I have used the fab Search option on this topic, but I feel I have some requirements that prohibit me using some of the options available. I need to allow its use for navigation of the mainform, but totally block it on the subforms, but with lots of conditions!
The database in question is NOT mine, and it's already built. If it were one of mine, I'd simply block the darn thing entirely or adopt some of the example databases I found (ghudsons was the kind of data verification I can dig, and a few in A97 format were good too).
I have to cater for workmates that are strangly fussy, rather lazy and totally unappreciative of order. Who would have though enforcing uniform entry of dates from 20 different ways (I counted) to one way, was such a contentious issue? OR, a BAD idea? Sigh.
As a result, I cannot be seen to have done ANYTHING to its function. So, I cannot have:
*Any form of "save" each record or blocks or anything like that
*Any form of validation boxes or message boxes popping up
*No dlls (if possible)
*In a nutshell, no extra effort - Type 'n' go - it has to be a secret
*And, I can't block the mousewheel from scrolling through personnel in the mainform.
I have to eliminate the RAMPANT creation of duplicate subentries (like, you're still on the one record in the main form, but if you're not paying attention and wheel in the subform, you flick over to the new row and type, and POW).
Am I dreaming? Is there some easy solution in form setup that I'm overlooking? (the problems of self-education, you are often unaware of some of the simplest little options). I aplogize if this solution has been presented before on the board, but it is likely I didn't not understand what I saw properly, or I felt it wasn't quite what I wanted. Thanks very much.
View 1 Replies
View Related
Dec 4, 2012
My database contains business names and addresses in separate fields (name, address, city, zip code, state, country)
Now I have to build the address block for labels.
If there were just US addresses it would be easy but a business can be located in any country with the problem being
that countries require the block to be build in a specific way (order of city, state, zip code).
In some cases a particular section has to be upper case as well.
Of course I can build it manually in a memo field but the with chance of something easily going wrong I like to automate it.
It does mean the same info will be stored twice which is basically a no no.
I'm thinking of making a separate table with records for all possible layouts and use those as a source for a memo field in the business table. However I can't oversee if that would work alright or not.
Or should there be a way to generate the blocks on the fly?
View 9 Replies
View Related
Jul 27, 2006
Hi,
Please see attached image.
http://img136.imageshack.us/my.php?image=jkkv6.jpg
I have this subform in a form, i want the field that has a hyperlink (which is called Link) to display a check box once the file path has been pressed, so when each path (Link) is pressed i would like the form to display a check box that would tell the person if that pathfile had been pressed. I would like this to show for each of the path files.
Can anybody help please.
Thanks
View 9 Replies
View Related
Oct 31, 2006
I'm using Access 2002 and when I try to scroll up or down it selects the row and then scrolls 1 row. Is this a bug?
thanks
Paul
View 1 Replies
View Related
