Search results

Hi folks I have a form and subform. I need to - 1) show the number of records in the subform on the main form 2) count the number of records in the subform where a value [Public] is True 3) count the number of records in the subform where another value [Analyst] is True. I can achieve the...

Hi Folks it has been a while since I've been on this site and I have a daft question for you access pros out there! I have a DB (purpose is to record projects and those working on the projects). I have a main form which shows the projects and details and the subform shows the staff members...

Hi Folks It's been a while since I've been on here (and since I've done access work). I have a new database and on the main form i have a combobox that searches company names and then displays the relevant record. This works fine (although I would like to hone the recordset so that the form...

anyone got any opinions on this EU/US aviation deal? bbc link US airlines will get access to the EU domestic market but EU airlines will not get access to the US domestic market. why does this not surprise me? the more i live the more i realise that when dealing with the US it is a one way...

evening all, as a recently passed (:D ) motorbike rider i feel i'm pretty safe on the road and very observant after the training i have had. however, i've almost had a few incidents with other motorists. i've read opinions from other bikers that if you get involved in incidents then even if...

Afternoon All, Right then.....i have a query which I use to search the database, users click a command button to open up the query and then are prompted to enter the parameter value. The results are then displayed in a form - what I want to do is to display the search term used at the top of...

bbc link you never really know how close another internet user is to you.....:eek:

did anyone see ben thatcher's challenge? slow mo on you tube - elbow hit i reckon he should be done for assault - there is no place for that in football

evening all, I've recently passed my CBT (basic bike training) and have been driving a 125cc moped about - i'm absolultely loving it!!!!. I'm now wanting to do the direct access test (lets me ride a bike of unlimited power:eek: ). i am trying to think of what would be a suitable bike for me...

The UK Parliament has now started the process of debate regarding the replacement of the Trident missile system - http://news.bbc.co.uk/1/hi/uk_politics/4804144.stm Should the UK replace this system or make the the brave decision to get rid of a nuclear deterrent in the hope that it spawns a...

Hi all, i am a member of a website based in the uk (http://www.snowboardclub.co.uk/) and the owner is getting concerned about people slagging off companies on his boards. he is concerned that one of the defamed companies may start legal action against the website for publishing libellous...

http://news.bbc.co.uk/1/hi/magazine/4566526.stm

has anyone got this game yet?? just got it last night and it looks pretty impressive although it is going to take me ages to get to grips with it - it seems huge compared to civ3. still, got the xmas holidays to get good at it!

afternoon all, I have a slight problem, not serious but just irritating - i have recently moved to a different pc at work (a Pentium4 instead of a Pentium2:D ). since i moved access (97) has been having problems. I have a variety of Dbs and usually access them by duble clicking on their icon...

info as body of email, not attachment afternoon all, apologies if this has been covered previously, have done a search but can't find an answer..... problem: I need to send an automatic email to certain users every day. This i can do easily using docmd.sendobject (did use a macro to start...

weekday thing again Afternoon all, I know there have been a few posts on this topic in the past but i cannot seem to find what i am looking for...hopefully someone can point me in the right direction. I'm 90% sure that i have seen the relevant module several months ago - basically it is a...

morning all, i've got a command button on a form that runs 3 queries - 2 delete queries and one append query. every time i click the button the warning boxes appear.....is there any way that i can shut these off? the queries are run using vb code on the on click event. thanks in advance....

morning all, is there any way that i can incorporate today's date in the name of a file that i want to export to an excel file? i presume date() must be involved somewhere but i can't work out how to do it. the export is going to be done via on click of a command button...... thanks...

morning/afternoon/evening all, its been a while but i now need to ask another question - i get a list (in excel) sent to me every day. at the moment i need to go thru it manually to see which items are new, which are no longer there and which items have had amendments made to them....this is...

Morning all, after a quick search I could not find a posting that could help me. Problem is that I have numerous queries of which about half use calculated fields that need to be amended (CEO changed how he wants certain info calculated). The two main changes I need are - CurrentNumber...