Search results

I am developing an Access 2007 front end with a SQL Server 2008 r2 back end. I have the database engineered and close to completion. This is for a law firm in a major metro area. One of the business rules for the development is that no information is ever deleted. File stream is also being...

A generous thank you to MLUCKHAM and pbaldy. Your help is so appreciated.

Thank you that did the trick I moved up the FindFirst line. Thank you both for the help. Can I bother you with one more question? I wanted to write the exact reverse of this so that if you click the button on Edit2_FRM it finds the corresponding record in Edit1_FRM. So I copied the code that...

Dim rs As Object Dim stBookmark As String stBookmark = Me.PIN Set rs = Forms!Edit_Frame_FRM!Edit2_FRM.Form.RecordsetClone Forms!Edit_Frame_FRM!Edit2_FRM.Form.Bookmark = rs.Bookmark Now the above line errors out with Error 3021 No Current Record. rs.FindFirst "PIN = '" & stBookmark &...

Dim rs As Object Dim stBookmark As String stBookmark = Me.PIN Set rs = Forms!Edit_Frame_FRM!Edit2_FRM.Form.RecordsetClone Forms!Edit_Frame_FRM!Edit2_FRM.Form.Bookmark = rs.Bookmark rs.FindFirst "PIN = '" & stBookmark & "'" The above code eliminated the Data Type mismatch error. The...

Dim rs As Object Dim stBookmark As String stBookmark = Me.PIN Set rs = Forms!Edit_Frame_FRM!Edit2_FRM.Form.RecordsetClone Forms!Edit_Frame_FRM!Edit2_FRM.Form.Bookmark = rs.Bookmark rs.FindFirst "PIN = " & stBookmark GET DATA TYPE MISMATCH. "Run Time Error 3464 Data Type mismatch...

Thanks, I still have a problem. The PIN field is a string not a number. The variable picks up the PIN good. But I think something is wrong with my reference to the other form although I can't find anything wrong with it. Dim rs As Object Dim stBookmark As String 'set a variable to the...

Access 2007, VBA, find record on form. The database tracks PINs (Property Index Numbers) and related data about the property. I have a Modal form "Edit_Frame_FRM". It acts as a frame containing two sub forms, "Edit1_Frm" and "Edit2_Frm". I have a button in each row of the "Edit1_Frm. You...

It was the comma at the end of the values. It just worked fine. Thanks for the help. Phred

Is this what you mean: stSQL = "UPDATE Tbl_ScheduledMeal6_Override" _ & " SET SiteName = '" & stSiteName & "', DefaultCount = " & intCount & ", SiteID = " & intSiteID & ", CustID = " & intCustID & ", CustName = '" & stCustName & "'," _ & " WHERE CategoryName = '" & stCatNM & "';" There is...

Access 2007, not compiled, not split, Windows 64 bit Pro. Skill level moderate. One user stand alone, not networked. Having a problem with syntax on an update query. Debug.Print returns all the correct information. The watches on the variables all come up correct. I'm not sure what's wrong...