Search results

Bob Thank you for the check box option also... If you have a chance can you also look at the following thread, it deals with this database also: http://www.access-programmers.co.uk/forums/showthread.php?t=120541 Thanks R~

Bob.. Doh.. Thanks R~

Bob.. Thank you very much.. I am now getting a new error..... when I entered the code: DoCmd.RunCommand accmdsaver Here is the error: the runcommand action was canceled R~

Bob.. Thank you very much... I got rid of the -1 but where can I put it so that the checkbox is always checked for a new person showing that it is active? R~

Here you go. R~

Keith.. Yes I can manually check the box and it will work. In fact if I don't check the box the new addition will not show in the subform because I only want to see active incidents in the subform. What I wanted to do is have the new entry be active no matter what until the incident is done...

Ok I tried both methods but I am getting the following error message: Run-time error - 2147352567 (80020009) You can't assign a value to this object I also have the following code when the form loads: Private Sub Form_Load() [Forms]![frmApplicantFullDetails].Requery End Sub and the...

Hi all.. I have two forms (one subform on the main form) and a detail form. form number 1 is the main form (subform lists details based on a query) form number 2 is the detail of the items in form #1 When I double click on a textbox SS# it opens up the details of that item in form number...

Hi all.. I have two forms. form number 1 is the main form (subform lists details based on a query) form number 2 is the detail of the items in form #1 When I double click on a textbox it opens up the details of that item in form number 2. In the detail form I have a check box that...

RuralGuy Just what I was looking for... thank you very much R~

I changed the InvestigatorID to ApplicantID and it seems to be working for now. I am going to put some more data in and see. The error I was getting was this: Error found need to debug Form is shutting down R~

Hello.. I have the following code that I have been trying to get to work: Private Sub txtSocNumber_DblClick(Cancel As Integer) On Error GoTo Err_txtSocNumber_DblClick Dim stDocName As String Dim stLinkCriteria As String stDocName = "FrmApplicantFullDetails" If...

Hi all.. Here is what I am trying to do: I have three tables: tblMain entrynumber (pk) entrydate empnumber driverslicnumber Lname Fname Minitial Address streetname City State Zipcode EmployeeStatus Note etc tblrelated sprId (pk) entrynumber Lname Fname Minitial DriversLicNumber Current...

dsigner.. I reworked the datastructure.. I combined the tblspouse and tblchild into one table... So I have three tables instead of four. tblMain entrynumber (pk) entrydate empnumber driverslicnumber Lname Fname Minitial Address streetname City State Zipcode EmployeeStatus Note etc...

Hello.. Ok I tried both ways... Keith, when I put your script in I get an #Error? message.. Husky, I get an #name? error.... What Ended up doing was setting up another txt box and having it look at what was in the dropdown box.. like what rich said.. this time I was able to get it to work...

Keith.. Yes that is correct.. the form is open when I hit the report open.... I am trying out the different ways and I will post back.. Thanks R~

Rich.. #Name? is showing up in the text box also... R~

Rich.. I did what you suggested.... I created a text box with the code you suggested... I get the same error on the form also.. Keith.. Yes it is a drop down.. that is pulling from a table..... the table is tblLUTestType R~

That is correct.. (1) being the second column.. idtype (0) type (1) this is the error: #Name? R~

Rich/// thanks for the quick reply.. .still getting the error thou..... R~