Search results

yes they do actually have db_owner permissions (i have a limited (18) and trusted user group ;) anyway, just found the solution in another forum, all that was needed is the add dbo to the name string, so that the code is now ----------------------------------------------------- Private Sub...

bytheway it's Access 2007

Hi mdlueck and SQLhell ! thnx, i realised now that the problem isn't in SQL, since the user can open the view fine directly, the problem is in the access UI i have made, here is the code i use: ----------------------------------------------------- Private Sub cmd_VisPoster_Click() On Error...

Hi, I have a SQL 2005 database with users that have permission through a role to update, select, delete and insert in my tables. i have given permission also to a "view" (query) containing only fields from tables that they have permission to update, select, delete and insert into. But when i...

My god, that did work. I tried " & Me.combo_EPIDdelta4.Value & ", "" & Me.combo_EPIDdelta4.Value & "" and """ & Me.combo_EPIDdelta4.Value & """, before but NOT with *four* quotationmarks. Thank you so much! saved me from headache!

argh, i was too quick there, above solution didn't work

Ok, so i just found out myself, the expression : IsNull(Me.combo_ApparatEPID.Value) is not possible to evaluate (Value being a string i guess? ) I removed the if statement resolving the problem (actually didn't need it)

Hi i have a weird problem, i'm building a user interface in access and i want certain entered values in subforms to repeat/copy to the next record - it's working for one subform but not another (a subsubform) and i cannot find out why. I'm doing it like this: in the 'properties' -> 'events' of...

Hi I've been using various programmers forums for quite a while - immensely useful as i was given the task of building a database in access with no previous knowledge and no colleagues with a deeper knowledge around - without ever registering, thought it was about time (especially since I ran...