Search results

thanks col, this find unmatched doesn't seem to be able to spit out the data i want spat out. i reckon i'll have to try concatenating each record and then compare the two recordsets...that should highlight any alterations. the find unmatched should help in finding deletions/additions.

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...

thanks fofa, point 1): results are to be returned in the form of a report point 2): db was not designed by me and the tables are linked but not to the best of access' abilities. I will probably have to end up starting from scratch and properly linking all the tables. point 3); app is shared...

Morning all, we have a database (not set up by me) that holds various records in different tables. There are about 6 forms in total that are accessed via a main navigation form. I have been asked to set up a search facility on this main navigation form that will search the underlying tables...

morning all, hopefully one of you can point me in the right direction here.... I have a form with a subform (default view is single form) attached. what i need to do is when an on update event comes out true i need to force a checkbox on the subform to become true. I can make it do this for...

cheers jeremie, i got it sorted by deleting the subform and then creating a new one.

afternoon/morning all, i seem to have a slight problem......i was messing about with vbcode on a form, some things were working, others not. now when i try to access the code on the on click event in one of my subforms an error message appears stating module not found. access then freezes and...

numpty-boy here again..... did what you said jon, problem now is that when i enter the default field value as fOSUserName and run the form the field shows #Name?. when i tried to use vb code access complained that it was expecting a variable not a module! anyone know what i'm doing wrong?

afternoon all, firstly i apologise for being as thick as mince....vb programming is not my thang. this thread is exactly what i need. I need to capture the username of the user when they click a checkbox on a form. I've pasted the code from dev avlish into a module called it fOSUserName...

afternoon all, I have a form that runs off a main query. This query brings thru info to do with several departments in my company. I have added buttons that allow the user to narrow down the records shown to a specific department (by using me.recordsource ="QryXdept" on the 'on click' event)...

...try having a look at the Northwind database that MS supplies with access. I think the products form may have what you require.

..would using combo boxes be an option for you? have the field in your main table lookup a field in a related table with the names of all the banks stored in it. On your form have a combo box that will allow you to select the revelvant bank.. these boxes do use predictive typing.

bill, i've found that access is incredibly poor at producing graphs...i tend to creat queries with the required info and then export it to excel to generate graphs. I'm pretty sure access could do what you want but i've never got into using access for graphs...

cheers Ally, i did have one field appearing twice.....guess i was using that 'duct tape' you mention in your signature!:D

I have a report that is based on a query. It works fine but I am puzzled as to the existence of a field in the field list selector. it is called Expr 1004 and does not appear in the underlying query and when i select it to be displayed on the report it brings thru the primary key field for a...

..i think using the following expression in the criteria box on the relevant field in your query - like []&"*" ..this should prompt the user to enter a name, eg type in "Smith" and every entry under the name of Smith will be brought back (along with any smithsons, smithers etc). if you just...

100K of records?!? good grief...that must be nearing the limits of access is it? i think i remember someone telling me that once you get to that amount of records access starts to have problems?

...thankfully not....more like an amstrad 464!:D hopefully my IT dept will give me one of the natty new machines that they are doling out.

....how good our network is I do not know......my PC probably has something to do with the slowness...a pentium 2 with about 128k ram. it struggles with things like word and excel so a reasonably hefty database must be causing it problems.