Can Anyone Help With Laptop Settings?
Jun 6, 2007How to swith sleep mode off? Does anyone know? thanks
.................................................. ............
<offending URL removed>
ADVERTISEMENT
More Laptop Advice!!!
Oct 28, 2005I need an ultra portable laptop by want to get as high a spec as possible:
currently looking at sony vaio tx range (http://www.bluefi.co.uk/news/sony_vaio_tx_carbon_fiber_notebook.html) and the ibm thinkpad X90 (http://www.trustedreviews.com/article.aspx?art=511)
any ibm or vaio owners, let me know which you recommend
cheers
Laptop Security
Mar 5, 2007Help MEEEEEE!!!!!!!
hi, how can i set the settings on my laptop to enable the security settings while i am working from my router so noone else has access.
Thank you
steve
General :: Reports Not Formatting After Access Installed On New Laptop?
Mar 24, 2014My new and previous laptops are both 64 bit and installed MA 2010 on both of the computers running win 8.
When I run reports on my new laptop the reports are not formatting. They are reflecting on 4 pages and not on 1 page like on my previous laptop running the same programs.
On my new laptop I installed Office 2013 and old one office 2010 but I used the same Access 2010 on both laptops which is a separate disk as office was not the professional one.
What Have I Done To My Settings?
Jan 2, 2007Installed Access 2003 recently and could swear that on a form in design view, sizing a control button for example, by holding down shift key, worked as I expected; it sized up or down by 1/4th of a grid line.
Today, I hold down shift and size a control, and it sizes up or down by one full grid line. Can't find anything in Options that I might have changed, nor in the Format menu.
Does anyone know what may have caused this?
Security Settings
Jul 19, 2006I am new to the Access database building. I am trying to create a Student database for contact information, etc. I have a main table which stores all the users' data. When the student opens the database, I would like to identify the user. They should be able to view everyone's information, but only edit their own. How can i make this happen?
Also, if that is easy enough, I would like to identify when a staff member logs on. This way they can have special permissions to access a schedule searching feature, to look at all the students schedules.
Thanks for the help.
Mike
ODBC Settings
Mar 16, 2007Good Morning,
Im trying to set an ODBC connection to automate the connection process.
The current code I have is:
Set wrkODBC = CreateWorkspace("NewODBCWorkspace", "admin", "", dbUseODBC)
MsgBox "Opening Connection...."
Set MainConn = wrkODBC.OpenConnection("Connection1", dbDriverPrompt, True, "ODBC;DATABASE=live; DSN=live;")
which works fine in bringing up a dialog box to choose the connection.
But what do i write in the database and dsn fields to enable the automation process.
See attached picture for the log in settings. All I have to do is press 'Connect' to start talking to the ODBC.
any help would be greatly appreciated.
Justin
Access & Startup Settings
Apr 12, 2007I have been looking all over for this function in MS Access 2007. Anyone have an knowlege on how to access the Startup section?
Thanks a bunch, :D
~Kilch~
Regional Settings And Access
Mar 10, 2008I'm new to my job and ms access and not very savvy in the latter. There are fixes for my problem on the internet, but I really don't understand them.
I'm used to dd-mm-yyyy format and it's tough for me to think in mm-dd-yyyy in, for example, MS outlook. If I change my regional settings, of course, outlook and access follow suit. The access database is shared and we print out records as cover sheets for our files. Thus, it's not an option to have me on dd-mm and others on mm-dd. Is there a way for me to enter mm-dd in when using the database but have dd-mm standard for every other aspect?
If you can help, which I would appreciate immensely, please pretend that I don't know what I'm doing.
Thanks
Can't Save Printer Settings
Sep 10, 2005I designed a query, opened it and printed it. But the margins were too wide and I needed it to print in landscape also. So I changed the settings and it worked fine, but I can't get it to save the settings. Is it possible to save the printer settings for printing a query, both the margin and the landscape settings. If so, please tell me how. Thanks.
View 4 Replies View RelatedAccess: Remember Print Settings
Nov 10, 2005HI
If i set the print settings (page orientation, size etc) when i have a query open, Access has forgotten it next time i open the query.
How the smeg do i get it to remember the print settings?
Please help me im running out of hair!
Thanks
New Server - How To Change Settings (Ac 2007)?
Jan 24, 2008Hi.
I have had a server change and db was moved and I need to change the IP etc. Is there a easy way to do this? I have searched through this forum in vain. :(
Kind Regards
Marie
Find And Replace Default Settings
Dec 22, 2005Is there any way to change the default settings on the Find and Replace dialog from 'Whole field' to 'Any part of field'?
Thanks very much in advance.
Rob
PS Happy Christmas!!
Changing Property Settings By Code
Dec 2, 2006This is getting into some stratospheric territory for me.
I am trying to change the visibility property of a label and corresponding text box, based on the contents of a different combo box. cboHow is a combo box that uses a value list as its row source, since the content of the list won't change. There are three fields that I need when the content of cboHow = "FIS". Otherwise I don't need them and I don't want to see them. My code is below:
Private Sub txtFISDepartmentNumber_BeforeUpdate(Cancel As Integer)
If cboHow <> "FIS" Then
lblFISDepartmentNumber.Visible = False
txtFISDepartmentNumber.Visible = False
Else: lblFISDepartmentNumber.Visible = True
txtFISDepartmentNumber.Visible = True
End Sub
At the moment there is no error code, but the label and text field don't respond by becoming visible/invisible when the contents of cboHow changes. Do I put this code with the txtFISDepartmentNumber or in cboHow? and do I use BeforeUpdate or AfterUpdate? Should I have a separate If..Then..Else for the label and the text box?
I have been playing around with this for several hours now and seem to be going in circles.
I am using A2K
Global Variable Time Settings
Feb 3, 2005i noticed that if access is open for a long time
the globals return null
can i set the time of a global variable?
Report: Saving Print Settings
Feb 9, 2005I have a report that prints labels.
Every few times of opening the report, the page setup settings revert back to default i.e. 1" margins, 1 column etc.
how can i assure that these settings remain unchanged??
thanks!
Use Regional Settings (Date) In Calculation?
May 29, 2007I am working in a constantly changing db. The new regime is trying to calculate an inmates remaining time to work on the freeway trash crew if: 1) They show up for work and 2) have no FTA's. This form field is unbound. I currently have a query that calculates the days if they did show up for work or they had served their time. Since there are over 2500 inmates in the program, and the man power to update that many files daily isn't an option, I think it would make better since if we documented the ones that didn't show up but at the same time credit the ones that did...can this be done? If so, any suggestions. Thanks in advance.
View 11 Replies View RelatedGeneral :: Enable All Macros Settings
Aug 26, 2013Why does one have to enable all macros in the trust center in order for VBA to run? I'm making front end applications with Access and having to allow ALL macros to make them user friendly makes a huge hole in general security. I don't use any macros - it's all done by VBA.
Users are on a plethora of different platforms so changing reg keys is out of the question. Is there some way of self sign an Access accde? Is there some safe GENERAL approach (trusted sites is not good either) to allowing VBA from my applications ONLY?
Combo Box And Bound Column Settings
Nov 21, 2013I'm looking for a work around for getting the bound column setting for a combo box to work. I created a simple table with 2 fields that i have a combo box pointed to. My settings for the combo box are
Column count 2
Bound column 2
The first field is "Description"
The 2nd field is "ID"
I cannot figure out how to have column 2 to be the value that is left in the combo box once I have made my selection.
Resize Tables And Save Settings
Nov 8, 2014Under Current Database, I have "Overlapping Windows" checked. When I open a table, it opens to pretty wide. Then I resize it so that it takes up less space. After resizing, whether I click Save or not, after closing, then reopening the same table, it opens back to its original size (very wide), instead of opening at the smaller size that I resized the table to.
Is it possible to resize a table, and get it to open at that size next time you open that particular table?
Short Date = Mm/dd/yyyy Not Dd/mm/yyy (Regional Settings= UK!)
Aug 22, 2006Hi,
I have a huge problem!!!! Access seems to be picking up settings from somewhere which means that the Short date = mm/dd/yyyy and not dd/mm/yyy as set in the regional Settings!
Does anyone have any ideas why?!?!
Regards
H.
Macro Controlled Field Settings Issue
Jan 15, 2007First, thanks to all that have helped me with out even knowing it! This forum is a lifesaver.
Problem:
I have a control button that, through macro commands that seem to be working, changes a field value from locked=no to locked=yes. This macro control also changes the enabled setting to = false.
When I save and exit the form, upon reopening, the above cell value is not saved. Is there a simple fix for a simple-minded person?
Thanks in advance
General :: Auto Logout - User Settings
Jul 11, 2014I am using this [URL] .... in our project but have made a minor change so it logs people out rather than close Access completely. It works beautifully but I want to take it a step further.
Instead of hardcoding the times in these two values
intMinutesUntilShutDown = 10
intMinutesWarningAppears = 2
I'd like to give users the options to set these themselves as not everyone will be the same. I am thinking I would have to check for who is currently using the database, this is stored in a hidden form in the following field.
[Forms]![frmwhoson]![whoson]
This username matches the users First Name in table Employees and in this table I have two fields to store these values
logmeoutafter
showlogoutmessagefor
So passing these values for the current user rather than having the logout times hardcoded.
Modules & VBA :: Application Settings In Access Runtime
Oct 23, 2013In a startup-form I have following options to avoid annoying system messages in an ACCESS 2010 RUNTIME!! (.accdr)
Application.SetOption "Confirm Action Queries", 0
Application.SetOption "Confirm Document Deletions", 0
Application.SetOption "Confirm Record Changes", 0
But they do not work, there are still messages when deleting a record from an endless form by pressing "delete". I don't want to add a button. Docmd. Setwarning false in every form!
Manual Settings Of Allow Zero Length In Fields Of Table
Sep 25, 2013I'm using Access 2010 and cannot find where I can set my fields in a table to allow for allowzerolength.
Is there still a location, under table properties etc, where this can be set?
Enable Macros In Access Via Registry Settings
Sep 22, 2011I need to enable macros in MS Access.
I don't have Trust Center.
How can I do this via registry settings?