| Thread | Last Post | Replies |
|
| Rollover Help | 26 Aug 2006 16:52 GMT | 2 |
When using windows and you hoover over a control or a command button sometimes you get these little white boxes that show up explaining to you what the command does. How would I do the same thing in Access? Thanks
|
| Change Link Child via Code | 26 Aug 2006 16:07 GMT | 1 |
I have a subform that has a link to a unbound cboBox on the main form. I have the subform's Link Master set to the cboBoxName. However the Combo Box data changes depending on what the user checks on the main form. I need to program the Link Child Fld to change as well. What would be ...
|
| subform troubles | 26 Aug 2006 15:59 GMT | 1 |
Hello. I have a main form (frmClient) and on it there is a tab control. On one of the tab pages I have 2 subforms (sfrmCarrier, sfrmPolicy), both are continous style. The frmClient and sfrmCarrier are linked properly. I now have sfrmPolicy linked to sfrmCarrier using the ...
|
| How to prevent user from blanking out a combobox value? | 26 Aug 2006 15:36 GMT | 1 |
I have a combobox on a form that is displayed in grid mode. I want to prevent the user from blanking out the combobox value. The combobox value list is populated from a table of valid values; it does not have a blank row as a valid value. On a non-grid form, I would set the ...
|
| SQL Statements | 26 Aug 2006 14:31 GMT | 2 |
Is there any difference between these 2 SQL statements? The where clause... 1 SELECT PayName.PaymentNameID, PayName.PaymentName,
|
| deleting orphans | 26 Aug 2006 13:22 GMT | 1 |
i'm struggling to delete some 50-60 student records from a one (students) to many (qualifications) query - the orphans are the students without a qual only way i can find these students is to include quals side, produce all students and search for nulls (QualID) - but it wont let me ...
|
| Change Tab on a Form in VBA | 26 Aug 2006 09:25 GMT | 1 |
The form uses a combo box to pull data to populate the majority of the form. However there is sometimes data missing. What I have been asked to do is to check all the fields for null and if null then change the background color. That one I can figure out. However, they
|
| Change Query in Sub Form | 26 Aug 2006 03:55 GMT | 1 |
I have a main form with some combo boxes that I use to filter data in a sub form. I have added a couple option boxes so that the user can choose which data set to query in the sub form. I'm not sure how to code it in the on click event of the option they select. Below is ...
|
| Need help to save record in the table | 26 Aug 2006 01:38 GMT | 2 |
hi i have access form which is used to calculate values for the different types of formula..(Type1 type2 ,etc..) my aim is to save all the inputs ,type of formula & the calculated value in
|
| Clear All Check Boxes on Form | 25 Aug 2006 23:42 GMT | 1 |
Is there a way to clear all Check boxes on a form without having to call out each one and set it to Null or False? Thanks Matt
|
| Form Design w/ hierarchy structure | 25 Aug 2006 22:17 GMT | 2 |
I have a question about general form designs. I have a sort of hierarchical structure to my tables, say tables A B C. A 1->m B. B 1->m C. I want to display all data in one snapshot. So given a list of records for table A, select 1 and show all related records from table B. ...
|
| Create Random Password | 25 Aug 2006 21:43 GMT | 1 |
I am trying to move my Network Administrator over from Approach to Access. He has some formulas in Approach that do the following when he creates a new network account: 1. Creates a random, unique 3-letter 3-number password (in uppercase) such
|
| How to concatenate the value of some records from one table into one string? | 25 Aug 2006 20:34 GMT | 1 |
i'm just the beginner of MS Access. could anyone teach me how to concatenate some value from the particular column of some records(in the table) into one string? so far, i know only select some records from the table
|
| How do I set the default value so that it includes all values? | 25 Aug 2006 20:33 GMT | 26 |
I am using a form to enter criteria values in a query. I would like to make it so that if I leave a field blank, it will not filter out those values. How do I do this? I referenced "using parameters with queries and reports" when designing my form, so hopefully that is ...
|
| Form Design Dilema | 25 Aug 2006 19:13 GMT | 1 |
Just a quick question. I have tried many design approaches for how to set up my forms to display the information I want to see but haven't gotten it quite right. I have tables set up like a hierarchy. A 1->many B 1 -> many C. I want to be able to see all data for tables A, B, ...
|