Search results for query: *

Hi - I have a column with a series of values and empty cells in between. When I find a cell with value and empty cells following, I want to copy that value into the empty cells. I need to do this for the entire column. What is the easiest way to do this without have to manually autofill or...

Hi - I have an Access 2002 database used to track changes. I have a form to add a record to that table. That form updates the data using an ADO connection. Currently, that table is structure with the change id as the primary key. The number is basically a number that is incremented, i.e. it...

Hi- I have posted this under Microsoft Access Modules(VBA Coding) forum, but I'm not sure if that was the correct forum as I am asking more of a best practice/theory type question. I have a form that the user will enter data. Upon clicking the save button, the data entered onto the form needs...

Hi - I have a form that the user will enter data. Upon clicking the save button, the data entered onto the form needs to update 2 tables. The relationship between the 2 tables is a 1 to many. Therefore, the data needs to be stored into the main table first. Then using that primary key, the...

Hi - I am using a user defined function to populate a list box by calling the function in the RowSourceType for that listbox. The function is using a 2 dimensional array to store the values. Everything seems to be working except that the list box is populating with only one of the dimensions...

I am trying to import an Excel spreadsheet and do not want to use docmd.transferSpreadsheet as I need to do some additional manipulation, etc. I have created an ADODB connection to the Excel spreadsheet, but now I am not sure what is the best way to update my table with this data. Any...

Hi - I have an excel file that linked to several external data sources. In the code, i have a "refreshAll" command. After the sheets refresh, the pivot table is refreshed, and then the sheets are copied/saved to a new file. Everything seems to work, however, it looks like it is moving through...

Is it possible using vba code to automatically post a file to an Outlook public folder? I am trying to do some research on this and have not been able to find any information. I know this is a very general question, but I'm hoping someone can at least point me in the right direction. Thank...

I have a report that brings in This Year's Revenue and Last Year's Revenue and then does a comparison between the 2. The report is laid-out as a crosstab. In the comparison section, I am also calculating a YTD difference, which is bascically a running sum of the difference. The final output...

I have a report that pulls that has a condition for one year. I then filter the report to only display the current week. I have a YTD calculation for revenue, which uses the following formula - nofilter(sum(revenue)). This returns the current YTD revenue as there is only revenue data up...

In the database that I'm building, I need to import an Excel file and append that data into an existing data. Rather than having a set location where the file is stored, is it possible to have a dialog that looks similar to the Windows open file dialog box, where the user can specify the file...

This is the first time that I've used the Data Reports in VB. I have an application that connects to a Access 2000 database. I've create reports in VB using the data report. Is there a way to dynamically connect to the database? For instance, when I go from my laptop to my desktop, I have to...

I have a function with optional variable parameter that queries the database, stores the results in an array, and then populates the combo box. This function is uses for different combo boxes and list boxes (that's why the variables are optional). The business class stores the data in the array...

I am creating an inventory application with various views, i.e. search, product page, etc. Instead of creating different forms, they would like to see all of the pieces on one form. Would I use multipages to do this? I've never used multipages before, does anyone have any information about...

I have an Access form that sends data to an Excel spreadsheet with a pivot table. I've written code to update the pivot table based on the the data that updated. The code to update the pivot table is in the pivot table activate event. Here's the problem I'm having, I can't get the table to...