Search results

I have a form, which has text fields where user can enter data freely. The field values should be stored in tables. Therefore I created a query which selects all fields of all tables which have to be updated by the user and every test field in the subform relates to the field in the query. But...

Well, it was my last day and my last try to get it running. Should not be...but thanks a lot for your support. :) I make holiday now :D

Hi TastyWheat, I was aware of you suggestion already because I have read through McDonalds Document about "How I Use Microsoft Access User-level Security". I can only recommend that document to everybody who wants to secure an won database. Together with the Microsoft Access FAQ most of the...

Hi pdx man, you lost me a bit with your last post. Where exactly should I enter which code? The Database path is correct. But the database I'm referring to is secured. Maybe thats a problem? The error message pops up before my debugger works. When I press the button PopUsers it immediatly jumps...

Please can anybody help me I got only two days left to finish this. Thanks very much

I'm sorry. The code you gave me I already tried earlier. I didn't work as well. And because I have no other hidden form I can't open this one from a hidden from. I still lost...please. What is wrong with my code. The form is still visible...

I got a compile error: Mehtod or data member not found. This is my code Private Sub Form_Load() Me.frm_not_close.Visible = False End Sub What can I do?

Hi, I'm wondering about the following. If I would have a backend table with the data kept in tables and a frontend database with forms and reports and queries etc. and linked tables to the backend db, what would be the right way to secure both. In my situation I have salary information in some...

Hi, I have a database with a couple of tables. The primary table has a primary key called "StaffNo". I checked the relationships between the primary table and each related table, if I have ticked on the boxes for referential integrity, cascade updates. All done. If I now create a query, which...

When I press the button PopUsers I still get the message "Compile error: Wrong number of arguments or invalid property assignment." occurs. It is exactly claiming the "Call ShowUserRosterMultipleUsers" method. What did I wrong? Please help...

Currently I have a command button called PopUsers with that code Private Sub PopUsers_Click() ListUsers.RowSource = "" Call ShowUserRosterMultipleUsers("M:\PBS Wealth Management\Head office\Operations\Staff Database\PBS - Wealth Management Staff DB") End Sub Sub...

Thanks for all the good replies. Probably I should give you more information about what I have and what I want to have :) I have a secured database for multi-user access. The user will always open my database from a shortcut, which contains executable application, database-path and...

Ok. I didn't understand everything. I have a button and a list box. I named the list box already ListUsers. But what name gets the command button and what should the button run for code? Where do I need to place the path for my database? Maybe you can make it very easy, because I'm a newbie to...

I don't know, if a list box does it... Currently the code is showing the follwoing four information: COMPUTER_NAME, LOGIN_NAME, CONNECTED, SUSPECT_STATE I more thought about a button, which runs the code and produces an output table or list with the information. Is there a possibility to...

Hi, I have a sub, which shows in the Intermediate window who is currently logged to the database. This is my code: Sub ShowUserRosterMultipleUsers() Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim i, j As Long Set cn = CurrentProject.Connection ' The user...

Oh. I understand. Can you maybe provide me with the full code as I'm only a rookie with VBA

I tried the event on Unload and it's now working. But the funny thing is I cant see anything in the properties which points to the visibility? Is it possible that this property is not always available in a form?

I have some make-table-queries in database1, which I want to have run after updates in several tables in database1 are made. I thought the best would be to run them very on the end, when the user is going to close database1. Because in database2 other users select data from those tables...

I tried the UnloadEvent of a visible form and it did not work. Is it different to a hidden form? If yes, how can I hide a form? Cheers

Mhm. I see the point. I have the event triggered by the close of the form. But if the user exits the database without closing the form first, it's not running. Should I take the unload event instead? Is this running even the user exits the database directly? Thanks for your advice.