Search results for query: *

Duane, It is not that I LIKE to move the ID field. My whole problem seems to be that I am trying to accomplish something that I cannot seem to get Access to do. And I realize that this is probably more a matter of me being a novice than of Access not being able to do what I want. First as to...

Hmmm, It seems that turning back from my wayward path of using an unbound Combobox, the previous problem came back up. When I use an unbound cbo, Select_Location, I can easily let the user type in a beginning letter, after which the cbo will dorp down and select the first record of the query...

PH (Philip? Phrank?) >>Wrong assumption. The first column with a width different from 0 will be shown. << Shows you how easy it is, especially if one is not proficient in Access, to lose a lot of time and misunderstand other, good willing people by making the wrong assumptions. I must state...

Duane, First I must apologize for keeping you busy during the weekend, and for keeping your mother form your devoted attention on this Mothers day. I am sorry that I seem to be so unclear in my explanations. Part of the problem may be that your invaluable advice has made me change some aspects...

Duane, >> The value of your drop down/combo box is based on the bound column of the row source query. Do you have a LOC_ID in every record in QLOCATION?<< Yes, that makes sense and is what I already had figured. The value shown in the Combobox after selection in the DropDown had to be of the...

Duane, I am trying the solution you suggested Name: Select Workplace Control Source: HOUR_LOC_ID Row Source: SELECT QLOCATION.LOC_ID, QLOCATION.LOC_EMP_NAME, QLOCATION.LOC_EMP_FIRST_NAME, QLOCATION.LOC_EMP_BIRTHDATE, QLOCATION.LOC_WP_WORKPLACE, QLOCATION.LOC_WP_STARTDATE...

Duane, Of course you are right. I will try as soon as I have some other issue solved. I am still struggling with some other problem. I decided to use the original combobox as unbound, where users can select from a query. That way I do not have to worry about the field that I want to save in teh...

Adalger, The OnExit and OnEnter proved to be a bit cumbersome. It now emptied fields. I found however, that adapting the input mask enabling the first position to be a space, would simply do the trick. See how we can sometimes think way too complicated for simple things. Thanks for helping...

Remou, The check on quarts does not seem to work. At first I had some problem with the stupid different settings over here (our decimal point is a comma, so had to adjust). After that it seems to check for valid entries, but never disallows any entries, even if I specifically try to enter...

Adalger, Thanks for your reply. The OnEnter and OnExit works, but it does require me to switch off "Field is required", since the value "" is not valid for a required field. But that is fine, since it does fill in at least a numeric value (0) OnExit, so no problem with invalid numeric fields in...

Duane, Been looking around a bit. Could I just use currentuser() in the same way as now() when it comes to grabbing whomever entered or last changed a record? It feels like a simple, easy way to do what I want - some minimal check on who is futzing with what records - while keeping too much...

Hi all, After having a lot of help on some other issues yet, I have some "filling in forms" questions. I have some time fields that are entered. The data is saved as numeric, not as a date field. The data entry person may vary and thus, people will try to enter stuff like 0.1 (for six minutes)...

Hmmm, been working with the first user input. I currently have my lookup Comboboxes in the Form sorted on the ID-field, the first field in the records. When selecting the appropriate records, people currently select through the box. I would prefer to be able to have people select records either...

Duane, Got it. Dipping into the reference tables and with some logic reasoning as to terminology, I figured it all out. Up until now it has been quite an eye opener as to what is possible in Access. It wouldn't have been possible at all without your invaluable support here. Many thanks for...

Duane, Guess you are right to at least leave some trouble spots for your users. I decided to just add special Command buttons for the Nav command and remove the default mini-record selectors at the bottom. Combine this with letting the tab order end on the command buttons, and making Save the...

Duh, I guess I never made the click to see a difference between (user readable) field names in a FORM and the associated field name in the corresponding table. This seems to work. Thanks a lot for helping me get that straight. Just kinda figured at first that the "Name" field in de properties...

While at it, another one I cannot seem to find in the Access documentation. I want to prevent users from automagically saving a record by entering Tab or Enter and thus going to a new record, until they specifically click on OK, after the visual checks or something. Is there an easy way to do...

Duane, I tried the sub form method First. For that purpose I created a new form EXTENDED_LOCATION based on a query QLOCATION, which combines all the fields of the two tables that create a unique location. The fields are LOC_ID unique, key field LOC_EMP_NAME LOC_EMP_FIRST_NAME...

OK, have been learning a lot over the past few days. And just started working on the table again. Took me a while to figure some of the issues out, but still have questions. I tried using a sub form, and although I did specify tht the contents of the subform should be directly related to the...

As an update to myself and those reading along... How do I make it so that filling in a value in the lookup field, will immediately fill in the automated fields? Is simply using the codee in AfterUpadet suffucient? Or does that require another step? Oh, how I miss dBase III <gggg> Cheers...