It appears to me that the Data>Form option wants to use a list of predefined options. I am wanting to prompt the user to enter competely random information and create a row with the data. For example, one section is titled Events and would contain random events that were particpated in during...
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...
Ok, I got it to spit out a number, butI am sure it is not the correct one for the displayed message. I have a box to enter the date in as mm/yyyy. If the numbers do not fit a date validation rule supplied by the system, it spits out a message saying:
"The Value you entered is valid for...
I actually want to use the error to display a custom message. But I only want to display it for certain errors, therefore, I would say
If Error = ##### Then
Message
Else
Skip errors
End If
I just don't know how to get that number.
Yes! This works perfect! Thanks a lot for the help. The only thing that was amiss was that you left a few THENs off and the COLUMN property starts at 0 so it was 1 instead of 2.... Again, thanks for the help.
One more minor question; how do I get it to tab out of the control now? The code...
Ok, I am a little confused about the terminology I think. In the first portion you mention:
"Let's say you have the listbox with the following properties set:"
Then you just said:
"...listbox portion of a combo-box..."
I guess I do not know what the listbox portion of...
Is this code for a listbox or a combobox? In the listbox there is no setting for autoexpand. Also, I was looking at the help on ListCount, and it says it works with a CommandBarComboBox. I looked that up and couldn't quite understand exactly what that was and if that is what I have. It is just a...
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...
That worked great. Thanks. One question; you left of the "FileName" and it still worked, I was curious why that is not necessary? I could have sworn I tried it without the FileName once and it didn't worked.
Actually, that line of code is all I have and it makes the Windows Save dialog come up. It allows them to browse to a location and chose their own file name. I just have "FileName" as a string but never actually assign anything to it. I discovered that this caused the dialog to pop up...
Where would I put this line? I tried putting it right before the ouptut code, but I still get the message. The exact message is:
"The OutputTo Action Was Canceled"
OK
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 figured it out. It was the mask. It was storing the date as a number, i.e. 01/1999 -> 019999. So different months and years really screwed up the chronological order. I looked at the Short Date mask and it had an extra zero on it (00/00/0000;0;) so I made my mask just like it with out the...
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 have gotten a little further now. I have gotten the query to pop up the correct form, but cannot get it to populate the form with the records. I am using this command now:
DoCmd.OpenForm "SearchResults", , "AlumniSearch"
It opens the form "SearchResults", but it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.