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

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

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

Hi, I want to have some queries run during the database is closed, like the functiona with "Repair on Close". But I don't want to use a form with a VBA code doing it. Is there any other possibility to do it? :confused: Thanks in advance for answers.:)

Hi, maybe I should try again. It seems there are a few user of this forum with enough knowledge to help me out of my problem. Unfortunately I got no reply to my first post yet. I'm still in pain with Access Security permission and forms running VBA code. :confused: Anybody out there with an...

Hi, I have a database, which contains linked tables to another database. The information held in the tables are mostly open for every permitted user but some of the table informations are restricted to a few user only. To manage all of this different permissions I created a workgroup, changed...