Recent content by paulette33

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!