Form
in [Access]
|
subform problems I have a database that has a form for purchase orders. It auto-generates a purchase order number. The user types in customer information. The form also has a subform on it for details on parts. There is a one to many relationship between subform and form using the purchase order number. The subform also generates a... 6 May 2010 11:57
stLinkCriteria Syntax I am unable to get my syntax working for my four criteria. Can anyone suggest what is wrong? stLinkCriteria = "[FiscalYearInd] = '" & Me.lstFiscalYear & "' _ And [UHC_DEPT_NUM] = '" & Me.Text217 & "' _ And [PROV_UHC_CAT_NUM] = '" & Me.Text219 & "' _ And [DivisionCode] = '" & Me.Text221 & "' & "'... 4 May 2010 12:21
Table Help Hello Everyone, I know I have seen this problem before and that I have corrected it in the past, but for some reason I can't figure it out this time or find something similar online. The problem is simply, when I view a certain table one of its columns is completely filled in with "##########". The data is still t... 4 May 2010 11:13
ComboBox does not drop down. I have Access2003 & WindowsXP. The Combo boxes in my forms are not dropping down when I press the F4 key. The auto-lookup works though. Please help, Frank ... 4 May 2010 01:22
allow user to highlight field on form I have a database which records info about disabled people. One form is used to input comments about the the person and has several memo fields. The user wants to be able to highlight a field if the information is important and needs to be highlighted to other users of the system. I cannot use conditional forma... 4 May 2010 13:28
Access 97 form not properly refreshing I have a form that was creating using Access 97. The user can successfully input the data, but it doesn't reflect on the screen that it was inputted, but a query of the table will show the new data exists. --tj ... 3 May 2010 19:51
Field within Form Not Updating I have a form that runs off a query (the query runs off of 3 tables). One of the fields within the form is "Item". In Access 2003, when the user entered their Item number, the next field, item description, would automatically populate. Now, in Access 2007 the user must close the form and re-open it in order ... 4 May 2010 16:51
Are If statements possilbe in Queries? Hello, I have a subform and in this suform I have a combobox field called "Category". In this combobox I have a select query that pulls the Category and TeamName. On the master form I have a floating combobox called Team. When I choose a team in this field I would like the subform combobox to be narrowed down ... 3 May 2010 16:30
Modifying the template Northwind 2007 I am trying to modify the start up form in access template Northwind 2007. There is an orange bar in the form header. This orange bar is fixed and I can't remove it or change its color. Could someone help me please and tell me how to do it? -- Message posted via AccessMonster.com http://www.accessmonster.com/U... 3 May 2010 10:57
Updated Charttitle not working in Access 2007 This code worked great when using Access 2003 but when we switched to 2007, it stopped working. Any suggestions? better way of doing this? Library needs loading? I don't even get an error, it just does not update it anymore. Private Sub Graph0_Updated(Code As Integer) Me.Graph0.charttitle.Text = [Forms]![frmr... 7 May 2010 08:56 |