Search results

Thanks to all those who have offered advice and suggested a way of doing this i've now sussed it out and it works.

Pat, Will that work in access97, I cant check until monday cause I've only got 2000 on my machine at home and i'm not in the office till monday and if its not being too cheeky an example of how to apply would be great. thanks.

Drevlin, Thanks for all your help, it was a spelling mistake that was the problem. its difficult to type using my elbows having bitten my finger nails that far. Once again thanks for the patience and help. Ive got over the hurdle and heading for the line.

Drevlin, Thank you for the explanation and yes I know have a vague understanding of what is going on. OK that now seems to do as I envisaged on button plane01 but it doesn't work for button 2 onwards and if I click button 2 it changes the state of button 1 I'm rapidly looseing the will to...

I now get the error "ByRef argument type mismatch" this appears at the line whichButton btn_Aircraft_Selector_Plane01 I'm not sure I wholly understand whats going on here Thanx again

Drevlin, Thanx for that but I've tried it and I get an error message on the following line "User defined type not defined" which has now completely thrown me Sub whichButton(ByRef cntrlButton As Button) Any ideas thanx again

AAAAAAAh dgm, Thanks for that I've since tidied up my original code but without the ability to know which button has been clicked I'm still going to have to duplicate the whole procedure 22 times, which to be honest seems a bit excessive, especially as I can change the names of the buttons in...

Not sure how to apply that llkhoutx, Thanks for the snippet, but i'm not sure how to apply it in this case, what i'm trying to do is get the identity of the button as it is clicked. Having run the snippet of code it just seems to cycle through all the command buttons on the form. Am I...

Sorry, I'm not sure what you mean?

I have a form which has 22 command buttons on it, I have written a procedure which formats the command button when it is clicked, but the way i see it at the momment I have to write 22 slightly different procedures i.e one for each of the buttons. What I want to do is write a procedure which...

Is it possible to format the colour of the text in a combobox. I want to use the colour of the text as a flag for priorities of task ie red for high, yellow for medium and green for i'll do it sometime. Ive tried using fontcolor but it doesn't seem to work, the only action I seem to be able to...

Is there anyone out there who has a method of compacting Access 97 databases during silent office hours. The only way I have found in the Knowledge base requires the database to be given a new name when you compact it. The problem I have is a lack of server space so I can't have two copies of...

Not sure what you are trying to do or where you want to do it. Some more detail might help

Seek and Ye Shall Find Try the link shown, what you need to use is a parameter query. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=29789

I have two questions for the vb guru's out there: 1: How do I disable the close X in the access. The one in the top right of the screen. and 2: How do i hide the access system window the one that lists all of the tables forms queries etc. Thanks in advance Steve

One hit wonder The reason I want to do this is to create a keyword lookup combo box from an existing datatable. The table is made up of two fields of which on is a id number field and the other is a memo field which looks as though it has had word documents pasted into the field. What i am...

suppressing warnings If the delete procedure uses a VB script you could just before the actual delete statement use the following. DoCmd.SetWarnings False then after the delete statement switch the warnings back on by using DoCmd.SetWarnings True.

Is there any way that I can count the number of times a particular text character appears in a text field and also the positions of that character(s) within its field and then use that info in a query.

Thanks Pat for the help i'd tried "and where" many times and it didn't work. No wonder Thanks again.

This should be nice and easy for any access guru out there. In a union query can I have multiple criteria. for instance from the where clause. where field a = "some text" and where field b = "some other text" and where field c ="some more text" etc. If it can be done can someone please post...