Search results

It's weird, Sharepoint seems to be the new big thing here to bring user input to a central server database from the masses, but when I did a little bit of Googling on the subject and watching Sharepoint training videos it appears to me (I may be wrong) that a traditional database is still used...

Yeah well it wasn't without it's (usual MS) hiccups either: Then when I tried to export to Excel: I've quit using macros months ago. FYI. Also: my institution won't pony-up for the 64-bit office, nor more than 4GB RAM, I wonder if the above overflow would've happened with 64b & 32GB RAM.

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/