Search results for query: *

Hi, I am trying to save outlook messages to a network drive. The messages are in a shared mailbox folder, not my main outlook account. I have found a script and I have set up a rule for it to run from. It runs fine but only on a selected message or a group. I would like it to run when the new...

Hi, I have a module that runs when a user clicks a button on a form. They have to choose a begin date and end date to run a report. Lately they have been getting an error "The command or action 'OutputTo' isn't available now. When I run the report it works for me. They run the DB off of...

Two questions; I have a stacked bar chart - all the bars add up to 1. The chart shows the percentage of a task completed in pass 1, pass 2 and the remaining percentage left to complete the task. I would like to add a marker (a diamond) at a goal percentage for each bar. I have done something...

I have a named range. The cell in this range holds the cell reference of the last open cell in a list of data on another sheet. When I try to call that reference from the named range in my code, I get an error. This works; Sheets("Summary").Select Range("B3:O3").Select Selection.Copy...

I've got a database the people connect to through Citrix. They've been having issues connecting more than one user at a time. I've done some reading and it suggested splitting the database will help with this issue. I've tried to do that but when the users try to access the tables in the DB...

I have a workbook where at the end of each month it is saved as the next month. For example this month I have 01-Jan SGA.xls next month I will save this as 02-Feb SGA.xls. I made this macro that will take some of the sheets, copy them into a new workbook, name the new workbook and then copy...

I have this formula and it works well; =SUMPRODUCT(-('Sheet1'!$D$5:$O$5<=$A$7),'Sheet1'!D9:O9)*-1 I have a cell A3 with the sheet name in it, when I try to use INDIRECT in this formula, I keep getting a #ref#. I know it's something simple like a missing ) or '. Can anyone help correct this...

Hi, I have two laptops, a dell d610 and a dell d630. both running xp pro. The dell d610 won't boot, blinking cursor in the upper left. Pulled that drive put it into an external drive case and tried to read it on my desktop. Can't read anything off of it and it's telling me the drive is not...

Hi, I am trying to create a dynamic range to use for sparkline charts that I have in another workbook. My data for each chart is in a row and the new data will be added to the last column each month. Data arranged like this G H I J K L M N O P Q 2 Data 2 3 4 5 7 2 1 3 Data2 2 3 4 5...

I am trying to create a fixed width text file from an excel worksheet. I have found some code to do this and I have modified it (I thought) to work for my purpose. I have 54 columns of data that I want to put into the file. I have found the following code, when I run it it gives me a run time...

I made a database a while ago that I haven't used in a while. Since then, my computer crashed and I had to get re-imaged. I think that the error is related to the references I have chosen no longer being selected on my re-imaged pc. The problem is, I am not sure which ones I need to make the...

Hi, I have an Excel workbook that imports data from an Access query. This works fine on my PC. However when someone else goes to refresh the data, it will not work on their PC due to the drive mapped names are different. I would like to call the server name instead of the drive letter. I...

I have cells in one sheet that when using this formula, looks up values in another sheet called alldata. alldata is linked to an access database. I am using this formula =IF(ISERROR(VLOOKUP((CONCATENATE($A$3,$A11,D$6)),alldata!$A$3 :$D$5001,4,FALSE)),0,VLOOKUP((CONCATENATE($A$3,$A11,D$6))...

I'm using Excel to build a process flow. I've created process boxes where I have grouped the process box along with several text boxes that pull data(linked cells) from another sheet. This way, the data moves with the box when/if I need to move it. I would like to format the data in the...

I am trying to create a listing of tables to use in a list box. I found this code and I am trying to use it to create the value list for the listbox. Private Sub Form_Load() Dim objAO As AccessObject Dim objCP As Object Dim strValues As String Set opjCP = Application.CurrentProject For Each...

I've tried to import an excel file into my access DB. I used the transfer spreadsheet method but the user needs to be able to select the file that they want to import. I tried this; Dim fDialog As Office.FileDialog Set fDialog = Application.FileDialog(msoFileDialogFilePicker) With fDialog...

I have a form that has a list box. I have query that populates the items in the list box. I have made a combo box on another form where the user picks the frequency that they want to view. They then click the Open form button and it will pull up the form with the list box filtered with their...

I have a form that has a list box and a subform linked to the selection in the listbox. I currently have it so that when the user clicks their choice on the listbox, the subform record come up. They need to click a checkbox. This checkbox populates a field with the username (Environ). I am...

I am having the hardest time with what should be very simple. I created a new database, there is a table with a field called AddedbyUser. I want to populate the field from a form with the network ID. I have done this before on all of my other databases and it works fine. On the BeforeUpdate...

I have a database where I created a button that runs a bunch of sendobjects of all the important tables to a back-up database. The problem with this is that it requires the users to remember to push the button. I could have it run on database close but with 8+ users this would be time...