Search results

  1. B

    Question MS Access 2013 Data Link in Excel 2013

    Good morning, I am having an issue with two workbooks that are linked to a MS access database. In the MS Access tables I have hyperlinks set to individual .pdf files. In Access, the hyperlinks that are set work fine and the friendly name is shown properly; however, when I connect...
  2. B

    Updating Table Data

    Hi guys, I have the following code to call Data from a table and insert it into a form. Private Sub cmbSONumber_AfterUpdate() Dim DB As Database Dim rs As Recordset Dim STR As String Set DB = CurrentDb STR = "SELECT * FROM [tblShippingLog] WHERE [ISF V3 SO] = '" & Me.cmbSONumber &...
  3. B

    Updating an unbound text box

    Hey all, I have a problem with my database. I am trying to update an unbound text box with a query field after the query updates. I am having no luck setting the control source in the text box, as I just get the #name? error. I have the update function running, and I have the data I...
  4. B

    Filering records based on two date fields

    Good afternoon, I am trying to build SQL code that will filter records on a table based on the information chosen on two form control date fields, and only after the second date is chosen. Do you know how I would go about that? I would like the table/query to be able to be required...
  5. B

    Insert Into Statement problem

    Good afternoon all, I am having a problem with my insert into statements. I have different types of form controls, combo boxes, text fields, and date fields pulling different kinds of data, names, numbers, dates, etc. and putting them my table, I keep getting syntax errors, and I have no...
Back
Top Bottom