Use Query by Form Technique (QBF)
Visit: http://support.microsoft.com/kb/304428
Zeeshan7
Last Activity: Mar 23 '10, 01:00 PM
Joined: Oct 16 '06
Location:
-
Basically I have built ms access front end in which tables are linked with sql server through dsn less connection. I have used ms access security feature user and group accounts. Default user has no permission. Tables are append/linked through a code when a user login. When user exits I used delete object macro to delete all linked tables. The problem is when a user login to all tables are linked but by default a user e.g. xyz gets full rights to...Leave a comment:
-
Hi, How do I remove Users permission through code?
How do I remove/ revoke Users permission to an object i.e. Table through code in ms access? Thanks for all your help. Regards -
I have used append query as an alternate.
ThanksLeave a comment:
-
Now it gives (Compile error: Syntax error)
Please advice. ThanksLeave a comment:
-
Need some more help to work around regarding error 3622 as stated above.
ThanksLeave a comment:
-
After Update Event Procedure not working after upsizing to sql server
After Update Event Procedure on a form is not working after upsizing database to SQL server. Anything to add in below code as it generate run time error 3622 "You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column."
Please help.. thanks
...Code:Private Sub Form_AfterUpdate() Dim db As Database Set db = CurrentDb -
its done. thanks a lot.Leave a comment:
-
I would request experts to kindly review my last post. I have attached a txt to clearly explain my requirment. Please accept my apology. RegardsLeave a comment:
-
I have attached screen shot (txt file) to explain my requirement clearly.
Thanks and regards...Last edited by Zeeshan7; Sep 15 '08, 12:10 AM. Reason: Screen shot to explaing requirement clearly...Leave a comment:
-
I am sorry. I will try to learn... thanks to all who answered my queries. please give me one more chance. I will wait for a reply of ADezii on this to conclude.
best regards.Leave a comment:
-
there are many employeeIDs. each is assigned multiple, similar or distinct billing Ids. In accounts table each billing ID has dollar field sorted in descending order. If you look at the first code posted at the top of this post, the distribution of accounts to the employees was on the basis of dollar only. Now I want the distribution to be based on billing Id. Appreciate your efforts in solving this problem. regards.Leave a comment:
-
I tried but it is not updating EmployeeID in accounts table. With reference to the code at the top, it produces the required result but without considering billing_ID. Can you look at it before writing code to produce the desired result? thanksLeave a comment:
-
I am trying but still stuck. Appreciate if you could kindly modify the code.
P.S: With reference to the code at the top of this post, it produces the required result without considering billing_ID.
Thanks for your support.Leave a comment:
-
The result of your code is same as previously posted by ADezii
Code Result:
3, 3, 3, 3 for billing_ID 5 and 4, 4, 4, 4 for billing_ID 7,
Requirement:
It should be like 1, 3, 1, 3 for billing_ID 5 and 2, 4, 2, 4 for billing_ID 7 (as per my specific example data) because I need equal distribution of Accounts/ records through all given EmpID exist in table Assign.
Please help. ThanksLeave a comment:
-
Please let me give you specific example so that the code should work as requested:
Table Assign:
EmpID : 1, 2, 3, 4
billing_ID: 5, 7, 5, 7
(EmpID, 1 and 3 related to billing_ID 5 and EmpID, 2 and 4 related to billing_ID 7)
Table Accounts:
total records: 8.
first 4 records related to: billing_ID 5
last 4 records related to: billing_ID 7
Now the...Leave a comment:
-
The code is now constantly running. Can you please re-check? ThanksLeave a comment:
-
Please let me further explain you that suppose we have 12 records in table Accounts, 6 records related to billing_ID 5 and remaining 6 related to billing_ID 10.
In table Assign, we have 4 records, 2 related to billing_ID 5 and other 2 related to billing_ID 10.
Now the code is supposed to update all EmployeeID from EmpID of table Assign considering billing_ID, but the case is different. It is only updating first 2 and...Leave a comment:
-
Thank you in advance for your time and consideration.Leave a comment:
-
It works fine if in table "Assign" there is only one billing_ID e.g. 5. But if I add billing_ID e.g. 10 in table "Assign", the code does not distribute ALL Emp_ID in the table "Accounts", and skip billing_ID 5 even....Leave a comment:
No activity results to display
Leave a comment: