Search results

i want to be able to loop through all my macros in code and find specific queries. Does anyone know how I can do it. Thanks

Thanks, That worked fine

Does anyone know who to do this. Thanks

Can someone help, Im trying to install a custom add-in I have built but Im having problems with the registry enteries. All I want is to be able to access the addin from tools/add in/ the function that need to run would just open a form. I have tryed setting this as a macro, function etc but...

Supid is as stupid does. A clear case of not seeing the wood fro the trees. Cheers.

Probably an easy one but I can get this code to work. The nested if statements are causing the select case problems. When it gets to case 1 it does reckonise the select case statement. It throws the error "Case without Select Case". Can anyone show me where Im going wrong Select Case intKey...

Thanks Fofa. I sort of got around it.. The problem I had with sql was i needed to select the grouped items. Then using that selection open the table again, scroll through the records and edit details. The two sql statements conflicted as they were looking at the same table. To get around this...

Ive been trying to do this for a week now and the dealine is looming so I'm really starting to panic abit . Im sure its a case of not being able to see the wood for the trees but I need help in a real hurry. I have attached a table with some information in it. Here is the problem. I have a...

Cheers thats the trick. Much appreciated.

I need to be able to pull one record where multiple records exist in a table in a table. Basically where more than one record exists I want to take the record with the furthest date in the future based on a date field in the table. Any help is appreciated

Not getting too involved but this how I populate recordsets. Basicaly use a normal query to select the results you want , Convert it to sql and follow the structure as below. if you want to send me the sql view once you have set up the query then I will show you how I would open it as a...

Do Until rs.EOF For Each fld In rs.Fields My code starts like this but what i want to do is start the next bit of code only when the rs.fields(1) is at the 5th record. I know I could put it in an index but is there any way of getting the recordset to move down to the 5th field when...

Just a guess but should it be next intcnt instead of supplier

00 represents demand : ie the sum of all our cash inflows and cash outflows that are due for settlement today. FSA or SEC as they are known in the states also require us to check out liquidity in the following time bands. Demand .00 8 Days and under I month and under So this is where the...

00 represents demand : ie the sum of all our cash inflows and cash outflows that are due for settlement today. FSA or SEC as they are known in the states also require us to check out liquiquidity in the following time bands. Demand .00 8 Days and under I month and under So this is where the...

Sorry, I realise its a bit hard to understand. It is basically a liquidity forecast. The database works out our firms liquidity (Cashflows and projected cashflows) and show them as a percentage of our deposit's. This daily calculation shows us our liquidity up to two days (if we liquiditate all...

I havent been using Access for 3 weeks now and Ive been given a task to do by the end of today. I cant see the wood from the trees here. Can anyone give me some pointers. Here is a sample of data from my table. What I need in field NewTotal example .for 001 would show (1,990,763,192)-(892,395)+...

Cheers Managed to get it to work by setting the focus on the tab click to a command button. This then triggers the requery on the subforms. Strange that there is no other way around it but hey it works. thank you for your help

please can someone help! I have two tabs on a form. The first tab contains a subform and the second tab contains two sub forms which are based on the first tabs subform. What is supposed to happen is when the user selects a row of data on the first tab it populates some text boxs.The subforms...

Thanks Pat. I will re-think my strategy