Here is the code that I have for my list box.
Code:
Private Sub cmdCreateReport_Click()
On Error GoTo Err_cmdCreateReport_Click
Dim strCriteria As String
Scldb
Last Activity: May 15 '09, 08:39 PM
Joined: Feb 22 '07
Location:
-
Using List box for multi select
I created a list box that will let me select more than one, but the problem is that when I run the report (a command button that I created and works) the results are not what I want. Instead of showing just the particular items that I selected it shows everything.
Here is the code that I have for my list box.
... -
Got it. I click on the very little square on the top left side in Design View, went to properties and did what you said. IT WORKS WONDERFULLY. Thank you very much.... -
Sorry, but I don't know where to find "OnCurrent" on the form. Can you please tell me how or where to go....Leave a comment:
-
Not following you on your statement there. Can you go more into detail....Leave a comment:
-
Yes this works. Got the mousehook.dll all set up and it's running smoothly....Leave a comment:
-
Now I got another question related to this. The code that you gave me works but if I check yes (blnIS) for the active record that I'm on and then when I'm finished filling out the form and move on to the next form - the txtApplication is already active. It's suppose to be inactive/deactivated until the user checks yes (checks the blnIS checkbox).
The code that I'm using is:
...Code:Sub blnIs_AfterUpdate() Me.txtApplication.Enabled
Leave a comment:
-
Scroll button
I'm designing a form and I want to deactivate the scroll button. Everytime someone uses the scroll button, it goes to either a new record or previous record. I don't want this capability. May I get some help? -
Thank very very much. It works.Leave a comment:
-
To help you help me, here are the answers to you question:
What type of control is txtIs (a TextBox I would guess)? - Data type is Yes/No (so on the form all I get is a box to check)
What type of control is txtIs (a TextBox I would guess)? - I'm assuming that if a user checks the box this would be a "yes".
So txtIs is the checkbox for Yes/No and txtApplication is the next question that should only be...Leave a comment:
-
After applying this code, when I check the box - the textbox that I want to be enabaled is actually disabled (it was enable to start out which I want it disable until I check the box). Thank you for your help and hope you can still help me on this....Leave a comment:
-
Let's hope this will clear it up:
Example: First question - Do you have any any siblings?
Second question - How many
I want the "How Many" question to be Disabled/Inactive until the first question is picked(yes).
Here is my actual code so far:
What do I need in addition to the code to make this...Code:Sub txtIs_AfterUpdate() Me.txtApplication.Enabled = Me.txtIs End Sub
Leave a comment:
-
It does work but if I pick one record that is no, all textboxes going forward locked/grayed out. Can I have a code to reset on every new record...Leave a comment:
-
Active, Inactive textboxes
I have a form needs to be filled out. A lot of the questions are a yes/no question. When they pick yes I want some other textboxes to be active, and when they pick no I want the textboxes to be inactive. Example - A question could be: Do you have siblings. If you check yes, then other line would appear to say “How many” (other textboxes are active)? If you say no, then it skips to the next question (other textboxes are inactive - grayed out).... -
Sorry, I forgot to tell you this part. The equation that I'm trying display will be on a table. I created the table, now I'm using an update query to update that column into a percentage of the equation. Every row will have different numbers, but utimately, the equation should be the same. I have the proposed price and current price on this same table and every row has different proposed prices and current prices - hence the "([Proposed Price]-[Current...Leave a comment:
-
How to write code for Median
I have a column that I what to show a negative number.
The equation for this is:
Unit Price % = ([Proposed Price]-[Current Price])/[Current Price]
With Numbers it would be:
Unit Price % = (378.62 - 382.44)/382.44
Which is -1%
But Access shows 0.00%
Can I please get help. Thank you -
Sorry, yes it is/was. I don't think I need to open up a rs(record set do I.
I put in the code and it didn't work. Can I get more assistance on this issue?...Leave a comment:
-
Median
I have a report(rptBuild Rpt) that generates a report from a form(FrmBuildRe ports). On the report, I have a text box called txtMedian. I want to get the median of a column (Engine Price Est) in the report only (over group). Can someone please give me the code for this?
For an example I have a text box called txtMax and the control sourcce is
=Max([Engine Price Est]) and this gives me the Max price for the report that was generated.... -
Now how do you turn off the scroll on your mouse. Everytime I scroll my mouse, it switches to a previous or next or new record. I only want to switch between records by the buttons.Leave a comment:
-
Thanks, for all your help. I'll see what I can do....Leave a comment:
-
The code you gave me is for a report that is linked to a form (a form that lets people build queries) then prints out a report of the query.
So with this being said, I want the median of only the query (over group) not over the whole table. What would the VBA code be for this? It wouldn't be the same would it?...Leave a comment:
No activity results to display
Leave a comment: