Recent content by John Jnr

This is exactly what but where is it in VBA? I searched the forum to find what I want and found it! However if you read the thread the code was supplied, but it is not listed. Can anyone help clear this up? Thanks J:D

And I thought I had Cracked It?!?!? List Box Trouble And I thought I had cracked it? It deletes a multiple selection, but it sometimes deletes records I haven't selected. Please help I am going insane!:confused: Cheers J

I cracked it . . . . . But! For future reference. This code allows a multiple selection from the list box and then deletes all selected. However as you delete more (testing) it sometimes leaves a previous deleted area in the list box highlighted (black). This then produces a remark 'Invalid use...

Thank's Glynch, However, I have two list boxes. I copy data from one list box to another, with a table behind the target list box. The user might copy two or three of the same date to the list box as the data is car parts. I therefor also need the user to be able to delete these if they make a...

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...

It's OK I did it. I am a bit slow today and I lost my job (I wonder why!) Oh well here is the code: Private Sub Command25_Click() On Error GoTo Err_Command25_Click Dim MyDb As Database Dim Myset As Recordset Set MyDb = DBEngine.Workspaces(0).Databases(0) Set Myset =...

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 modified it slightly, but this is my lot or I will be fired! Cheers J:rolleyes:

Logo PowerPoint to html to rip gif. As with everyone else not allowed lovely graphics package at work! However this site has come to my first aid so many times and you need all the support you can when starting that dark road into Access. My pathetic attempt. . . . . Cheers J

Cracked It! Brad, As ever I played and played then finally cracked it: I wrote the control source into VBA as: Text79.ControlSource = "=Sum(" & "[" & [Forms]![Form6]![Combo0] & "]" & ")" Works fine. Thanks J:)

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...

Sorry Pat for not replying sooner. I will give your solution a try and let you know if I have any problems. It's not that I have any problems with the Excel solution in terms of my Excel ability but I would like a dynamic solution that Access should be able to deliver. Ps. How's the book coming...

It's done in Excel but the plan has to be sent out to 50 plus engineers who have very limited ability in Excel. I have been tasked in making this idiot proof (I hope you are not an engineer?). If the engineers could update their project via Access all the data would be collated for analysis...

Cogent1, During the budget process the plan at Jan 1 becomes fixed. These projects in the budget are reviewed quarterly. The project costs can change. I want to be able to track these changes. The only way I can do that is if the amended plan is saved to another table? Then compare the amended...

Is this a design problem? This is giving me a headache and I think it may be a design problem! What I am trying to do: Create a Financial Budget Plan DB Overview Approx 540 projects carried out per year. These are set with costs and form the financial plan over a four to five year spread. At...