Search results

Hi All I have a "Main" form that has multiple pages to it. Three of those pages have the same functionality in managing our contracts. All three forms have main subform that lists all the jobs under that contract and a second subform that lists the specific data for the job that is selected...

I have a procedure that passes a subform and creates a recordset using the subform's recordset. I then use copyfromrecordset to write the recordset to an excel file, but it does not work; however it does not cause an error and the procedure continues. I put a debug.print to see if I can access...

I have a requirement to display in a subform data from remote tables in an access database (900 miles away). I do not want to link the tables because one table is quite large, the time to connect lengthens time my system is ready, I only need a subset of data (a month at a time) and I only...

:banghead: As the title states, I have hit the wall. I have two class variables (both arrays) among about 10 other class variables, that are not returning any values but "" for the string or #12:00:00AM" for a date. Here are my class variables: 'UPSData Class Module Private p_LetterArray() As...

My organization contracts out to a 3rd party for a service. They send a list of invoices during the month, listing their job number, our Purchase Order Number, a description, the cost and date completed. I have a file that contains 5 excel worksheets. My routine determines the names of the...

Not sure whether to post to this forum or excel, so I posted to both. Background We receive from our vendor data in an excel file that lists PO number, Date and value. I have outlook (via a rule) save the file to a network drive. In access, I have a button that is to start a process that opens...

I have a complex database app that has a form called from the main form. It requires two inputs: BeginningDate and EndingDate and I use a calendar picker for date selection. Using data assigned to a variable, I build the SQL query in VBA. The result is: SELECT [1733_All Print...

I have a report that is created with a command button. Data printed is dependent on what record is being displayed. The data can be grouped into 5 different classes (call them A, B, C, D & E). The data is aggregated into a query from different tables using a primary key. Besides txt fields tied...

There has already been a post on this and I get the same results when I run the splitter, but when I go into the back end database, only the first table was copied over, the front end database does not point to that table, and the table is still there along with the others (15)

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

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

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

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

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