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

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

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

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

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

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

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

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

I need to FTP my access database to a webserver several times a day. My problem is that for the upload to work I need everyone to close down the database.It never fails that someone is away from their desk and the ftp will fail because they have left the db up. Is there a way to set a macro etc...