Search results

I have. I checked text. same prob... I am investigating... While seeing if anyone knows reply. Thanks.

Default value = "000000" now how do I check what user is entering....? If on keypress ... first entry is.... say '9' following code shows "000000" and length 6 ... when actual length is 1.... Private Sub txtFld03001_KeyDown(KeyCode As Integer, Shift As Integer) Dim lenChk As Long If...

Found answer... So, buddy 3 years later here is your answer, maybe the 'pro's' assume we should know this... lol... Anyhow. Assign bound column to 1 or higher, sometimes assigning default value with 0 as bound column, it won't show. Worked for me. Thanks...

Solved. Was bound column ..... Needed to change it and assign cosco to it thereafter. so if anyone ever searches this problem to better explain. Cosco was column 2 . Bound column was 0 . And object was limited to list. So after changing bound comumn to 2. I could assign cosco to it. Again...

Ok clearer view on this... to help u help me. First combo box. required selection. ID CompMask NoFlds 1 Costco 11 Second combo box, attains the value Costco...... Yet I can not assign Costco to Combo box one, nor does assigning value one. :confused:

I mean .... I can open a global recordset and use these values I would attain through runsql based on the parameter I attained from the second combo box.... Call the other procedure and only add a few lines of code and be done with it. But this seems lame... can I not assign the value of a...

Ok keep it simple. I have a combo box. Row Source Type Row Source are assigned from tables values. They select a value.. and I do alot of magic on the form for formatted data entry... (Too long to explain why) I need to assign a value to this combo box, based on another combo box selection...

I have had this prob too... I use default value and item doesn't value doesn't display on form load... any reason why... any ideas...?

Very good point Mercer My last company did the same. I would hold alot of the data in access. I would export alot of information to excel for users to play with. If you divide the 2 up well, you eleviate alot of strain from the db. Excel will also be faster for many seperate cases of user...

Sorry, answered myself again.... Well... in testing keydown in an actual txtBox to find keycode for end... I found out they can press end to goto the last of the tab indexes.... So duh, they can just hit end after entering there data and boom they are on sendmail... I don't post right away I...

I searched to no avail. I want to make a shortcut. Keydown.... but anywhere on the form.. I have tried Form_AfterUpdate() Private Sub Form_KeyPress(KeyAscii As Integer) If KeyAscii = "myutest" Then cmdSendMail.SetFocus End If End Sub would be the ideal place ... I first need...

Thank You! I NEEDED CEILING FUNCTION U GUYS ARE THE BEST! It existed in excel, and I needed it in access for bar coding upc formula to get cehck digit... You guys rule...

Solved my own prob thanks... Me.Controls("Text" & cntr1).'property' = 999 'example' works fine, so my issues are soved, thanks....

Alright, I have searched and searched, found alot of examples and guidelines for arrays and their existance and non existance in access... I need to change properties of 1500 text boxes... 100 X 15 ... This is an entry screen and the formatting changes depending on the selection, being the...

Have you tried... Assigning the value of the inputbox to a variable string..? Regards,

Do you wish to do so on a report..? If this is the case it's easier.... You need 2 record counter... txtBoxes on a report counting records with this code. txtBoxes Running sum Over Group or Over All Recordcount =IIf([txtField]>=0,1,0) Recordcount2 =IIf([txtField]<0,1,0) txtPercent in group...

Sonya... Can you please show us your condition clause so we can view the problem? Regards,

well.... You could add one field to a table and call it fldAgeType 'or whatever' and make it a select from list. add kids, adults, and any other category you may want to add... this way you could keep both in one table.... Or if you want to keep it all on one record in your attendance...

Sure.... Well when you import, you can select to skip columns while creating import specifications... So you could create many specifications for one file always selecting the columns you need for each table. This is one approach. Hope it helps... Regards,

well.... Why not do a search.... Set a recordset to the source of the list and then do a findfirst on it. If rs.nomatch = false you are in business.... Would this not work? Dim db As Database Dim rs As DAO.Recordset Dim strCriteria As String Set db = CurrentDb() Set rs =...