Search results

Thanks, Doc--having a sounding board of knowledgeable people here is sometimes all the help you need! And I'm happy to be part of the bruised forehead club--if you can learn how to fix the stupid mistakes you get to graduate to the more complicated ones eventually...

So, uh. I'm an idiot. The command button on the menu that opens this form uses a macro that sets the Mode to "Read Only". This overrides the form level properties. Never looked at the button before. What a facepalm.

Another update: as mentioned above, I decided to just have a function toggle the AllowEdit property for all the controls on the form in the OnLoad event to true (they're all already set to true, I have a sneaking suspicion that I could toggle any property and this would work) and ... voilá. No...

Slight update, maybe relevant: I stated the conditions that allowed for "one update" incorrectly before--if I change a property on the form in design view, and before saving, just click form view, I get to edit the form. If I save the form, close the tab, and open it again, still locked out...

As in, post a copy of my database for y'all to replicate the issue?

Thanks for the ideas, doc! I think you've got the picture. Re the query prompt-- through the query itself. Just a simple [Enter ID:] under the criteria for the ID field. The query is a named query stored in the QueryDefs collection. From what I can see on the query's property sheet, it *should*...

Hi folks, Running into a maddeningly inconsistent issue with a form. It's a Single Form, recordsource is a basic select query that prompts for the ID of the record. AllowInsertions, AllowEdits, AllowDeletions are all set to true. There are no record locks, the recordset type is "Dynaset" for...

Thanks for your input, doc! Was trying to avoid the tedium so that the next guy doesn't have to re-write the thing when we do inevitably add a new step to the process down the line, cuz the next guy will be me. But tedium is kind of the name of the game sometimes with Access. I might be able to...

Hi folks, Hoping that like always you fine folks can help me figure this out. I'm trying to set up a form (basic, bound single form used for both entering new data and updating existing records) where only the top control is enabled to begin with, and each control below this is only enabled...

Hey @Galaxiom , can you elaborate on what a composite index is in this context? Sounds worth knowing.

Clearly still an issue with the subqueries not being handled well--those are the fields computed by your subqueries. I don't have time to dig further at the moment but I'll take a look later. Guess the bandaid fix wasn't enough. Check out this page for further ideas in the interim...

Yeah, this is what I was referring to earlier--if you "hide" the subquery-containing query under another simple select query, Access will let it work. Inane.

Gotcha. Well, something I tried based on Allen Browne's site referenced earlier in the thread: Hide your query with the nested subqueries in a new query--eg, make qryMeterDiffsHider, (SELECT * FROM qryMeterDiffs), and run the report on that. When trying this on the limited dataset provided...

Hi @LALovelady , I think the mods will likely ask you to create your own separate thread so that your problem can be addressed on its own. I took a peek at your query and reports regardless. One thing that I noticed in playing around when I had similar issues-- The Report's in-built group and...

Yeah, I think the likely scenario is that someone probably just edited the underlying lookup table directly. I just wanted to make sure that there's not some weird way to edit it through the Edit Value List without having a Edit List Form created or selected. If I set "Allow List Edits" to No...

Hi all, For a combobox set to a table/query for the rowsource, do the "Allow Value List Edits" and "List Items Edit Form" properties have any effect? I have a combobox with a table as the rowsource, and somehow, the underlying table was edited, seemingly through the combobox in some way? The...

Yeah, but see now I'm learning about WizHook and feeling good about my level of spanish fluency... That's a good thought, all the same.

Ha, I actually hadn't seen your article, but I did get that figure from you sidelong. Much appreciate the resources--I need to spend some time reading through the treasure trove you've compiled. I much prefer to do my own legwork where I can, just need a pointer in the right direction. My...

Hello all, I have a subform which may display anywhere from 1 to n records--when n < ~15, there is no vertical scrollbar on the right side. If I set the width of the subform control to precisely the width of the underlying form, I end up with an awkward 255 twip side-to-side horizontal...

Thanks Colin! Sweet setup.