Search results

After a delay of a few days, I've received an update on this : He's still encountering this same problem (ie as per original post). The database did Compile. I made sure of that before I forwarded it on to him. Prompted by me (at your suggestion, CJ_London), he checked for the existence of...

I have recently created an Access database for an acquaintance, sending him the 'working-copy' (.accdb format) file, and instructing him on splitting the database into 'back-end' and 'front-end'. It seems he's been able to create the back-end (‘Database Tools’ --> ‘Move Data’ section -->...

Yes, I initially got a Count like that. I found that when I commented out the line about recurrences (olItems.IncludeRecurrences = True), I got a true count of my Appointments within my specified date-range. In my case (as I won't be using the 'recurring' Appointment functionality within...

I'm trying that out (ie the filter in that format). Early indications were that it'd worked. But on further investigation, I see that there are many Outlook Calendar 'Appointments' that have not been deleted, despite being within the date-range specified by me. I'm trying to establish whether...

On an Access form, I have an unbound 'unbCalendarUpdates_FromDate' field, an unbound 'unbCalendarUpdates_ToDate' field, and a 'btnCalendarUpdates' button. On the 'On Click' Event for the button, I have the following VBA code. What I'm trying to do is to delete all Appointments (lying within a...

Using a combination of a hidden text-box, conditional formatting (based on the contents of the hidden text-box) and some VBA, I reckon I've achieved what I set out to do. Thanks to you all.

I thought it best to post this in 'Forms' rather than 'Modules & VBA'. In the past (in relation to other databases I've worked on) and again in the last couple of days (for the one I'm working on now), I've conducted research around making formatting etc changes to specific fields in specific...

The verdict from EA : The database file is severely truncated (with much of it "filled with non-Access binary data"), and there's nothing that can be salvaged from the remaining portion. Thanks to everyone who helped with this.

I've now trialled SPh 'Repair For Access'. Unfortunately, it hasn't worked. After selecting the database, the repair started to run, then abruptly stopped, and the app closed.

Evening of Tu 11 Feb 25 : Awaiting contact from EA.

Thanks very much for the kind offer. I may take you up on that. Just for now, I'll await word... Thanks again.

Update on this : At about 5am (UK time) Fri 7th, I uploaded the corrupted file on the EA website, and received a reference number. I haven't yet heard from them. I guess that it'll now be Monday at the earliest before I learn anything more from them. I notice that the "common corruption...

You mention 'specialist recovery software'. Which one(s) would you suggest / recommend.....[if you're able to on here?]

Thanks for the further info and suggestions. I'm now having a re-think / re-investigation....

Hi again. At my first attempts using your suggested code, I get run-time error 31523. Based on this - and isladogs' post too - I need to re-think.....

I’m away from my PC for a few hours, but am really eager to try your code. I’ll get back to you. In the meantime, Thanks!

Hi. I wonder whether someone could advise me on the following, please. I recently encountered the MSysDb error-message on an Access 2021 database I've been developing. "The Microsoft Access database engine could not find the object 'MSysDb'. Make sure the object exists and that you spell its...

Oh, my goodness, it's now working. The code is now : Private Sub FilterSubform() Dim strSubformSourceObject As String Dim strSubformName As Form Dim strFilter As String Select Case Me.TabCtrl1.Value 'Blocking & sequencing Case...

Yes, and that got round runtime error 2465. After that, I got a runtime error 5 (Invalid procedure call or argument) on the line .Filter = strFilter I had to go off and do something, and only coming back to it now,...so I haven't figured that one out yet.

Correction : My subform Name will be objSubform, and the Source Object will be sfrmDay_BlockingAndSequencing I'll try objSubform Using Set subfrm = Me("sfrmDay_BlockingAndSequencing").Form got round runtime error 2465. Now I'm getting runtime error 5 (Invalid procedure call or argument)...