Search results

Thanks Guys, Sometimes you cant see the wood from the trees

Great, thanks very much for your help.

Im trying to preform an exisize that will help me understand arrays and there uses. What i want to do is from one database (a)lookup another database (b)and if the tables match import the new table from the second database. The first piece of code loads all the table names in the in an array...

Not sure if you should be deleting properties. The code below should do what you need. Call it like so: Private Sub Enable_Click() ChangeProperty "AllowBypassKey", dbBoolean, false End Sub Function ChangeProperty(strPropName As String, varPropType As Variant, varPropValue As Variant) As...

Im tryingf to learn some of the active x features but I havent got the above help file on my system. Does anyone know where I can get this file or a usefull resource for all similar help files. Thanks in advance

The code below will create a new field based on the current business day. i want to be able to assign this field a value (SumAmount = CDbl(DSum("[market_value£]", "tbl(9) Borrows_cash_term_alloc_stk")). Can anyone tell me how I do it. I know how to do using sql but i thought there must be away...

Hi Got a strange one: In a query Ive put the function below. AccRef: IIf(IsNumeric([BP3]),Format([BP3],"000",[BP3])) the problem is if the field BP3 contains eg 3D4, access appends it as 30000. It also classes it as numeric rather than string. Both field in both tables are text . Can anyone...

Easy when you know how. eh Thanks, that looks like a lot less hassel

Thanks I was copying some other persons methods and I incorrectly assumed that ReDim strContainer(1,DelimCount + 1) told the array to begin at 1. The problem with the Options Base 1 was something I added to the web code just to highlight that I had tryed it also. Leaving the placement of the...

You could add the field in the underlying recordset, give it a text box on the report and make it invisible. Failing that you could use a dlookup of one of the other text fields in report back on to the origional table

I'm trying to learn how to use arrays and I having some difficulty. What I'm trying to do is split a line of text in to individual elements separated by a space. eg the function call would be strSplitField("the man is walking down the" ,3) As String. this would return "is" The first part of...

Thanks again, Im stating to understand the concept. Im only used to Access VBA but your recordset decription helped me visualized an array. I think I need to play around with it some more. Thanks again for your help

aRRAYS Thanks, Your help is much appreciated. I just dont get how you use it. The array is indexed so how do you link that to a recordset ect.

aRRAYS Thanks Guys, Not being from a IT backround im failing to understand its uses. Ive been coding VBA for over a year now so i felt it was something I should understand. I was hoping that someone would have a simple working version of an array ,so I could see where and how its applied. I...

I seem to have developed a mental block when it comes to understanding arrays. Does anyone one know where i can get some simple working examples. MS help is a little confusing. Thanks

Ive got a big table in a database which i need to break down by Column owner. For each Column owner I need to creatan excel spreadsheet. Currently im using some sql in code to create a seperate table for each owner. Then the table is exported using the transferspreadsheet method. When the...

Very Helpfull thanks

Does anyone have some code that will detected the last time an excel file was modified before importing in Access . We receive a file sporadically so I want the process to ignore the import if the modified date is the same as the previos day. Im thinking of storing the the modified date in a...

Compactor sent

Paul, I had a similar problem. I found an access addin called compacter which I can send you(email me). I put together some code to detect when the database reached a certain size. The user then got prompted with a tes no box to compact . see code below The addin needs to be installed before...