Display Windows Log On Name

Aug 11, 2005

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

End Function

Then use =fOSMachineName() in a label


Any idea?

View Replies


ADVERTISEMENT

To Display Windows Database

Feb 4, 2008

Hi,

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.

Thank you in advance

View 3 Replies View Related

Modules & VBA :: Call To Display Windows Theme

Jul 14, 2014

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...

View 2 Replies View Related

Works On Windows 2000 Not Windows 2003

Sep 19, 2006

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

View 1 Replies View Related

Access And Windows 98 To Windows 2000

Nov 27, 2006

Hi All,

This is my problem -

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.

Thank you very much for your time.

View 3 Replies View Related

Vista 3d Windows To Windows Xp

Oct 20, 2006

Does anyone know if there is some type of theme to make windows xp windows 3d like vista's windows. example below.

http://www.winvistabeta.com/files%2Fscreens%2F5365%2Fexplorer%2Fwindows-vista-3d-switch-screen.jpg

View 2 Replies View Related

Access And Windows XP

Nov 30, 2005

We have recently converted from Office 97 to 2003 and Windows NT4 to XP.

In the old days, when I opened a database up I would use autoexec and the db would open to a particular form. On the windows display it would just show that I had a particular Access database open. On windows XP, if I open the database the same way I get two bars at the bottom of the screen showing the objects and the relevant form. This means that all the design is available for people to see.

I am not that clever to have front and back ends etc, so how do I get it to just display the appropriate query / form / report etc.

I hope that I have made it clear. The XP feature showing how many files you have open is quite handy if you want to look at two Word documents but in Access it allows people to fiddle. If they can't see it they can't fiddle with it.

View 9 Replies View Related

Open With Windows/XP

Dec 5, 2005

Hey all I was wondering if there was anyway to open my program when windows opens, I have the XP sytem but I was also wondering if there would be a difference with windows 98... SO What i would like to accomplish is to open my access program without clicking on it when my windows, is loaded, can I open it when it loads automaticly. Does it matter that there are different users on my system or not. Thanks

View 1 Replies View Related

Access 97 And Windows XP

Sep 15, 2006

Hello everyone

I have an issue with access97 when installed on a windows XP pro sp2 machine. I am constantly getting errors from the vba332.dll module and access shuts down on me. This happens even if I try to go to tools - options on the main menu bar. If any one has encountered this before please help!

This is what I get in the application log:

Faulting application msaccess.exe, version 8.0.0.5903, faulting module vba332.dll, version 3.0.0.6908, fault address 0x000b6614.

View 3 Replies View Related

Windows Cannot Find ...mdb

Jan 24, 2007

Hi all

This message has suddenly started to appear when clicking on a shortcut to all my mdbs.

Windows cannot find [path] .mdb

I click OK and the db continues normally.

the message does not appear when opening a mdb directly.

odd huh?

any thoughts on how to resolve this annoying problem would be appreciated

View 1 Replies View Related

Getting Windows Version With VBA

Apr 10, 2008

Hello,

How can I get the Windows version that I have installed on my PC from ACCESS 2005 (VBA)?

Thank youvery much

View 6 Replies View Related

Windows Username

Jul 25, 2006

A couple of questions. I want my database to query the AD and make sure that the user trying to open the database had an account in the AD. I dont want them prompted for a password though. I have had a look at trying to change the example NT logon in the samples area, but just managed to get myself in a bit of a mess. Also is there anyway that you can query the users full name in AD and call that variable,or does this only work with the username?

Also, when a user created a record in a from, I would like the users username, called from the AD saved in a field in the table. I have tried this and the only way that I can call the variable is by having the "=Environ("USERNAME")" in the control source of the text box. Which means that it cant be save in a field in the table. I have also tried an after updated event on that textbox to update another textbox and have that textbox control source a field on the table. But again this doesn't work. Can someone tell me if what I am trying to do is possible. Thanks

View 1 Replies View Related

Subforms & New Windows

Sep 15, 2004

There are three tables in my database. Clients, Accounts, and transactions. I have a form which when you select a Client an "accounts subform" populates with their accounts and the "transactions subform" populates with their transactions for the selected account. YOu can select different accounts and the transactions will change. Unfortunately all these things on 1 form is cluttered. Is there a way to open the transactions in a new window? So if i clicked an account record, a new transaction window would pop up. I'm not sure if you can make that relationship.

Thx
-Cam

View 11 Replies View Related

Windows Resizing

Sep 17, 2007

I have a form is set to Maximize on open
I have a drop down box on that form that allows a user to select a report and then the report runs and opens.

The problem is that when I close the report the form that I had DoCmd.Maximize is no longer maximized...

I have tried On Focus, OnOpen, OnLoad etc

I cant find the event that I can code on to get that Form to maximize when I close the report...

Any thoughts...

Can I set the Form to always be a specific size or maximized? I would prefer Maximized due to screen resolutions beign different....

THanks

View 1 Replies View Related

Windows Explorer On Form

Apr 14, 2006

Hi All,

Is there a way that I can view window explorer within a Form. Is it also possible to have Drag & Drop facility in that form.

Thanks in advance,

Jatz

View 3 Replies View Related

Windows / Apple Compatibility

Jul 18, 2005

If I were to create an Access database within the Windows platfiorm, would it be accessible on a Mac machine with MS Office for Mac installed? Please advise on the implications here i.e. will the Security features work (MDW file, etc).

Any feedback would be greatly apreciated!

Randeep

View 3 Replies View Related

MS Access For Windows Problem

Oct 17, 2005

Upon closing a database using Access 2000 Runtime, I am getting the following error: -

Microsoft Access for Windows has encountered a problem and needs to close.

This happens just as I am closing the database down and not at any other time. It also only happens on Access Runtime.

Can anybody please help? :(

View 11 Replies View Related

Windows Explorer On Form

Apr 14, 2006

Hi All,

Is there a way that I can view window explorer within a Form. Is it also possible to have Drag & Drop facility in that form.

Thanks in advance,

Jatinder Kalsi

View 1 Replies View Related

Windows Installer Issue

Aug 28, 2007

Hello there,

I use access 2000 but also have access 2003 installed on my computer. Access 2000 is my default version and is usually what I use 90% of the time (for various reasons).

Anyways, every time I launch 2000 (without going into 20003 at all) it ALWAYS brings up windows installer. Is there a way to fix this or must I live with it since I have 2 versions installed?

Thanks!

View 2 Replies View Related

Getting Rid Of Multiple Form Windows

Mar 10, 2006

Hi,

I have a database that contains a navigation menu. It links to several other forms throughout the database, providing users with easy access to the databases features. At the moment, when each link is clicked, it opens another seperate window with that form as the contents. As you can imagine, after a session, the user has around 20 different forms all along the taskbar, just from navigating through the database. Is there a macro or command that I can put in place to 'replace the existing window' when a link is clicked, so only one window is open at the end of a session? (The simpler the better in terms of explinations, macros aren't my best area). :)

View 4 Replies View Related

Opening Smaller Windows

Sep 15, 2006

Hi Guys

Im' Pulling my hair out at the moment trying to get my forms to re-open in the smaller view after ive closed them.

Ive tried Cmd.movesize which works ok occasionally but when you turn your back the next time the darn thing opens maximised.

Is there a simple command to get the window to open in the smaller mode like DoCmd.Maximize does for the full size mode?

I would be much obliged for any help with this one.

Thanks in advance for any help offered

All the very best for now

Tony

View 5 Replies View Related

Windows Taskbar Hidden By Pop-up

Oct 15, 2006

I have searched the forums but all I can find is code to hide the windows taskbar, when actually I want the opposite.

I have a form which I have set the following properties:

Pop-up = Yes
Modal = No
Control Box = Yes (Only while designing, will change)
Max/Min = None

I have also placed code in the On Load event namely "DoCmd.Maximize"

When the form loads, it maximises as I would like but it also covers the windows taskbar, which is something I don't think my users would like at all!!! Any idea how to get it to still maximise ( as this hides the db windows) but not hide the taskbar?

View 4 Replies View Related

Windows 2000 Server Ftp

Jan 22, 2005

hi im running windows 2000 server and im hosting more then one website from it..
if "members" want to ftp there folder at my server, via the login user name and password that i give them.. but i can not seem to have no more the one ftp site running at any one time, i get an error say that:

The service could not be started because it is not correctly configured. Make sure that its server bindings do not conflict with other sites running on the same machine

what does this mean and what am i doing wrong.... thanks

View 1 Replies View Related

Minimizing All The Windows Within Access On

Apr 10, 2006

Hi,
When the user clicks on the file name, I want the form to load automatically & also at the same time minimize the database window (i.e. the window where all the tables, queries etc are listed). Any suggestions?

Thx in advance,

Jatz

View 1 Replies View Related

Opening MDB Files Under Windows 7

Aug 8, 2012

I have a PC with Windows 7. I installed Access 2003 (which opens OK) but .mdb files will not load ie my old saved Access files. How can I load these files into Access 2003?

View 1 Replies View Related

Access 97 And Windows 98 - Super Slow

Jun 6, 2005

I have one PC running win98,acc97 and Access is CRAWLING. I'm seeing this on ONLY this one PC, and in multiple databases.

Any ideas? Possible places to look to fix this? I've tried reinstalling Office, I'd rather not have to rebuild this pc.

Thanks,

-Mike

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved