First  |  Prev |  Next  |  Last
Pages: 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
Subform not refreshing in Access 97
On May 13, 9:14 pm, Tom van Stiphout <> wrote: On Thu, 13 May 2010 09:18:07 -0700 (PDT), "techjoh...(a)" <techjoh...(a)> 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
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
First  |  Prev |  Next  |  Last
Pages: 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27