Search results

I figured it out I tried this If DCount("*", "tblAccount", "[accSchoolName]='" & Replace(Me.accSchoolName, "'", "''") & "' And [accSystemType]='" & Me.cboSystemType & "'") > 0 Then It accepted text with apostrophes

The code compiles but I get a run time error If DCount("*", "tblAccount", "[accSchoolName]='" & Me.accSchoolName & "' And [accSystemType]='" & Replace(Nz(Me.cboSystemType, ""), Chr(39), Chr(39) & Chr(39)) & "'") > 0 Then

I get an error in my app when a user enters an apostrophe in text box during data entry, I use an before update event to check for duplicates and thats when the error is triggered. Here is the code for the before update event If DCount("*", "tblAccount", "[accSchoolName]='" &...

That did it, lesson learned I need to pay closer attention to quotation marks with multiple criteria in a Dcount Statment. :D Thank for your help again! I now have a better understanding of Dcount, DlookUp and DMax. Thanks again!!

It seems to give me an expect expression error when I take the double quotations out If DCount("*", "tblAccount", "[accSchoolName]='" & Me.accSchoolName & "'" And [accSystemType]='" & Me.cboSystemType & "'") > 0 Then

Still getting type miss match. The accSystemType is a text, I just used a combo box on the form because there are only 3 systems type. When I load the form the combo box rowsource type is value list and the rowsourse has the 3 system names.

I keep getting a type mismatch error I have a combo box for sytem type but its record source is accSystemType Heres what I tried, If DCount("*", "tblAccount", "[accSchoolName]='" & Me.accSchoolName & "'" And "[accSystemType] ='" & Me.cboSystemType & "'") > 0 The setup is the user selects...

I know this is off topic but I am trying to figure out if there a way to check for duplicate school names but allow up to 3 instances of a school name based off my field systemType Example School A has system 1 School B also has system 2 But can you prevent a use from enter the same school...

Sounds fun! Thanks again for all your help, I have learned alot from the code samples you provided! I am still learning and hope to one day be as good as you!

You are awesome, it works!! I have a question just for fun, could you subtract the third entry in the system configuration from the first entry. I was just curious if that was possible and display that result in a different text box. If not no big deal just curious. Thank you again for all your...

How can I go back and add a new system to an account and still calculate the spacing from the previous record? When I add a new system to the account, the spacing text box is blank is blank. I used this on Current event in the subform Me.txtSpacing.ControlSource =...

I'll give that a try, Thanks!

I have a user that is unable to edit records, He can click in the fields but he could not delete or enter data in the fields. He has the ability to edit records but its fields are locked. I created a split database and created a secure front which I distributed it to multiple uses. The other...

I am updating an existing database and I have a parent/child form and I want to filter the subform for the current parent form record? The two forms are linked together by woWorkOrderID/deWorkOrderID.

Thanks a Million!! You are awesome! I really appreciate your help! It works like a champ!

Yeah, the TempestCoordination form is the data entry, SearchSchools form allows the user enter a school name and retrieves the data. From that form the user can add anotehr system to the subform. I pasted the code in the on open event and I get an compile error Expected: end of statement.

The txtSpacing is located on the frmSubSystem

ok, you might have relink the tables, the data base is a split design. I cleaned the junk data, but you can enter data for troubleshooting. The start form is a login. Use the username User, and password User1 . This will help as some form has on load events that need to check security level.

I tried the code but still get a #Name? in txtSpacing. I suppose I need to store the hop number so the current record can subtract from the last record. Is it possible to do a dlookup if the value in a text box is unbound?

I changed the Hop1 and hop spacing to text boxes txtHop and txtSpacing I am getting #Name? text box instead of the calculated value this is in the control source for txtSpacing =Abs([Me].[txtHop]-DLookUp("[Me].[txtHop]","tblSystemConfiguration","[sysAccountID]=" &...