Search results

..here's a rugby joke just in time for saturday's crunch match (apologies if someone has already posted this - don't have time to look through 16-odd pages of postings!! "The England rugby practice was delayed nearly two hours today after a player reported finding an unknown white powdery...

cheers folks, much appreciated.

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

cheers mile-o that will do perfect - very much appreciated!! euan

i need the filename to be along the lines of "financelist 241003.xls"....basically just any format of date as long as it is there. thanks,

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

thanks folks, i've bodged together a solution of sorts using a few layers of find unmatched queries....although it is a bit clunky and slow....i'll give doc_man's suggestion a try...although hold off on the VBA code solution...i'm not too hot at that!

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.