Search results

As I described in post #1, I'm looking for a vba solution to do 2 things one after another: 1. Minimize Access window 2. Maximize only the form (I mean a form comes up the screen like a pop-up window) I want when user clicks on the Access icon to open the database, the main Access window goes...

Of the word Access window, I mean the window which has menus like Home, Create etc. It's possible that minimize Access main window and only keep the form open!

Hello guys, Who can tell me how to minimize Access window while it's form is on top of other open windows (e.g. other applications which are maximized like Excel). By using acCmdAppMinimize command, only the Access window is minimized and if other applications are maxmized, they will be on top...

Thank you my friend. :) It solved!

Thanks; The Login form controls are: cboUser txtPassword cmdLogin cmdCancel The code is put on Enter and Click events of cmdLogin. The using code is a function called LoginCode: Public Sub LoginCode() If IsNull([cboUser]) = True Then 'Check UserName MsgBox "Please choose the username."...

Hello dear pbaldy I have a database which has a Login form and a Main Menu. I want when users enter their Username and Password and then click Enter button, Login form be closed and then Main Menu be opened. I put the code on Enter button, but in gives error 2585. Can you please help me to...

Thank you namliam, your comment is perfectly right. I just asked to know :)

Thank you CJ_London

Hi guys, I have a multi-user database. I would like based on the logged-in user, some buttons and controls in different forms be disabled and the others be enabled. There is a login form that gets the username; I made also a function to define authorities for users in it. My plan is that when...

Could you please tell me how to disable the bypasskey?

The mistake also solved: By holding Shift key down when the database is opening, it opens without executing scripts or forms. :D But I think, this can be a bad point for the security of database!

Thank you namliam, It worked! ... But I made a big mistake and now the database can't be opened!!! I put a 3 part if in the Login form with 3 Ands. To check if Username of domain and using Computer Name are the same as what I have defined in table and also Thick of the EnableOrDisable field is...

This is the code I'm using to get the computer name: Declare Function GetComputerName& Lib "kernel32" Alias _ "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) Function GetIdentifier() Dim lpBuff As String * 1314 GetComputerName lpBuff, Len(lpBuff) GetIdentifier = lpBuff...

Yeah, I did that but nothing changed!

Hi guys, I have a database which is going to be used in network of the company. I have defined authorized Domain usernames and Computer Names in a table. There is a Login form in which I placed a code to get the computer name and domain username to compare with the ones I have defined in the...

Dear madefemere, It worked perfectly. Thank you so much for the time you spent on my problem. Have a nice time buddy :)

madefemere, Thanks for the reply: By changing the code to what you mentioned, the function (GetAllFiles()) starts to import the files and gives them a numeric name (from 1 to the number of files which I have selected) e.g. if I have selected two files, the function imports them with names "1"...

Hi guys, I made a database that in one of the forms, I like by clicking on a button the user be able to select 5 excel files with different file names (in the same directory) and then based on the imported file's names, it be stored in 5 different tables. At the moment by using the bellow code...

Yeah, it came in handy! Thank you so much vbaInet. Your're a genius. :)

Aha! You guessed correctly vbaInet. Yeah, the control's name is PartNo. Is it the problem?