Search results

Aha! This gives me a clue to the issue I am seeing. When I was adding a record, the parent form was showing filtered records. Removing that filter seems to help.

Thanks all. I did see the comments, earlier, regarding split/emulated split forms, but I haven't got around to trying those methods. I will take a look into it tomorrow. @Gasman, no, not solved. I marked it as solved and tried to undo that, but not sure it worked.

I have not and I'm not sure where I would start with that. I wanted this to be a quick project, as it's only for tracking our "to do" list, rather than being a full customer database. I can't believe it isn't possible to do what I want it to do, I'm just not sufficiently well-versed in Access...

Further to this, if I simply order the parent form to reopen like this: Dim intJobNumber As Integer intJobNumber = Me.txtJobID DoCmd.OpenForm "frmTodayNew", acNormal, , "JobID=" & intJobNumber I can make it open to the correct record, but at the expense of the subform scrolling back to the...

The above code adds the new record, but I'm still having the same issue. Clicking my button in the subform to go to the required record ONLY shows the recently added record, not any pre-existing ones. Pete

Hi. Sorry to dig this one up again - we have found a problem in the way Access handles what I've done. When I add a new record to the database, the overview of the job appears in the subform, as expected. However, when I click the Show button, the form does not move to the desired record, but...

Great, that's incredibly helpful.

I've used it for a couple of things in a different database where I couldn't work out the correct way to go to a given record. Just for my understanding, if I'm in a form and want to go to a specific record (assuming unique ID), is the correct syntax: me.recordset.findfirst "IDwanted=" &...

Hi MajP, That works perfectly! Thanks once again for your assistance, it's very much appreciated. Pete

Yes, ok. As it happens, it doesn't work now, so I do need to get to the bottom of this. Subform has a number of fields including JobID. When a button on the subform is clicked, I was capturing the JobID and opening the form again at that record (I'm guessing that's at the heart of the behaviour...

Thank you for taking the time to answer. For some reason, the form is now working as you described above. I don't know what has changed, but it seems ok.

Hello everyone, I have a form that has a subform on it. The subform is formatted to be a continuous form and shows a summary of jobs to do. The user clicks a button on the subform and the full details of the task appear elsewhere on the main form. This all works fine, except that when the user...

Hi both, Many thanks for your very quick responses. That code works, thank you! Best wishes, Pete

Hello everyone, Our company database has a facility to add a folder containing pictures or files of any inventory items we keep. There's a button in the appropriate form that has an "on click" command to check to see if there's any folder in the appropriate place for the numbered inventory...

Thank you once again for your help.

Thanks for that, arnelgp. Will the bit Nz(txtSupportContractID,0) not return a zero when there is no SupportContractID? This won't happen, as there won't be a line in the subform when there is no Support Contract. What I'm after is counting the number of visits, but returning a zero when there...

Actually, I think I've answered my own question: =Nz(DCount("*","tblSupportContractVisits","[SupportContractVisitTypeID]=1 AND [SupportContractID] = txtSupportContractID"),0) seems to work. Does that look right to you experts? Pete

Good morning, I'm tying myself up in knots trying to count the number of records that match two criteria to be displayed in a subform. I appreciate that there are similar questions on this forum, but I can't find something that matches what I'm trying to do, hence I've asked here. Thank you for...

Just dropping back in to say that the issue seems to be resolved. The person who assists with our IT stuff has set up an entirely new Hamachi network for us. Apparently the original connection was via Mesh and he has changed it to something else (Gateway?). This appears to work through Eduroam...

Thank you for taking the time to look at this, Doc Man. Food for thought. As a first step I will ask the boss to check the server setup and see if that gives us any further idea of what's happening.