I have a database developed in MS Access 2000 that allows people to enter training histories for staff. The staff information is stored in tblStaff, and the training histories are stored in tblTraining. The main form (frmDataEntry) contains the staff contact information and a continuous subform displaying the selected staff's training history.
The desire was for the ability to allow the data entry person to search the database by...
kickergirl
Last Activity: Oct 16 '08, 01:45 PM
Joined: May 2 '07
Location:
-
Runtime error 3075
I recently created a database in Access 2000 that has been distributed to multiple people using various versions of Access. Each person is using it as a standalone database.
The database has multiple forms that collect information on individual people. In fact there are 5 forms per person. The first and second form write data to the same table. The VBA code below is what happens when the user continues to the second form to enter... -
Editing incorrectly entered records on a form
I have a database created in Access 2000 that has one form (DataEntryfrm) with one subform (Trainingsubfrm ). The main form is linked tblParticipant (no duplicates allowed) and the subform is linked to tblTraining (duplicates allowed). The primary key is SSN. Referential integrity has been placed on the tables with cascading updates and deletions.
The premise is to collect the number of trainings attended by an individual. A search... -
Unwanted copy of Access database created upon close
I created a database in MS Access 2000 that is being used by another person using Access 2003. Everytime they open the database and close it, a "db1" copy of the database is created. This does not happen when I open the database on my network. Has anyone ever heard of this phenomenon and/or know of a solution?
Thanks! -
Yes I obviously do... However, I have tried various placements of the If me.recordset.re cordcount = 0 then statement and nothing works -
Exactly how would I incorporate this into my code so that when a user enters the very first record, it will add a new record using the SSN entered?Leave a comment:
-
Runtime error 2137: You can't use find or replace now.
I have created a form to allow users to add a new record and/or search for an existing record based on SSN. If the SSN the user enters into SrchID_text is found, the form is populated and a message appears telling the user that the record exists and they can edit existing information or add new information. If the SSN is not found, a new record is supposed to be created and a message appears telling the user that no match was found and they can... -
I am not actually trying to limit the number of data rows. I am trying to ensure that the sum of disbursements does not equal more than the amount allotted.Leave a comment:
-
Data Entry Validation
I am trying to ensure that the user is notified if they enter more disbursments than was allotted for a specific account. The twist is that each account will have an initial allotment and a renewal allotment. The disbursements are captured in a subform.
I entered the following code in the AfterUpdate event of the control capturing the individual disbursements, but I get Runtime error 2428 - You entered an invalid argument in a... -
Validate text boxes based on subform entries
I'm not sure my title actually describes my problem, but here it goes. I am creating a form to track account information for participants. Basically, a single participant can be offered up to $3,000 for the first year and up to an additional $3,000 for the second year.
The main form tracks the dates the offers were made. And I have incorporated a subform to track the disbursements, whether for the first year allotment or second... -
Make a text box entry mandatory dependant on Option Group Selection
I am creating a rather unwieldy database (MS Access 2000) in which the client wants to provide the users with an "Other" option for every option group. The client also wishes the user to explain what "Other" is. How do I make sure that the client enters the explanation?
I have tried the following in AfterUpdate, On LostFocus, and On Exit. But nothing works. I have never tried to code events on option groups... -
Never mind, it worked! I typed the OG name incorrectly. Thank you!Leave a comment:
-
But what do you do if you can't make the OG the first control on the form. In this instance, it must be 5th.Leave a comment:
-
Mandatory Option Group
Is there a way to make an option group a mandatory control on a form? In other words, the user must select yes or no before going to the next control. -
Thanks!!!! It works!Leave a comment:
-
Table Name=tblPartici pant
SSN; String
FName; String,
LName; String
Race; String
Sex; String
Ethnicity; String
Table Name=tblTrain
SSN; String
Start; Date/Time
End; Date/Time
Cluster; String
FundYr; String
...Code:Private Sub SSN_AfterUpdate() Dim strCriteria As String Dim rst As DAO.Recordset
Leave a comment:
-
Sorry guys, I spoke to soon. I just checked my tables and the table containing the demographic information is now showing duplicates. How do I prevent this?Leave a comment:
-
Thanks to both of you! For a newbie like me, the article referred to by Scott was more helpful. However, I have printed the other one as well since I am sure I will be able to use it later.Leave a comment:
-
Auto populate form
I have created a form that requests basic demographic information on a training participant as well as information on all the training the participant has taken part in. The demographic information is collected in one table and the training information is written to a separate table using a subform. The two tables have a one to many relationship. The SSN is the common identifier between the two.
I have already incorporated a search... -
Thank you!...Leave a comment:
No activity results to display
Leave a comment: