Search results for query: *

Hi I have written the following vba in Excel 2000, to fill a ComboBox ListFillRange. ActiveSheet.Shapes("ComboBox1").ControlFormat.ListFillRange = "Control!$B$2:$B$" & ControlEndB I am getting the error message Can some enlighten me as to what I am doing wrong? Cheers Barney

Hi. Just had BOXI Enterprise Installed by the IT Department. I was previously using v6.5. When I click on the Export to Repository, or Import From Repository Button, nothing happens. The PC seems to think about it for a second, then does nothing. Is this something to do with the install, or...

Hi I have the following code which is supposed to open up every Excel file in a directory, but it only appears to open up every other file. Can anyone see what I have done wrong? Dim myFiles myFiles = Dir("\\bbuukvirfnp0001\scm\logistics\Costing data\Stock Values " & YearNo & "\Week...

Hi I have the following code that should be putting a command button into a command bar. Private Sub Workbook_Open() Set cbrGraphs = Application.CommandBars.Add cbrGraphs.Name = "Graph Buttons" cbrGraphs.Position = msoBarTop With cbrGraphsControls Set cbcCreateGraphs =...

Hi I am trying to send an email to multiple recipients, the number of recipients could vary each time the macro is run. I have created a loop to get the names, but Outlook doesn't seem to like the multiple names, can anyone help me out? Current Code Below For EmailLoop = 3 To...

I have a routine which sends an email from a form, the problem is that once the email has been sent the focus is still on Outlook, does anyone know how to make the Access DB the focus again? Thanks in Advance Barney

Hi I have the following code, which is supposed to find and navigate to a record on a form, from an entry made in a textbox in the form. The field searched could either be a number or text entry, so I have made the field a text field. I am using Access 97 if that makes any difference. Private...

Hi I have a table with 3 fields Registration, Date, Miles This shows a history of vehicle mileage at the date stated. So there are multiple entries for each vehicle, with a different date against each with a mileage at that date. What I need to do is write a query to produce one line per...

Hi The code below is looking for a matach from one sheet to another, works fine when there is a match, but when there is no match it gives me a Run Time Error 91. I understand this is because there is no match, but I thought the "On Error" line would sort that out. Have I done something...

Hi I am trying to establish if an entry on a form exists in an existing table. Then if it does not exist ask the user if they want to add it. I can write the code to add the record if required, but I am not sure how to do the validation. I was thinking of possibly using the dLookup function...

Hi I am trying to apply a filter to a form using VBA, I need to the filter to work off ComboBox values the user has selected, and then apply the filter to several fields depending on what the user requests. I have written the code below, which works fine for one parameter, but when I select 2...

Hi I am new to Access VBA and am struggling to get this to work. I have a form with a combobox on, I also have a search button. What I want is to be able to filter for the value in the combobox. I have the following code txtFilter = Form_Address.cmbOracleName.Value Me.Form.Filter =...