Search results for query: *

I have a question about MS Excel. I want to create a spread sheet that is interactive and flexible with a user. Want I want is to prompt a user for data input and have it create a new ROW with the data under a certain section. First I do not know how to prompt users for data. Second I am...

I am trying to remember the way to get an error number so that I can figure out how to skip it if it comes up.

I have a combo box where the user chooses the state. I would like to have it act like the combo box everyone is familiar with where if you hit the same letter, it cycles through the choices in that letter. For example, if I hit "O" twice I want it to cycle to Oklahoma instead of typing...

I have a button that outputs a query to a saved file by asking the user where they would like to save it. The code is: DoCmd.OutputTo acOutputQuery, "Search", acFormatXLS, FileName If the user clicks cancel to saving it, a message comes back saying "Output was canceled." Is...

I have a combo box where the user chooses the state. I would like to have it act like the combo box everyone is familiar with where if you hit the same letter, it cycles through the choices in that letter. For example, if I hit "O" twice I want it to cycle to Oklahoma instead of typing...

I have a combo box where the user chooses the state. I would like to have it act like the combo box everyone is familiar with where if you hit the same letter, it cycles through the choices in that letter. For example, if I hit "O" twice I want it to cycle to Oklahoma instead of typing...

I have a query that I am trying to get to work. I had it working perfectly until I added a piece and I would like to figure out why it is not working. Below is a snippet of the query that uses a form as its source. (((Alumni.CurrentCity)=[Forms]![AlumniSearch]![CurCity])) OR...

I am sure this is easy to do, but I can't find any reference to it. I am trying to run a query and instead of displaying the results in tabular form, open up a form to browse the records one at a time. I cannot figure out how to open the form and put the results into it. At the same time I am...

I am sure this is easy to do, but I can't find any reference to it. I am trying to run a query and instead of displaying the results in tabular form, open up a form to browse the records one at a time. I cannot figure out how to open the form and put results into it. At the same time I am saving...

I am trying to create some code that will search records to see if a person has already been input into the database. I have got the following code to do what I am trying to do, but I am curious if it is the most efficient way. I have a gut feeling it will be slow as the database becomes large...

I am making a database that has entries of people. For each person, I am trying to make a section where the user can enter notes on that person, save the record, come back at a later time and enter more notes. I would like to have each note shown as a journal-type entry such as: Oct. 29...

I would like to include a field or some text or something that would show up on a form that would let the user know when the record was last changed. What would be the best way to go about doing this? How would I include the date of update with the record and what would be the best way to...

I have a form that users use to run a search on the records depending on criteria they select on the form. The search button outputs the result to an excel file. I have all that working fine now. What I would like to know is if it is possible, when the user clicks the button, to have the generic...

I am making a query from a form based on the Microsoft example, http://support.microsoft.com/default.aspx?scid=kb;EN-US;210242, and everything is working well except for a few fields. Does a query by form only work with text boxes? I have some option buttons and a combo box that I would also...