Form
in [Access]
|
Subform not refreshing in Access 97 On May 13, 9:14 pm, Tom van Stiphout <tom7744.no.s...(a)cox.net> wrote: On Thu, 13 May 2010 09:18:07 -0700 (PDT), "techjoh...(a)gmail.com" <techjoh...(a)gmail.com> wrote: Rather than Refresh you should use Requery. -Tom. Microsoft Access MVP OK. I have a database that was working fine until a ... 17 May 2010 16:55
How to run event on other options I created a data entry form with a Save button. This button runs thru a procedure event which moves data to the proper fields, does a nested if-then-else statement and other things. I understand that when you tab to the last field, enter your data, then tab again or press enter, the new record is automaticall... 18 May 2010 12:35
combo box fills in arbitrary value A combo box on a form selects from a list of codes (001, 015, 400, 411, 500 etc). These are formatted as text with an input mask of 000. The Row Source is a simple Select statement that draws from a table. When you start typing the first character in this box, Access auto fills after the cursor with the value ... 17 May 2010 16:55
Order By/Filter clause corrupted with aliases I have a datasheet form (actually it's a subform, but this happens if you look at the subform on its own). It has a SQL query for a record source which joins three tables, and uses aliases (AS) for those tables. The displayed field from two of the tables has the same name in each. (The SQL is generated from ... 17 May 2010 05:52
how to update a field record based on inputbox? Hello access friends, Thanks for helping. First of all, let me tell you that i have a form named "Processos" based on a table named "Processos Rdinis", and this table has a primary Key named "IDdeProcesso", a fiel named "Fechado" and another field named "IDdeCandidatura". My question is how do i get an input box... 14 May 2010 20:31
mail Word 說æ Word é¦é > è¨å®æ ¼å¼ æä¸ä¸ä»¥è¿½è¹¤è¶ é£çµ å ¨é¨é¡¯ç¤º å ¨é¨é±è æ ¹æé è¨ï¼è¿½è¹¤æéåè¶ é£çµ (è¶ é£çµï¼å¸¶æåºç·çæè²æåæåå½¢ï¼æä¸ä¸å³å¯è·³è³æªæ¡ãæªæ¡ä¸çä½ç½®ãå ¨çè³è¨ç¶²ä¸ç網é ï¼æè å §é¨ç¶²è·¯ä¸ç網é ãè¶ é£çµä¹å¯ä... 14 May 2010 05:11
MS Access 2007: Calculated field based on subform: Hello: As part of a review assignment, I have been tasked with adding a calculated field to a form that will count the number of items listed in the associated subform. The subform is based on the table "tblProduct", and is a subform named "frmProductSubform". The Parent table is named "tblCompany". The ta... 13 May 2010 23:47
List Box Percentage Formatting Why does a percentage formatted field in my query used for the list box show up as a decimal rather than a percentage? I have the fields formatted in the underlying query as "Percentage" with 1 decimal. E.G. What should be showing up as 9.4% is showing up as 0.0942212345829. How do I fix this?? Frank ... 13 May 2010 23:47
Form Auto Populate I hope this makes sense... My frmEmployeeMain contains one subform, frmProbation. Within frmProbation, there are three subforms, frmProb1, frmProb2, frmProb3. Each of these three subforms has a CompletionDate field. These three subforms were created by three queries from ONE table, tblProbation. The frmEmp... 13 May 2010 22:41
#name? error Whats wrong with this expression in text box on main form reading value of field [SumOfEmp_Act_Prod_Hrs] in subform named 'qry_Emp_TotalHrsWorked subform' - it is getting #name? error =IIf([Forms]![qry_Emp_TotalHrsWorked subform]![SumOfEmp_Act_Prod_Hrs]>1920,"EMP HOURS ARE GREATER THAN 1920","Emp Product Hou... 13 May 2010 16:03 |