Search results for query: *

Hi, Have a string similar to below 15000;898983;363849;2738389 which I place into a listbox via additem. i want to place comma's in the string so that the numbers are easier to read in the lisbox i.e. 15,000;898,983;363,849;2,738,389 But when i do this it creates new lines after the comma...

Hi, Trying to find a way of creating a table and then filling it with values from an array. Have tried Docmd.runsql "select into tblName values " & ArrayName but this doesn't work Any ideas of 1/ How to fix it? 2/ To do it a simpler way? Thanks

Hi, Have the following code to open excel Dim objXLApp As Object Dim objXLBook As Object Set objXLApp = CreateObject("Excel.Application") objXLApp.Workbooks.Add Set objXLBook = objXLApp.ActiveWorkbook The code does not appear to work. However when I go and open Excel manually it opens to...

Hi am trying to populate a list box based on a criteria set by another 'multi'-select list box. This is the first time i have tried to do this and put together the following code, but it is telling me that i have an 'invalid use of null' (where i try to bing back ProdURC from rs) Can anybody...

Dim varItm As Variant Hi, Not had much experience of arrays, but am trying to capture the data selected in a multi-select list in a number of array variables. However the following piece of code is giving me a 'subscript out of range' error Any help much appreciated - Dan --CODE-- Dim i As...

Hi, Apologies if this is a simple one! I am using VB in asp to pull records from an Access database. Opening a recordset and then pulling them into an ASP. My problem is that the page is only showing the record up to where the first space is and then truncating it. I think it might be...

I have a load of invoices and credits by company in a report - i have created a group at both invpoice / credit level and at company level, yet when I try to sub total and total I only get the first transaction of the set - any ideas?? Thanks Dan

When I am using Dsums / Dcounts etc I sometimes get a #error in my textbox, sometimes it can be a format thing, but alot of the time it just corrects itself - any ideas what could be causing it?? as it is quite irritating TIA Dan

Any idea what piece of code I can use to rename an excel file on my desktop from inside Access, I have seen the simple "kill" command to delete stuff, but wondered if there was a similar one to rename stuff?? Dan

Easy One hopefullY!! I have a number of dsum functions on a form that a while to calculate, i want to display an hourglass whilst it finishes calculating, however I am not sure whihc events to use Any ideas?? Thanks Dan

I am trying to use the excellent bit of code on the faqs to disable the bypass key. I have called it from the Open event of the form that I have got startup to start, it calls: Public Sub DisableByPassKeyProperty() Dim db As Database Dim prp As Property Set db = CurrentDb Set prp =...

Very easy one!! Playing with my datasheet proporties, i have managed to turn out the ability to sort - anybody know what the property is that I have turned off?? Thanks Dan

Really irritating (but prob simple prob). Is there any obvious reason why four checkboxes that I have bound to a boolean field in a table don't update the table when I click on them on my form. Both the form and the filds are bound to the table, the only reason I can think of is maybe because...

This should be really simple, but just not working!! I have three text boxes 1,2 & 3 - I want to calculate a value in three based on 1 & 2, but return "0" if either of 1 or 2 are "0". So i tried IIF([1] or [2] = 0,0,([2]-[1])/[1]) it doesn't work am i doing something...

Any code ideas for removing a field from a datasheet on a sub-form after the update of my frame??