Search results

Success! db debug ver.accdb Form: RspndrSuffixSlctSubform Page: 942 Properties ... Objects ... Command Button: Choose_But ... OldBorderStyle: 1 OnClick: [Event Procedure] OnGotFocus: [Embedded Macro] OnGotFocusEmMac Version =196611 ro: ColumnsShown =0 Begin Condition ="(Not...

Unfortunately, I cannot install Vtools, am locked down by the institution and my home computer does not have Access. :( I would love to try though. Will try the QueryDefs loop, will Google it. Seems pretty easy to do an Instr search.

This is all I get: Perhaps you are using an older version of Access? EDIT: Oh, it was under "navigation options": No, it sounds like you don't understand, I don't want it, I want to stop the error from popping up, so I want to find where it is coming from and delete/correct it...

I only have a choice for "hide," not "unhide" or "show." I have done that, it is not there. I even delved into all the other (Msys) tables that I could figure out how to, and the aforementioned form name is not there. :(

I have just too many issues with putting this in a public download link. PLEASE msg me here (click on my icon and "start conversation"), and I will happily send you a Dropbox download link (until the issue is resolved).

Hmm (thinking here), this is a db of protected personal info, but this particular form only changes the suffixes/titles of the list of available names of staff (and only for subsequent records), so I think that could be done. It will take quite a while to do though, I will just need to delete...

Hello again, I have a split database on an institutional network, a very complicated front-end with dozens of forms that interact, many interact with each other via vba. I am using a method that implements 'live search' technique in the affected form. The problem is, as soon as I click on the...

OK I figured it out. I set a breakpoint on said "call" line, and followed the execution. I found a recordset name that was similar but not the one I was using, it was erring on rst.close in the subroutine. Fixed the recordset name and I think I have it solved. Thank you for your effort Isaac.

Yes, and yes. That's what has me stumped, it does not break in the subform subroutine, but on that call line.

I just found a reference in the subform subroutine to a textbox control on the parent form, and corrected it, adding the prefix: "Me.Parent!". But now I get Error 91: Object variable or With block variable not set. The subroutine does have a (single) sizable with block. What is tripping me up...

Hi again, I have been having some trouble with improving my 'live search' form, where it shows results as you type search criteria. Because the "requery" function interferes with the cursor in the criteria input textbox control, and I have to transfer the .Text contents into another control for...

Well long story short: it was because I am working remotely, and I was starting Access with the remote laptop. I tried it by remote Desktop from my office computer, and it sorted without problems! I tried remoting in because the little db had gotten so slow, it was taking a minute or two for...

Hello, I am trying to manipulate data from an Access table linked to Sharepoint, in a new database in Access 2016 or Office 365 Access. I have the link working successfully. In particular, one field that I have to do some conversion on to convert it to a numeric value. Unfortunately, it is a...

Status update: oh call me an idiot, because it is/was still doing the "compact on close" behavior, I had just turned off the status bar. I can't tell (if it's doing the "compact on close" thing) when the status bar is off and I am running a local copy because it runs two maketable queries on...

Even my local copy was "compacting on close," but it was just the FE that was local copy, the BE was on the institutional server (through a VPN). That's what makes it so curious to me. I may try connecting tomorrow for a few minutes, just to find out if it still does it.

Well I'm not working remotely today, and guess what: it's not doing the "compact on close" behavior. Could be since my last bugfixes, I won't know until I work remotely again, which might be almost two weeks.

Just to give you a taste, so to speak: First, keep in mind our records in our main table have >50 fields per. They are legal records, so they must never be changed (except minor corrections like typos). There is recordkeeping of the edits/users. I have a subform with 16 distinct visible fields...

https://www.access-programmers.co.uk/forums/threads/compact-on-close-despite-setting-accdb-split-database-fe.311629/

Thanks for you input guys, but the real truth of the matter is in a few week's I will have time to completely rebuild my FE from scratch, it's just that I could've used that time to do some more learning. As for the control name vs field names issue, do you think this may be causing my "compact...

The references that I am trying to change were never Dim'ed in a module, they were always just form controls (which also happen to be same name as the fields from the queries/tables. (As you know) I don't think you can even Dim a control name in module for that form.