Recent content by BrandonM30

Thank you very much for this!

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

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

I am running a macro that will update all my main queries and then take the data from the individual queries and input them into different text boxes on my form. I can see the query data, and the update function runs fine, I just don't know how I tell MS Access 2002-2003 to take the query...

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

Thank you very much! This helped out a ton!

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

I have done it line by line, and it always stops at the second form control

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