Recent content by HenriM

Griffyn; Thanks for your response. In fact I did mention that I don't use Autonumbers, and increment the record IDs in code. However,in the meantime I have been able to solve the problem and the solution may help others so I'll explain. TO RECAP:- The grid records are selected:- SelectRecord:=...

This is a little complicated and involves quite a lot of code, so I’ll try to explain in plain language. On each of my Forms I have a DBGrid The relevant query selects filtered data from a Table and this is posted to another Table whose Datasource links to the DBGrid. The ‘filtering’ is...

Thanks Ken. However that is not the cause; this file was an attachment to an e-mail from the hard drive. As I said, this is not a real problem, easily put right, but I am just curious. I spoke to another developer who did have the same experience - and he didn't know why either! As a side...

One of my Users suddenly had an error message "This record is not Updatable", accessing a database which I had sent to him. Because his firewall throws out everything that breathes, I had to remove the .mdb suffix before sending and he had to put it back on receipt. We have done this numerous...

There are certain objects which, once created, remain constant and need to be called in more than one procedure. The messy way of accessing these is to make a query and join the required tables; but this was making some of my procedures unnecessarily complicated and it was very easy to get the...

Thanks Roy! I used the docmd.runcommand accmdsaverecord and that worked perfectly. You also opened up a new vista for me! After 3-4 years use of Access I had never seen or heard of the Docmd.RunCommand options and I hade been using a roundabout way of deleting (or rather hiding) unwanted...

I have a number of objects in my database which I need to see recalculated on screen as soon as they have been (new record) entered or changed (amended existing record). I have the following code in the "On Exit" event:- If Me.Dirty Then On Error GoTo err: Dim BM As Variant BM = Me.Bookmark...

I do use msgBoxes but another technique is to have an invisible text box, which comes visible on an event. The advantage being that you can have it any size, any font and any colours you like. In the Form's 'OnCurrent' Property you have 'Me.[textboxname].Visible = False' and on the...

Having had no response to this (most unusual!!) but having traced the problem myself I thought the cause and solution might be of use to other members. Basically what I was doing wrong was to have a subform duplicated on the main Form, with different master/child links. (One linked to Self and...

I am using Access 2002 in Office XP on Windows98. In one project I have several forms which require a Recalc when certain data is input or changed, and the focus must go back to the right object in the right record. To do this, thanks to "tek-tips" I have the following code:- Dim BM...

Thanks foolio12 for your very quick response. Let me try to clarify, as you request. "CReport" is the name of the form. "ReportID" is the ID of the record to be opened. As I said, the line of code does open the form without a problem first time around. I use this line...

I have a Form with two alternative Command Buttons, depending on data in a table which Changes as certain functions are completed. One says "Print Draft Data" and, when this is actioned the completion date is entered on the table. Next time the form is opened,the date under...

My apologies to those who gave me the right answer - which didn't work for me! The reason was that on installation I have created two copies of OfficeXP, one in the folder MicrosoftXP and one in the default Microsoft Office (which also holds Office97). I don't know how this happened and I know...

You definitely do not need to delete a record and add a new one if all you are doing is amend the details. Your input form should update your table automatically. My impression, for what it is worth, is that if the structure of your database is right you do not need Vb. Now, as a self-taught...

GingerR Yes it does open Access! Next job is to work out why it does not go the rest of the way. I need a break, so I am closing down for the evening (20.30 here) and I'll start again in the morning. Really I am thrilled with the response from the three of you and I can't thank you enough. If...