Search results for query: *

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...

Thanks very much!

I am currently updating my db via a form using the following code: Forms!FMSUpdate!Message.Value = "Here it is". What is the syntax to update the table directly instead of going through the form. Thanks

I use a screen scraping program to update Access and am currently updating my table via the form with the following code: CIS = Forms!CISUpdate!CIS#.Value. What is correct syntax for updating the table directly? Thanks

Perfect...thanks so much!

I am having problems using the Date function. At times it displays the previous date. I have tried using the Now function, but I do not need the time that it includes. The Now function will display the correct date while the Date function displays the previous day. My system date appears to be...