Recent content by jjones100

I have two tables, PendingOrders and SubformTbl. Here is the join: LEFT JOIN SubformTbl ON PendingOrders.PONumber = SubformTbl.PONumber. I would like for the orders in the PendingOrders table to be displayed just once for each of the SubformTbl records. PONumber, Custname, FMS# come from...

That did the trick. Thanks so much!

I have a form and 1 subform. Subform has a checkbox that when clicked, will trigger an email to be sent with several of the fields that are located in the subform table. The code is simply: Email = "J.R.J@yahoo.com" Copies = "SJ.R@yahoo.com" SiteName =...

Oh, Thank you so much!! That did the trick.

Having a problem with this code: Mydate = VBA.Date SQLUpdate = "UPDATE CustomerImports SET SentToBeKeyed =" & Mydate Looks simply, but after I run this code the database table has the value of 12/30/1988 and then when i actual click inside the cell in the table it shows 12:00:07 AM. I have...

Will do. Thanks!

Not ever record has every field populated. It depends on the ckt type. I am just debating having to open several tables for the screen scraping and having all of those joins.

I am wondering which design would be better for my new tables. In the past I have just had one table with ALOT of fields. I am creating a new db and am wondering if I should split the info into multiple tables. I have a ckt id field that all other fields relate to, such as customer address, ckt...

Got it! Thanks George Posted previous message before I saw your response.

Still getting same error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''345 test's',DueDate=''where RecNo like '127''. It seems the error comes from the word test's. The customer has type "345 test's" in the notes section and program is...

Notes are read in from the form: Notes = request.form("notes") I am using the following asp code to update my table: strSQL = "UPDATE Tasks SET " _ & "Notes='" & Notes & "'," _ & "where RecNo like '" & RecNo & "'". I get missing operator when someone enters text containing apostrophes in the...

Thanks to everyone. Missing the adovbs.inc statement. Problem resolved.

Thanks for suggestion. Connection shows to be open.

Thanks, but did not work. Same error message.

Can someone tell me what the problem is with this connection string: <% Set adoCon = Server.CreateObject("ADODB.Connection") adoCon.Open = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("Project.mdb") Set rs=Server.CreateObject("ADODB.RecordSet") rs.open...