Search results

Your right... I went back and checked the MSDN site... which said... Note The Value property is not the same as the DefaultValue property, which specifies the value that a property is assigned when a new record is created. In essence... I am not creating a new record... I should be...

How do I set a default value for a combo box when closing a form? I have several filtered combo boxes that work in succession just fine, but I like the idea of changing the default value of those combo boxes to the last value entered so when that individual wouldn't have to go through the...

Thanks Wayne And YES Thanks Smercer... That did help Immensely...! I was so stuck on applying filters and trying to do it by code, I totally forgot about changing the query to a parameter query and using the three combo boxes as criteria and then use code. Excellent! :o I think it was Milo who...

I should have said that I used that on command buttons trying to filter the records when moving to the next record. It obviously didn't work. Ok... got it to work doing the following steps... Use this on Form1 properties… Data tab… Filter… Length = Forms![Form1]![Combo30] and Height =...

I have tried: DoCmd.GoToRecord , , acNext DoCmd.ApplyFilter , (Me.Length = Me.Combo30.Value) And (Me.Height = Me.Combo32.Value) And (Me.Width = Me.Combo34.Value) These are numerical values, I have tried various ways and I just can't seem to make it work. Thanks

The only time I have seen this happen is when the mainform and/or subforms have been actually designed on a display setting, and then viewed on a different display setting other than what they were designed for, or... if every thing is sized correctly go back into design mode and move the...

Yes, your absolutely right. Can you expand more on text fields that use the IME Sentence Mode: Phrase Predict, I haven't used them in the past. Or a link. Thanks

Ok... I went back and made a main form with subforms all with Data Entry properties set to "Yes" with no code on the forms. It will fly. If you give a repeated number or text in the text box that is set to no duplicates, Access will give you a warning msg about duplicate values, otherwise...

Quick note, on mine the data entry is set to "No". This is starting to get interesting... I use another form which isn't a subform and have a command button to add new records with other buttons to either 'cancel', 'save' etc. I went backed and checked... on the form in which I have those...

I forgot to add I found an issue working with tabbed subforms, when using code to resize your forms to another display setting, the tabbed subforms may not display correctly. This is obviously in the code, just passing this on incase you want to do this and spend a little more time refining it.

Just a quick reply, I haven't looked at your sample... I went back and looked at a project I have that uses a main form and tabbed subforms, and the main form is from a separate table from the subforms. The four tabbed subforms are from the same table but come from different queries to provide...

Here is a SQL response someone gave me... 1. The first part, namely ordering the records is a single query, SELECT ID, Division, Category, Class, Amount, Place, Points FROM tblYourTable ORDER BY Division, Category, Class, Amount DESC; 2. The next stage is to build a Rank/Place column -...

It is late... and it just dawned on me what I just posted... oops... I meant try to apply an IF statement or IIf statement to something similar to the one I used for 'Points'... If 'AmountNow' is > previous record then Value = 1 End If If 'AmountNow' is < previous record then Value = 2 End If...

Just a thought… The key I believe is in the ‘Amount’ column. How about having a function in the ‘Place’ column that states something like… If ‘AmountNow’ is > previous record then Value =10 End if If ‘AmountNow’ is < previous record then Value =5 End if Etc… I’m not very good at this but I...

I have ID, Division, Category, Class, Amount, Place, Points. ID (auto number); Division (sorted ascending); Category (sorted ascending); Class (sorted ascending); Amount (sorted descending - to show the highest amount first or at the top of the list); Place (to have a value returned here -...

1) I have a query that has... ID; Division; Category; Class; Amount; Place; Points Division, Category,and Class are sorted in an ascending order with Amount sorted in a descending order. An individual could be in several Divisions, Categories etc. with a different Amount. I...

Another example given to me... Dim A As Integer Dim AA As Integer Dim B As Integer Dim BB As Integer Dim C As Integer Dim CVal As Integer Dim AAcounter As Integer Dim BBcounter As Integer Dim DisplayText As String A = Val(Text1.Text) 'TextBox on form, Access would be TextBox1 AA =...

How would I go about doing this... ? Have a value "A", a limitation on how many times you can use "A" by the value of "AA". Another value "B", again with a limitation on how many times you can use "B" by the value of "BB". Use all four values to come up with a value "C". Example1: A=50...

I found the solution, I made an obvious oversight. I have one suggestion for individuals who put code into subforms etc. please put in a "breakpoint" to see if the code is running. I found that even though I used the click event on the tab for the subfrom, it wasn't an actual event; the code...

I have a main form in which I have 2 subforms in tabulated form on it. The subforms are all of off the same table through 2 different queries, pulling at least one piece of data from the previous subform and then applying it to that particular subform. Main table “Name” “W value” “X...