Search results for query: *

Thank you both for your help!!!!

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

The purpose of the record # is so the user has the ability to search for that particular entry to either view or update the record. All other IDs are hidden from the user. The form only displays one record at a time. They do not have an ability to scroll through all of the records. I am...

Thanks MichaelRed & Willir! Just another question, I've read that FAQ, but I'm just wondering if that would work if I am generating that number up front, i.e. when a new form loads I go and get the next id. The reason I was grabbing the number in the beginning is to display the Record # on the...

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

This is not as simple as what you are describing, however I have used this function that I got from a co-worker. You can basically call the "networkusername" function and either store the results into a variable or populate the field, etc. Hope this helps Declare Function WNetGetUser& Lib...

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

Thank you PHV!!!!! It worked! Paulette33

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

Thank you for your help!

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

Thank you for your help! It worked!!

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

I wanted to post an excel file to the Outlook public folders. Thanks!

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

Thank you for your help! I tried what you suggested and it worked!!!! THANKS!! :-)

I'll try to explain this in better detail. The report runs for the current fiscal week. Since I have to do a YTD calculation on the sales, I set my condition to pull in all of 2003 and then filter to display data for the current reporting week. This allows me to create a formula to calculate...

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