How do I get rid of the start up dialog? The boxes which pop up and say "Security warning, Unsafe expressions not blocked" and the other that says "warning this document may not be safe blah blah blah".
Hi All. I created query with dialog box in Access : SELECT (Format([Date_P],"mmm yyyy")) AS [Date_P], Result, Count([Date_P]) AS Pos FROM ABC GROUP BY (Format([Date_P],"mmm yyyy")), Result, Format([Date_PAP],"yyyy") HAVING Result<>"neg" AND Count(Date_P>0 AND (Format([Date_P],"yyyy")=[Please, enter year (yyyy):]); How to convert that query to veiw MS SQL? Thank.
On my database, for startup, I had the toolbars taken away from the user. Is there a quick shortcut to pull them back up? I noticed that the 'Tools' option is gone.
I have a database (split) I developed using Access 2000 (Office Professional). I installed it in a lap top that has Office Prosessional 2002 and am encountering several problems: 1) The shift-key bypass does not work; 2) My application uses an access wizzard switchboard. With the lap top, when I open a form from the switch board and subsequently close it, Access closes; 3) When I just open Access in the lap top, I get none of the standard tool bars. (I don't know if I caused this). This has to be something obvious that I just cannot see. Thanks in advance for your help.
I've created a new database, and unticked the options in Startup which mean the various menus at the top are hidden - and I don't know the keyboard commands to get them back :S
I created a database and put some time into it at work here. I am sure this is a simple fix but I need to know how to get my tools back at the top of access. :(
What I did was open startup, unselected all the features that locks the database user out from changing settings and just using the switchboard and forms. Well, I cant figure out how to get into the file and change it all around now. :eek:
I am using access 97 at work now so please respond asap with an answer about how to get to change my tables, forms, and use tools again...:confused:
Here is something I hope someone can help with. I have mostly completed my Access program. I was toying around with the startup options and I selected not to have my toolbars in the startup in fear that other employees at work could mess up the program. Now I would like to tweet my database and add to it but have no toolbars to make any changes or add new form or anything. Is there a way to now change my startup options back to normal and get back my toolbars or do I have to re-create the complete database? Help please!!!!
I have made a critical error with my system, in tools on startup i unticked all the boxes, and now when it loads it brings up the system only and not the design view tables etc,
Hey, I was messing about with tools>startup because I wanted a form to appear whent he database was opened.... I unchecked far too many options in there, and now I cannot design and modify my database anymore... it just goes straight to the form, but i cannot get anything back in design view.. is there a way to fix this??
I setup a splashScreen in startup, and I uncheked all check boxes. Now, as soon as I load database starup form shows, and does not allow to do any modifications.
Is there any way i can "Undo" or drop splashScreen, and get back to normal loading of database. Thank you.
Have a database that when opened, has a message box that appears and when this box is closed via a Close button that I have named "OK", the main form opens. I have a Tip table that I type in the message which then appears in the messaage box form. It works perfectly providing I use a Next Message/Previous Message Button to control which of the many numbered messages on my table I wish to use.
What I want is to make sure my users have no control over what message is shown. I would still like to maintain all messages on the table by number and only have the Close (OK) button on the form. While trying to do this with the present code and if I only have 1 message on the table (#1) it will show that message. If I add a 2nd message to the table (#2) without erasing the 1st, it still only shows the first. This way I have a record of everything I have sent messages on. Below is the exisiting code used for my message box with hopes you can tell me what I need to change to make this happen:
Private Sub Form_Load() On Error GoTo Err_Form_Load
Hi, I have a report and I am doing some SQL stuff at the back end on the report open. This takes a little time and I want to show the user that its working and I want to prevent him from double clicking the report again. So is there any way to show a progress dialog or something so that the user knows that the list is being built? Thanks in advance! Adwait
I am in the process of creating d/base of early settlers for our local museum. The Fields need to have reference to one or more files or programs outside of Access, e.g. Legacy, Word, photo files, d/bases of electoral rolls, etc. The apparent easy solution was to attach these sources and I also got a handy Attachments dialog box that showed me the list of attachments for a every person or place. However, after entering only 10 names and attachments, the file size had grown to nearly 8Mb - obviously impracticable if the d/base is to contain over 2,000 names.
So, I switched to using Hyperlinks which cut the file size by 90% but now I have another problem: Hyperlinks only lead to one item, e.g. a photo, whereas the person concerned may have several photos and several other references. This would necessitate creating multiple Fields.
Is there a way to create a Dialog box (similar to the Attachments box) that would show me a list of the Hyperlinks for a particluar person?
Does anyone have any db's that show how to relink tables automatically on start up and also remove the links on shutdown, i've been searching everywhere on the net and can't seem to find anything decent, any help would be appreciated.
I'm not sure this would be allowed as it could be maliciously abused, but what I want to do is turn of warnings when a user fires up my DB.
What currently happens is a user gets 3 pop up warnings in a row the first time they use the DB with essentially the same warnings and "do you want to run this" questions.
The next time the user runs the DB they only get one warning.
On another thread I was told how to turn warnings on and off within the database: http://www.access-programmers.co.uk/forums/showthread.php?p=499732#post499732
'Turn warnings on & Hourglass on DoCmd.SetWarnings False DoCmd.Hourglass True
Code in routine that would generate warnings goes here.
'Turn warnings on & Hourglass off DoCmd.SetWarnings True DoCmd.Hourglass False
What I would like is some way to replicate the functionality for the DB. Is this possible?
I have a problem where i unchecked the "allow built in toolbars" , "allow toolbar menu changes","allow full menus" and " allow default shortcut menus" from the TOOLS Menu item (STARTUP) How do i get back all the menus to show when the application starts up?
Is there any way that anyone knows to have a table open on startup? I am not using a form, because the nature of this database is easier to use with a table. And I can't use Excel because I need reports out of the data.
Having said that, I have some users who may be partially Access-illiterate, and it would be easier to have them work on a table that opened for them. Any clues?
Hello to everyone!, Could I ask a help how could I possibly code MS Access Startup to set the MenuBar, ShortCut Menu, FormMenu, Special Keys to OFF to prevent user from using these keys when my application starts?