I had the same problem so what I did was this:
in the subform I updated to Requery the OnFocus property of the control I wanted to be refreshed (so that instead of showing all records, it would show only the records related to the data entered in the main form):
Private Sub MeetingSubID_Go tFocus()
MeetingSubID.Re query
End Sub
So if in the main form I entered a new Meeting when I clicked the...
Anca Floria
Last Activity: Mar 5 '08, 11:36 AM
Joined: Jan 11 '07
Location: Vienna
-
Thanks a million! Have a nice week!Leave a comment:
-
Thank you for the Groups idea! Still, what I do not know is this: if there are 2 or more users suing at the same time the database from different computers, can they see what the others are changing in the database? Can I display a message saying "sorry, the object you are trying to edit is currently in use by a different user"? Thank you so much!Leave a comment:
-
One more question:
I found and created access levels in Access Security - thanks again! But can I see anywhere if something was modified by one of the users? Also, if there can be maximum 255 users working on the data at the same time, can they see what the others are updating? Thanks!Leave a comment:
-
Thank you so much!
I really appreciate your thorough response! Have a nice weekend!
AncaLeave a comment:
-
How advanced is Access?
Dear all,
I have the following questions, and I need you opinion on them, so that I understand if Access is good enough for my needs:
1. Can I create using Access and Visual Basic different levels of access to my database? For example, when it opens, the Start Form should have an input field for username and password, and according to the info given, then allow access to different levels (egg. one user can only view... -
It works perfect! Thanks a million! I O U :DLeave a comment:
-
Thank you so much for your help! I really appreciate it! I will try to see what I get.
Cheers :)Leave a comment:
-
Finding similar entries&duplicates
Hi there!
I am trying to find out what is wrong with the following code:
Its purpose is to find similar...Code:SELECT Investor.Company, Investor.ID, Investor.Country FROM Investor WHERE ((( Investor.Company) In ( SELECT [Company] FROM [Investor] As Tmp GROUP BY Left([Company],3) HAVING Count(*)>1 And Left([Company],3) =Left([Investor].[Company],3) ))); -
Thank you so, so much!!! I never used the Unmatched Query wizzard before... I owe you big time! Thanks! :DLeave a comment:
-
Select from a Table the entries that are different from another table
Dear all,
how can I select from a table only those entries that do not exist in a different table?
I have a database of clients and just received an excel sheet with new clients. so i created a table for the New Clients and wanted to check which of them do not already exist in the Old Clients table. How should I do that - I tried many times with all SQL commands I knew. Thank you!
Anca
No activity results to display
Leave a comment: