Recent content by traffas

Thank you for your quick replys....... my syntax was "=[ssnFromPassword]![Social Security]" where the query = ssnFromPassword and the field = Social Security I got this by using the "code builder" from the properties section of the text box. I am building a data base tracking student input on...

Is it possible to set the default value of a text box to the results of a quary? Something like: default =[name of quary].[name of field] when I try it, it will open and run the quary but will not set the text box value to the number............. Many thanks in advance Shawn

I have an Access 2000 database. Can you use it on a tablet computer? I have read that you can use msword and mspowerpoint and msexcell on the tablet computer. Has anyone use msaccess on a tablet? I thank all of you. What you do for others is very special. What you are is special. Shawn

found this solution from another tip.......... on lost focus, set focus to another control and then back to the control you want example if textbox = "" or isnull(textbox) then msgbox "message" textbox1.setfocus a different control textbox.setfocus...

Thank you, this is exactly what I was looking for...... I ought to give you two stars.......... Once again ...... thanks........ shawn I thank all of you. What you do for others is very special. What you are is special. Shawn

Thank you for taking the time to look at this thread...... I have a form where the use enteres data, text field 1 is for the city and text field 2 is for the zip code. I have a table [reftblCityZip] where common city are listed in [city] and corresponding zipcodes are listed in [zipcodes]...

Many thanks in advance for all your time and effort> All the material that I have been reading states that when you make a 'runtime' version of a database, you will not be able to use the 'spellchecker'. Is this a fact and if it is, is there a spellchecker that I can package in a 'runtime'...

I thank all of you. What you do for others is very special. What you are is special. Shawn

First let me thank you for your time, it means alot to me that you are willing to help. I have a EMS database (Emergency Medical Services) for Patient reports. It also provides several pages of statistics. The program is ready to be implemented. One problem exists........ The computers on...

Problem: Without making a form a Popup form, I would like to disable the resize button/control in the upper right corner. I can disable the maximize/minimize and disable the close through the form properties. I thank all of you. What you do for other is very special. What you are is special...

The situation: I have several fields that I would like to autotab out of following a certain number of keystrokes. example: time field (short time) in the form of 12:12. the mask places the colon. After 4 key strokes I would like to tab to next field. The next field is a numerical field...

Gentlemen, I am using access 2000. The examples that you have given me do not work. I have tried: 'me.activexctl0.value = today' & 'me.activexctl0.value = date', i've tried activexctl0=date and activexctl0=today. still will not work. These are on the form 'open' event. The programing looks...

Thank you for reading this and taking time to help a novice. I have a activeX calendar control on a form. I use the control to select dates for queries. This part works wonderfully. However, everytime i open the form containing the calendar -- it opens to a date in april. I can manually...

Thank you for taking the time to read this. I would like for a combo box to "open" its list when it receives the focus. I have not been able to find out how to do this. Many thanks........... shawn

I will be gone for over a week and will not be able to check my e-mail or view this forum. I will be back.... Once again thank you for your time