Search results for query: *

I have this code, and it is used on click of a form to make a table with all capital letters, become proper case. This means that BOB SMITH, with BOB in a first name field, and SMITH in the last name field, becomes Bob and Smith. This is really helpful for some of the data that comes through our...

spoke too soon, lol. Now it opens right, but on everyslide I have an image (exit) which is for the user to be able to leave it, putting them back at the application. Problem is when they click it, the show closes, but the powerpoint shell is left up. Can that be set to close too? I would love...

wooohooo Thanks! Donkeygirl, Kickin' the crap out of Access

I created a powerpoint show, which acts as a help file to an Access application. When you open the app, there is a menu, and a help hyperlink at the bottom. It is linked to the power point pps file. I saved the ppt as a pps, and when I did, I had set the show to open/run in full window. When I...

I have a search field on a form, to look for the title of an event. If the person types in election, there may be more than one record for that. Election Day, and Election Inspector, are examples. Now I have a button with macro onclick: GoToControl, Find record, which finds one of them, what I...

I saw this last night, and thought, 'that won't be it. I'll have to wait for more replies.' well, well, well, I come in this morning and remove the exit sub(<<<evil! evil I tell you!) yep. I have been working on that for over a month, and yep that was the only problem. Thank you so much! I...

lol Ok I have a form for viewing lists. The user chooses 1 of 2 options from the first option group on the form. It allows them to decide if they want to see a list including data from areas, or for a specific area. If they choose 2 then they also choose an area from a drop down combo box. Then...

well, I got some good help on this from Scott, and he helped me create the code I need. Only problem is that while it works for one search method, when you add the code for a second one it doesnt like the Where any more. Here is the full happening: Code that works...

That would be great if you could email me that, and also, I have tried to do that toggle break point thing, but I don't understand how it works lol. courtneyfay@hotmail.com Donkeygirl, Kickin' the crap out of Access

O.k. I have a newspaper catalog database that I am trying to create, so that we can find articales when we need them. I have the entry form all set, and now I am having trouble on the search side, which of course seems to be difficult. The search form is being set up to allow the user to...

Thank you so much. I printed out the post you replied with. It will help me a lot. I apologize for not replying sooner. I had gotten db overload, and needed a break. Now I am picking it back up again. Thank you again. IS

I posted this in a reply in Access, and then put it in forms, because it does belong here. But really this comes down to vba, lol. I am sorry for posting this so many times. I was banging my head into the wall trying to solve this last night. I was almost set with this onopen statement of...

I was almost set with this onopen statement of the form, but now it is all screwed up. The idea is that I need to det two option groups on the form to null --> ME![opgrp] = Null and to fields to where I want them, so that the form will show that record on start up. Me! [LT]= &quot;06&quot; Me...

Thank you. I will have to look this up to understand the syntax, but it is a good suggestion. I will post my other problem here too, although I must put it over in forms, since it belongs there. If you have any thoughts, let me know. :-s I was almost set with this onopen statement of the...

This is two fold. I have these records that we will sift through a list box to get to, but I also need little cmd buttons that will jump to a specific place in the list. ie. these are by legislative town or city. (LT) we want to be able to jump to the beginning of the lt 06 , or 21 and so...

What you might do is not make the option inactive, but instead put action on it for when it is changed or , hhmmm. I was looking at an option group of my own last night, so I know there is no on click, which would be nice. Wel,, you want to evaluate the button, maybe in the validation rule. If...

As unhelpful as it can be if that did not work, I am not to good with dao stuff. Then I would definitely look at dim in help. Unfortunately 97 is much better with its help. But nevertheless. I would also recommend a good access dev reference. I have Access Developers Handbook 97. It is ok...

You can do all of this after the update. Refresh the list and open subform. Look at the subform wizrard. Once set up you can modify it to open after refresh of the data. Also, if someone enters in the same data into a field, you can put a validation rule in the property box of the field to...

I have another question for you, Chris. I need the option groups to only store the click value if the user confirms that they want it by clicking a command button. Can I do this? Come in between the option groups intent to automatically send the data to the table on click?

Thank you. I will try this out. I was trying it another way until now, but the way I had it gave the message box but still let the check box be set to true. I haven't been able to set it back to false. I know this sounds stupid, but I just can't figure out syntax very well. Thank you again. IS