Search results

nope not either. I even deleted and recreated the account again. I added a sql account and a windows account and none of them work.

hi, its me again, still my problem has not been resolved... my sql server 2000 sp is mdac version 2.80.1022 and the user's desktop is version mdac 2.8 sp1 on windows XPS2. she is a member of the user's group with her windows login domain\user , i added her to the database wiht db_reader and...

thank you so much, i will do that, oh and to answer your question corrently this users are part of the domain/users group (default) in active directory

thanks for replying, to answer your questions: Q. Are there network groups in the DB where the user may already be a member of? Are there any DENY permissions set for them. A. do you mean in the access level? as of now they just belong to the everyone's group , i went to access, right click ...

the users are part of the users group in sql server and i added them in the sql server database with db read rights and db write rights.

:confused: I'm running an Access 2000 Database on Windows 2000. The Access Database links to SQL Server 2000 tables. The error occurs when the users login with their windows login (my sql server is mixed authentication) and open the database to open the tables or forms. The connection will...

hi guys, i was wondering if you can help me, i have a form in access the code is kind of big but i am only having a problem when adding a new record so here is that part . the problem is that when someone enters an account code that needs to be added then it refreshes the form, and the fields...

have you created a table to use as a source for the search query?

hi guys, I have two tables in my form one used as a source (contracts ) and then the other one used for destination (Destination). basically my two tables have the same columns: contract id, contract type and contract name. what i need to figure out is that in my data entry form i have a...

yes somewhat

can you please explain how to do that?

hello can anyone please help me with this form? I have a form in which has one drop down combo box and one data entry text box. The combo drop down box comes from a query of all active contracts from my contracts table. the second box has a unit ID number which the user enters. All...

thanks!!! now is there a way to make it if i chose item 1 in listbox1 that it does not come out in the listbox2 and 3?

this is what i have inthe list2 update but it does not work Dim int1 As Integer, int2 As Integer, int3 As Integer int1 = List1.Value int2 = List2.Value int3 = List3.Value If int2 = int1 Then MsgBox "Secord choice cannot equal First choice" Else End If End Sub

hi guys, i was wondering if you can help me. I have a data entry form in which the user has three listboxes from an existing table (only one table for the three listboxes). however if the user selects the same item from listbox1 in listbox2 or listbox3, i want him to get an error message and...

I have a question I hope someone can help me I have 5 parameter query that gets its value from 5 combo boxes from a form The following function is in the criteria grid for one of the fields: Like NZ([forms]![searchform]![combo69],"*") when I enter data for a combo box for one of the...

:o hi guys, i need your help, i have a form call "test" wiht a query called "invoice" (this query is linked from access to sql) in which i have to export the results into an excel worksheet, i have a vba code from the cmd button to perform this but i keep gettting an error message: runtime error...