Search results

I have searched the forum and used every know possible solution to this! All I want to do is click on the parts in a list box hit a delete button and it then deletes those records from the relative table. Simple you think, then please help! Here is some sample code for you yo laugh at, and...

I want to poulate a table from a list box. The list box shows 3 columns with headings. I have the same headings in a different table. This is my code: Private Sub Command25_Click() On Error GoTo Err_Command25_Click Dim MyDb As Database Dim Myset As Recordset Set MyDb =...

I have a report generated from a form. In the report I have grouped Expense Type generating a Expense Type Header. I put this calculated field in the header: =Sum([ExpenseYear]) And everything works perfectly. However . . . . . If I put this in: =Sum("[" & [Forms]![Form6]![Combo0] & "]") I...

I have searched the forum and there is a couple of threads that describe how to populate a single record with a combo! My question is this: I want the user to enter a year on a front form (2002). Then open form and that form is based on a previous table (exactly) but the enetered year is...

Question: I have a combo field list The combo is linked to table where some of the field names are years: 2002, 2003, 2004 etc. Can I limit the combo to only select these years not other text based field names? Thanks . . . . . again!:rolleyes: J

I have a form that is generated from combo box selections. In the detail section of this form the text boxes are unbound but obviously controlled from the combo selection. I want to sum these text boxes in the footer of the form. I have put in the footer: =Sum([Textx]) and when the form opens I...

I asked a question related to this yesterday with no luck. So I will ask a simple question: Can a query be designed so from choices the user makes in a form made up of combo boxes with field lists. The query then outputs the results of those field selections? I have tried putting in the field...

This is probably going to be very simple? I have written a query etc etc. All I want to do is within the query make the user select a year e.g. Expr1: [Select Year] The query then selects the inputed year from the table field names and displays all the data from that year. Every time I try this...

Help please. All I want to do is on a query prompt the user to select the year field. I have a number of year fields containing spend(£) data. I have tried a number of expresions in the field entry grid with no success.

Please forgive me as I think this may be obvious but I am a Jnr member, and a real Access headache! I have a linked table to an Excel spreadsheet. The table shows suppliers in row and years in column. The data consists of spend £. All I want to do is run a query to count the spend for that year...