Recent content by Styrker

I have a db that is being used as an MDE file. I have made some changes to the code on the original mdb file. how do I update the mde and not effect the data?

So close yet so far away: Here is the strsql line Strsql = “Select colornumber from color where colornumber ='" & me.text14.value & "'" I am still getting the "expected end of statement" compile error at Strsql = “Select colornumber Thanks again for all of your help...

Here is what I have so far the only problem is the strsql line, explained below: Private Sub Text14_AfterUpdate() Dim strsql As String Dim rs As Recordset Dim rsknt As Integer Strsql = “Select colornumber from color where colornumber = ' "& me.text14.value"'" Set db = CurrentDb...

Well here is the code Dim strsql As String Dim rs As DAO.Recordset Dim db As DAO.database Dim rsknt As Integer Strsql = “Select colornumber from color where colornumber = " "& me.text14.value" Set db = CurrentDb Set rs = db.openrecordset(strsql, dbopensnapshot) rsknt =...

Ok fixed the previous error but am now erceiving an Invalid Argument on the following line Set rs = CurrentDb.openrecordset(strsql, dbopensnapshot) Any help is appreciated. Blaine

Well I tried your code and received a compile error on the Strsql = “Select colornumber from color where colornumber = “ & me.text14.value Line. The compile error was due to syntax.

Hey folks, Here is what I am trying to do. I have two tables one that stores color numbers (color) and one that stores jobs (jobs). I have 5 text boxes in the Jobs form that I need to reconcile against the color table. If the color number does not exist then I need to open the color form...

OK if you all are confused by my subject read on. Because I am really confused. Here is what I am trying to do: I have a text box (text14)in a form (jobs). I need to verify the data input in text14 against data in a specific row (colornumber) in table (color). If text14 does not match...

OK folks here is my problem. I have a Form and subform. The subform pulls data from one table and uses the info from a combo box (which pulls data from another table) on the main form to sort the data. The problem is that this form tries to rewrite data back to both tables and I get a key...