Search results

Okay, this is what I was looking for. Thank you so much. Now, one last question. If I want to see the selected records framed in black when I change the filters that I marked before in yellow, how should I do it?

When I click here (red circle), I want the records that appear in the list box circled in blue to appear in the list box circled in green. ATTENTION: the list box may or may not be filtered (yellow circle), so it should add all the filtered records, giving the possibility to then filter again...

Two things: 1. I have changed the code I had for AddRemoveSelections to the one you propose. But what code do I have to put now in the button so that it selects me in the form and then adds me to the list box below, and in the delete box? 2. When you say "Your add procedure has no error...

Mira, quiero aplicar eso para esta base de datos que adjunto. En el diálogo, me tiene que seleccionar todos o borrar todos al seleccionar el botón correspondiente, pero también en caso de que utilice los desplegables que hay encima del primer cuadro de lista seleccionar todos o borrar todos los...

Edgar, ha faltado un detalle: debe seleccionar todos los ítems, pero a la vez que se añadan al cuadro de lista LstPautasAsignadas. Edgar, you have missed a detail: you must select all the items, but at the same time add them to the LstAssignedGuidelines list box.

Thanks a lot. I add Echo to avoid reflesh. Muchas gracias. He puesto un Echo para que no haya ese salto de pantalla.

Dim i As Integer On Error GoTo Err_lbl Echo False For i = 0 To Me.LstPautas.ListCount - 1 Me.LstFincas.Selected(i) = True Next i Echo True Err_exit: Echo True Exit Sub Err_lbl: Echo True MsgBox Err.Number & ": " & Err.Description...

I have this database that I share with you a form (FPautas) with a list box, called LstPautas, in which I want to put two buttons: one to select all the items, and another to delete all the selected items. Could anyone tell me how to do it? Thank you.

I have created a Configuration form where the user can create backup copies and select the number they want to have. When you activate it, once you close the database, a file is created with the date and time, and the oldest is deleted to leave the number of copies selected. This is the...

Hi guys. Excuse me for answering now. This is the problem. If I modify a field of a record, and go to another field of a different record, it is automatically saved and I can no longer go back with the escape. I just wanted to ask if there was any possible solution. The database I'm making...

Sure, but that means duplicating all the fields and for all the forms you have. Can't you save the values in some VBA variable and then retrieve it? Maybe it's simpler, but I don't know how to do it.

Hello people. I wanted to know if it is possible to undo changes when you change fields. If you are in a field, you change part or all of the content, but then cancel, what you just entered is not saved. Now, this does not happen if, by doing the same thing, you then change fields. Is it...

Thanks so much. Solved.

Hello. I have the following custom ribbon: <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="T001" label="Salir"> <group id="T001G001" label="Salir"> <button id="Salir" label="Salir" imageMso="MasterViewClose" size="large"...

Thanks to all.

You're going to excuse me, but in the end the button wasn't necessary. I was recording a video to show you how it works when I realized the error. Thank you very much for your clarifications. Anyway, I'll explain what I've done with another example that does apply: I have a form where the...

The issue is that I only want the button so that when it is in the oil type field the user can, through a series of inputboxes, add a price and a date, which will be saved in the table. I don't know if I can convey what I want to do. The subform table is not synchronized at all. Where it is...

Thanks, Pat

For me, no, but the user so cause he doesn't know to use Access so much.

Hello. I have solved the problem using the technique that you do not recommend, because, even though I agree with everything you advocate in the last posts, it is something simple that does not present a major problem to solve what I had at hand in my case, which does not mean that which in...