First  |  Prev |  Next  |  Last
Pages: 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
On Current Error
I just made a couple of minor changes to my database and now I am getting this message when I try to open my main form: "The expression On Current you entered as the event property setting produced the following error: Return without GoSub." The only changes I made were to move some buttons and text fields aro... 2 Apr 2010 10:24
double click open with related subform
Hi. This is the makeup of my databse: 3 related tables: CANDIDATES (Unique identifyer = CandidateID) POSITIONS (Unique identifyer = PositionID) INTERVIEW (Unique identifyer = PositionID, CandidateID) I have created a a datasheet view form (MfrmCandidates) with a related subtable (POSITIONS - subfrmPositions) ... 31 Mar 2010 15:29
filling a control in a continuous form with a field from a table
I had posted this under "Access Reports" in error and received a response and responded. Please follow the dialog for an explaination of my question: Original Question: I have a form with the fields: date, client, atty, time, billable and description. All these fields update the Time Sheet Table. I want th... 31 Mar 2010 11:00
List box populate based on combo box
I have a combo box that is based on a table. The three fields that are selected should generate a listbox based on a query. The query filters the the selection. I can't get any info in the list box. The query works and the listbox contains the column names but no records. Am I not using the right fields for... 30 Mar 2010 22:58
sum won't update
Using Access 2007, I have a sum expression in the footer of a subform to total the values of a field in all of the records in the detail section. When the database is opened by a new computer running Windows 7 the sum expression will not recalculate changes made to records in the detail section unless "refresh... 30 Mar 2010 18:25
Unbound Combo Refresh
I have an unbound combo on a form that is summing a value from a subform. (=sum([project payments]) I need it to update as I change from one record to the next in the main form. The mainform and subform are linked by project #. Thanks!!! -- Milton Purdy ACCESS State of Arkansas ... 31 Mar 2010 07:39
Toolbars in MS Access 2007
How do you add a custom toolbar to a form? I know how to create the toolbar, but was unable to display it on my forms. I tried adding the name of the toolbar 'Quick Access' to the Toolbar property of the form, but received this error message: Microsoft Office Access couldn't find the toolbar 'Quick Access'. ... 30 Mar 2010 16:08
Problems filtering recordset with combobox
I have a combobox which has the following under the RowSource property: SELECT DISTINCTROW Onyx_Allocation.Month FROM Onyx_Allocation GROUP BY Onyx_Allocation.Month ORDER BY Onyx_Allocation.Month; There is only one column in the combobox which is populated with data from the month column of the Onyx_Allocation... 30 Mar 2010 17:17
Lock only updated record
Hi Everyone, Using Access 2003. I have a patient database. I will try to explain as best I can but I don't know the object names etc very well so let me know what else I need to give if the info makes no sense. I have a subform of patient therapy that shows on a main form. There are several fields with ... 31 Mar 2010 15:29
Calculated fields on a form
Hello I have a series of related tables (and the relationships work fine on the form) and I am trying to do a calculated field on a form : I have added a textbox and built the formula =[tblBrochures]![Quanity]-[tblOrders]![OrderAmt] both the variables are "single" But I get an error #Name? returned. ideally i ... 30 Mar 2010 12:47
First  |  Prev |  Next  |  Last
Pages: 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54