Search results

I have a problem with a subform that is used on two separate tabs. Subform names are: Tab2EstimatedActualDelta and Tab1EstimatedActualDelta The forms show data in Table Format I've developed the code that changes the recordsource depending on the tab selected. It is: Private Sub...

Posted my question too soon without enough research. For those interested, here is an extract of my solution Dim xlApp As Excel.Application Dim xlWrkBk As Excel.Workbook Dim xlsht As Excel.Worksheet Dim PONum As String Set xlApp = GetObject(, "Excel.Application") Set xlWrkBk =...

I receive an excel file about once a month where I need to extract only portions of the data and place in existing records of a table. I have no desire or need to keep the file so would like to open the file from Outlook and then retrieve the data from within access without having to save the...

Unfortunately, it did not. I thought of a work around. I'm going to place a subform in for the data that needs to be editable. Thanks for the suggestion though:) TC

I have two forms First form is built from a query built of 5 tables to get data needed Form 1 uses an unbounded combo box to traverse the records in the query I have a second form that is opened up by a button click. It calls one of the tables used in the query so that the user can edit the...

Thanks Paul Not sure why this happened, but I closed the form, reopened the form and the correct data displays as I traverse the record set. Thanks TC

I have a form that pulls all the data from a query. After the form was complete, my customer had a good idea that caused me to add two more fields from a different table. Using the query builder, tables added to the query and the correct fields added to the query. I can see the data when I...

JDraw - thanks - boy, do I feel stupid on the number of hours I stared at this code. Amazing how it works when you do it write Spike - here is the complete code Sub ClosePO_Click() Dim db As DAO.Database Dim mvalue As String Set db = CurrentDb mvalue = Me.Combo73 strSql = "UPDATE...

SpikePL Thanks. I added the brackets around the Print table and still received the same error in the SQL statement. I had copied the wrong debug.print is why they were the same, but since Print is a reserve word, I thought I would put them back in. I will have to go through my code and change...

I have a form that has a button that calls the following code: Sub ClosePO_Click() Dim db As DAO.Database Dim mvalue As String, strSql as string Set db = CurrentDb mvalue = Me.Combo73 'combo box on OpenPO Form strSql = "UPDATE Print SET OpenPO = NO where [GPO Invoice Number] = '" & mvalue &...

Hi Y'all from Texas. I am an intermediate - programmer whose boss has given me a project in Access. Besides working, my passions are my family, woodworking and motorcycles (and not necessarily in that order:)) TC