Search results

i think he means inside the textboxes, which is what happens to me too unless i clear them via command

who's Adam and why do i keep reading about him?

But does that take effect on alt+f4, or closing from win control pane?

Me.Dirty only works on bound forms, correct?

Ah sorry, no i meant rather a discard or save data within said form's txtboxes when you accidentally attempt to close the form or access.

Hi, how would i do a check before exit dialog window on a unbound form? do i just check each of the boxes for any values and based on that ask whether i should INSERT query, or is there a better way?

Hello, I'm from the Czech Republic where we have a system in place where in order to bill somebody a cash transaction receipt, we need to authenticate the sale through (EET in czech) Electronic records of sales (more on that here) Basically what it needs to do is send a xml to the Financial...

thank you very much for this, i was using the code bellow (which i've had recommended to me in the past here on the forum) for now, but i suppose it being on the button is not as smart as the data will remain changed when the user exits through alt+f4 or task manager, right? Private Sub...

Hi, I'm looking for some insight on ways to edit table entries within a form. What am i trying to do: Open a pop-up form on a specific record (that part is done), however, i want all the changes to be save on demand via a button confirmation, rather than just editting the raw data within the...

I forgot to thank you for your kindness, the input you have provided to me has been very helpful! Many thanks!

Thank you very much Minty, i didn't manage to get this running in the immediate window, but i'll try to get back to it later more than likely.

This indeed has worked, would you mind explaining why the extra set of quotation marks was necessary?

text field

I now tried this: Private Sub lstInventory_DblClick(Cancel As Integer) DoCmd.OpenForm "formEditSklad", , , "ID LIKE ' & Me!lstInventory & '" End Sub still resulting in a blank form though.

This is what i wrote: Private Sub lstInventory_DblClick(Cancel As Integer) DoCmd.OpenForm "formEditSklad", , , ID = " & Me!lstInventory.Value & " End Sub lstInventory being my listbox with search results, formEditSklad being my bound form with 4 bound text boxes. it however opens to a blank form.

Yes, i found that, however i don't know how i would let it know which line i selected.

Could you please give a short example of this? I'm absolutely new to Access, VBA and code in general.

Hi, how would i go about opening a form (in this case a record editting form) based on my selection from a list box? I have a neat little entry form with a listbox search on the right side and i was hoping it would be possible to double click any of the contents which came back to me via...

The form is a input form for the table "dbInventory" and its got text boxes for all collumns in it except date added. I thought that list box would be the best looking choice, although my knowledge about it's properties is basically nonexistent at this point i'm afraid.

Hello, i'm new to Access and i'm trying to figure out how to make a listbox next to my form show only information based on the input on said form. I got a table called "dbInventory" with "ID, InvName, InvQuantity, InvType" and a entry form matching these fields. What i'm trying to achieve is to...