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

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

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

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

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]= "06" Me...

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

I have 15 check boxes on this form. The user may only choose up to five. How do make it so that if a user checks a sixth box, it does not get checked? (msgbox, no check) Do I have to dim, set, declare the checkboxes and then write an if then or select case statement? If yes or no, could anyone...

I have a form that registers members who are in a committee table. Once registered their votes may be tallied. Let me give an example. On one race a committee member may vote for up to 5 out of 8 candidates. now I have set up 15 toggle buttons for candidate slots. The idea is, that when the...

ok I am working on a 'candidates' form. I will say that there is a committee table with a list of committee members who vote on the candidates with a weighted vote. On the form, user who are tallying votes will scroll through the districts and for each committee member, enter their vote. They...

I have a really simple question, and I hope someone has the time to answer. I have a table of members, and they all have a registration number. This is their key. There is one form to register the member, and they must be registered to vote. How do I make this simple lookup form? Over the...

I am automating an excel file by using command buttons place on an empty sheet in the file, meant as a menu. I have a macro which opens a second excel file on command button click and refreshes the queries to update the data for me. I am looking for how to save and close the second file once...

I need to set the control source property for a text box on a form being used in excel 97. I need the value to reference a sheet's cell within the workbook. What is a valid property value for sheet1 cell E6? This should be so easy, but everytime I try to set the control source it says invalid...

I need to set the control source property for a text box on a form being used in excel 97. I need the value to reference a sheet's cell within the workbook. What is a valid property value for sheet1 cell E6? This should be so easy, but everytime I try to set the control source it says invalid...

I am working with a report which contained 13 subreports. This is compiled into an exe. My problem is that one of the three Access tables linked the the 14 reports is updated with new data every month. Is there away to set the database location for the sub reports the same as the primary...

I have created and executable for a monthly report. It contains 14 reports which all use the same three Access tables. Every month one table must be updated with the new data. Once this is done, the reports do not refresh the data correctly. It says in the report, that it cannot link the data...

I have automated an entire report process, and I only have this one automation left to accomplish. I have a make table that needs to make the data table for the monthly reports, and it needs to get its data from the table with the most recent date. I am looking to find out if I can set up a make...

ok. Here's the situation. I am working with an Access database. Getting into specifics will not help. Everytime I do, people suggest a route that is not condusive with the needs of the office. I will do my best to give you an idea of the setup we need. I have a form and a subform. The first...

I have a relationship problem, like wiseguy. I have two tables. One has street addresses and each address has a number, which it corresponds to. Many addresses have the same number. The second table acts as the pk 'one table' for the number, which has many fields of information to it. I...