I was wondering if i could get some help here. In the startup under tools option in the menu in Access 2003., is
there any way of coding it so it would display windows database, allows
display status bar and other settings there?
Currently, i have unchecked pretty much everything except "Access special
keys" when setting up a certain form to be a startup. By default, we don't want to see all the tables in the windows database but rather the actual start up form.
what we would like to do is to allow only the certain group of people to be
able to view the windows database without using "hold on to shift key" button to
access to windows database.
Is it possible to display the user name used to log on to windows on a form? I have used the following code to get the machine name to display - but some machines are old and have new users.....
Private Declare Function apiGetComputerName Lib "kernel32" Alias _ "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSMachineName() As String Dim lngLen As Long, lngX As Long Dim strCompName As String
lngLen = 16 strCompName = String$(lngLen, 0) lngX = apiGetComputerName(strCompName, lngLen) If lngX <> 0 Then fOSMachineName = Left$(strCompName, lngLen) Else fOSMachineName = "" End If
On the Windows 7 Developer desktop, the Windows Theme is set to Windows 7.On the Citrix server (for users) the Windows Theme appears to be Windows 95. It is low graphics.The boxes are square instead of rounded. The selected Form Tabs just barely highlight with a thin line while on Windows 7, the selected Tab completely changes color. A basic Message box in Windows 95 looks square and flat. The title bar is very low graphics as one would expect when graphics were not great. Is there a VBA call that can display the OS Theme that affects MS Access? URL...
This one has me stumped:When a particular database opens, its window is partially under (hidden by) the menu and tool bar. I can't click on the window's top in order to move it. I've tried several things (i.e. resizing the screen resolution, moving the menu and tool bars, resizing the window, etc.) with no resolution. Any suggestions.Am using Access 2003, Thanks, Joel
I have a problem. This problem is that I cant see the Database objects (Forms,Report,...) in the Windows task bar. I want the user to be able to see any opened form, or report directly in the task bar as any file opened by the Windows user.
I have tried to check on the (Show Windows in TaskBar) option available in the Tools -> options of the MS Access, but it doesn work with me.
What is happening now that I am forced to show the Menu Bar and use the Window menu to switch between the objects, however, This will not be OK for me because my system hides all the command bars the MS Acccess use.
I've installed the windows XP. Also, I have an ODBC connection to ACCESS 2000 database. My scripts are already reads data from ACCESS databse. But it is failed to create new table in database. What may this problem be solved?
I have several data entry forms in my DB. What I would like to do is capture the windows user name of the people adding records and changing records. How do I go about doing that? I was think of an on change event to a given field that would then pull the username and insert it in another field/object.
Lets say the an on change of me.cmbModel update txtUserName.
All of the sudden I get an error message when I try to open my database from a file rather than through Access. If I open Access first and open the file that way, there is no problem but if I click on it from Windows Explorer, I get the error.
I have a database which is now reasonably finished and am looking slightly ahead at how it can be accessed by the staff. The first clinic has two stations that need constant access to it, namely the clinic area and the reception area.The second clinic is about 3 kilometers distance away from the main clinic and will also need constant access which, I presume,would be by hosting the database on a Windows based Server, to which all three locations would connect and then be able to use the database directly. When I say Windows Server I mean as could be used to host a web site on the Internet rather than use of an internal Intranet system.
Should I split the database and only host the backend part on the server (i.e. the tables)?Does the whole database need to be uploaded to the Windows Server?Is any other software required to make this work?I presume that I would need to introduce record locking? Is this easily done and, if so, how?
Im seeking for a solution to prompt all user with windows alert for Notification
Case 1:One staff applied leave and clicked "Submit" , after clicked I want the system will prompt his/her Supervisor for his/her leave approval or like a notification that the Supervisor need to go somewhere to approve (Selected Supervisor)(Maybe the Supervisor need to 7x24 Opening the access database).
I have a website that is asp (not .net) based with an Access DB and I am in the process of replacing an old windows 2000 server with a much faster windows 2003 server. Here lies the problem I have a script as part of the admin that exports data to a csv file. The query joins 4 tables together to get the data needed for the export. On the windows 2000 server it takes 1-5 seconds to execute and have the csv file ready for download. On the window 2003 server it times out. I striped it down to use 2 joins and it worked although it took more like 10-20 seconds to export. This exports a specific range of ID's and the range is normally only 40-50 rows. If I put time stamps in the code the problem is in the query of the database, so I know its not in the file write etc.
I am going to rewrite it to use multible querys instead of one large query, but I have many other sites that I am moving to this server that would work better if I can figure out why it is so slow.
The windows 2000 is a 900 mhz server the windows 2003 is a 2.8GHZ server both have 1 GIG of ram. The database file is on the local drive on both servers. I am guessing it is a difference in the Jet version, I just haven't been able to find a solution to the problem. This uses a DSN connection, configured the same on both servers. I have also tried it as a DSN-less connection with the same result.
I have installed access on the server and to execute the command in access it is <2 sec.
I am not an access expert I normally program in .net and php and use MySQL and MsSQL for databases, we just have these legacy sites that use Access DB's
My customer has Access programs that work on their Windows 98 OS PC's, but when they try to use them on Windows 2000 OS PC's they will not work. The programs I believe were originally written in Access 97 and now they have Access 2000 on the PC's.
By not working I mean the following -
The Access program allows them to enter a document name and then the file opens in Word - BUT - when they use it in Windows 2000 it does not open the document at all. It says file not found in Windows 2000 and the file does exist.
** The reason they have Access opening files is that Access keeps track of them for auditing purposes.
Now here is something that I want to mention. On PC's that were upgraded from Windows 98 to Windows 2000 the programs work.
Can anyone here tell me what is missing from 98 to 2000 that would do this.
On all my databases I uncheck the "display database window" on the startup menu and for the most part it works great. However, when the database is selected from the recently used list off the file menu the database window shows and how do I fix that?
I have several new employess on my facilites Access Database however their Monitor Displays are on differnet settings and the databse window is to large for their monitor, how do I set the database to open to their personel settings?
I have set my options to protect my Db. I have unchecked "display navigation bar", "allow full menus", "allow default shortcut menus" and "allow built-in tool bars". After restarting , everything else is missing but the nav bar just wont go away. I have retried many times but, no go. I have even tried to change user levels on my login but it does not have any effect either.
Also, On my split Db FE, i created a new table 'USysRibbon' to set a default ribbon without the "options" function, but I can not see the new table on the tables nav bar. I remade the table, but it says it already exists. Why can't I see it. All the tables in my FE have the blue arrow next to them to show the redirect.
I am looking for a way to either display through a query with an expression or any other alternative that someone may have to display the last 100 records entered maybe based on date entered or something.
At the moment i have a query and report going form start date to end date but would also like a query/report that will just show me the last 100 records entered.
I have a small access 2010 system. The database design was not good (replication of data all over the place) so I have been tidying up the design but have hit a few problems.I am using a form which contains amongst other things a customer name. The customer name used to be part of the enquiry table, and was picked up directly from there. I have replaced this with the key to the customer table.The only way I have managed to pick the customer name up is to change the control from a text box to either a list box or a combo box. I then have to set column count to 2 set the widths to 0 and 3 to hide the 1st one (the ID) and then set the bound column to 2 to show the customer description.
This is fine up to a point BUT the format controls on the list/combo are different from the text box so I can't replicate the back style and back colour (I had transparent and no colour respectively); the back style has disappeared and how to make the back color as "no colour".Also I end up with 2 little up and down arrows (for the list box) or ma bigger arrow for the combo.
how to display the user's record or database after he/she login in on the system. Currently I have a database where in the user enters his username and password. But the I dont know how can I make his records display after login.
Am trying to display images on a form in a split database. I add the attachment field to the associated form's table and add the attachment control to the form but cannot get the image(s) to display on the form (the control remains blank). I can add the image(s) in table view (and display them) but double clicking on the form control also does nothing.
I think I must be doing at least the basics correctly as if I try the same thing to an earlier, non-split version of the database, all works as expected.Are there additional steps required to do this thing in a split database?
I want to create a country info database. For example, Qatar (country) and the Driving info required when driving in qatar and the visa info required.
I would like a form with drop down options and when i selected which country and then driving or visa, at the bottom it would display the specific info based on my selection in a memo field lets say.
I have a question regarding the display of a list of numbers that are stored into a field of my database. Currently the numbers are comma-delineated which is fine with me, but I was wondering if there is a way to change the display of those numbers on the form so that it is easier to read.
Example:
current format - 1,2,3,4,7,8,9,10 desired format - 1-4, 7-10