Question How to import a sample DB in your DB

[Pusher]

Hi all,
I found a great [FONT=&quot]Password Login Screen with session login recording [/FONT][FONT=&quot]in the Sample[/FONT][FONT=&quot] [/FONT]Thread Forum - http://www.access-programmers.co.uk/forums/showthread.php?t=193131 - What is the easiest way of integrating it into my database.

 

[GinaWhipp]

Ummm, hard to answer that without seeing your database. You're going to need to either create new tables or add fields to existing tables. Then your doing to bring in the Modules and Forms, unless you have a form and not sure if you want to use all the forms. And then create a query. I don't know how easy/hard that is but it is kind of straight forward.

Perhaps if you tell us the specific areas you are having a problem with we can help better...

 

[Pusher]

Can i just import all the elements and link my main switch board in the place where DCrake marked?

 

[GinaWhipp]

I do not see any place where David says just import it in to work. Okay let me say this, in the time you spent psoting, getting a reply, posting again adn me sending this reply is more time then it would take if you just get started...

Make a copy of your database if you timid about making changes to the master (I would be) and then start the process. As I said, we can't see your database, we don't know which fields already exist and which ones you will have to implement to get David's sample to work. HOWEVER, jump right in there or it will never get done!

 

[Pusher]

I imported it all and here is my db.
Here is the place where you link it to the main window in
'/Open the main form and close this one

 

[GinaWhipp]

What language is this? I do not understand the tables or the forms to be able to tell you what to do.

 

[Pusher]

I imported it and it works fine - but now i have some other problems.
I integrated the [FONT=&quot]Password Login Screen with session login recording [/FONT]- PasswordLogin.mdb (http://www.access-programmers.co.uk/...d.php?t=193131) that DCrake made into my DB.(Thanks DCrake)

Now i want to make the combo box in the FrmLogin (CboUser) to be the locked value of the combo box of my main data entry form IZVESTAJ (DEZURNI DISPECER) so that in every line in my DB there is a record of the user that logged in and entered the line but with no possibility of change in the IZVESTAJ form. How to do this?

Here's my DB in the attachment

 

[GinaWhipp]

Please tell me what language so I can see if someone can assist. I do not understand what is in your database to properly assist you.

 

[Pusher]

It's Serbian language, if you want i can tell you what you need to know

 

[Pusher]

Or there can be an automatic entering of the value in first form in every new line in the table of the second form.

 

[GinaWhipp]

Hmmm, don't know anyone who speaks that language so let's see if I can explain to you what to do...

So you want to lock the controls after a User selects their name? You can put in the After_Update event...

Me.MyControl.Locked = True

...but if you have alot of controls that's alot of typing. OR you could use this function...

***** Copy in a module window but do not name module the same as the Function...
Public Function fncLockUnlockControls(frm As Form, LockIt As Boolean)
'Lock or unlock all data-bound controls on form,
'depending on the value of <LockIt>: True = lock; False = unlock.
'Dirk Goldgar 2005
On Error GoTo Err_fncLockUnlockControls
Const conERR_NO_PROPERTY = 438
Dim ctl As Control
For Each ctl In frm.Controls
With ctl
If Left(.ControlSource & "=", 1) <> "=" Then
.Locked = LockIt
.Enabled = True
End If
End With
Skip_Control: 'come here from error if no .ControlSource property
Next ctl
Exit_fncLockUnlockControls:
Exit Function
Err_fncLockUnlockControls:
If Err.Number = conERR_NO_PROPERTY Then
Resume Skip_Control
Else
MsgBox "Error " & Err.Number & ": " & Err.Description
Resume Exit_fncLockUnlockControls
End If
End Function

...and lock multiple ones or certain ones using the .Tag property of the control.

 

[vbaInet]

Pusher,

Double posting is frowned upon in any forum:

http://www.access-programmers.co.uk/forums/showthread.php?t=215615

 

[GinaWhipp]

@vbaInet... I'll be moving along as I see you have a much better understanding of Pusher's database.

@Pusher... Not only frowned on BUT we are UNpaid volunteers who, in our spare time, answer questions. Not really fair for you to double post thereby taking time away from someone else waiting for assistance.

 

[Pusher]

Sorry about that, i am in a little time pinch at work and not that familiar about forum rules..
Thanks for all your help and i will try to fallow the rules more closely..