Search results

  1. I

    delete table records with listbox

    with this code it doesn't do anything. the records i selected stay in the listbox he doesn't delete them
  2. I

    delete table records with listbox

    i have tried that. but it still doesn't work Dim Response As Integer Dim h_rs As DAO.Recordset Dim vItem As Variant Dim Ctl As Control Dim rs As DAO.Recordset Set Ctl = Me.list_labeloverview For Each vItem In Ctl.ItemsSelected Set h_rs =...
  3. I

    delete table records with listbox

    it still doesn't quite work. when i select multiple item i get the error: no current record. and when i select one i get the error: object variable or with block variable not set and then when i have pressed end it has deletes the top record
  4. I

    delete table records with listbox

    if tried you code some ways but it doesn't seem to work.
  5. I

    delete table records with listbox

    Hello, i'm kind of new to working with VBA Access and i am experiencing some problem. i have a table where the user can save labels. then i have a listbox where the user can see which labels are saved with his username. i also have the option for the user to deleted records that he doesn't...
  6. I

    save multiple records at once in vba access

    no problem it works now so i'm happy
  7. I

    save multiple records at once in vba access

    thanx it works. i only changed loop in next. but it works as well. when i put 3 in the textbox it saves the label three times. thank you
  8. I

    save multiple records at once in vba access

    this is not really what i'm looking for. i want to keep it a simple as possible for the users. the way that they have it now with the dymo is that they can submit the amount when the are on the form for printing the label and then the dymo prints that amount. they don't save anything in a...
  9. I

    save multiple records at once in vba access

    in the access system the company is working with everybody works in but everyone is logged in with his/her own username and the pdf file only shows the labels that are saved on that username. so for instance if person a is the current user an has 5 labels in the table and person b has 5 labels...
  10. I

    save multiple records at once in vba access

    yes i already have that. i save those labels to a table and based on that table i make a report and that report i generate to a pdf file.
  11. I

    save multiple records at once in vba access

    that is not the idea. the company where i'm programming for has a dymo label printer. but it only works on one computer. the want to change this. they don't want to use the dymo label printer but a normal printer where they can put a a4 label sheet in, and then through the pdf file they can...
  12. I

    save multiple records at once in vba access

    hello, i'm working with access and now i have a question if it is possible to save multiple records at once. i want to save labels. these will be saved in the table when you press the button and i have a seperate button for generating the labels from the table to a pdf file. now i'm having a...
  13. I

    cancel form_close

    i have a bit the same problem. I want to have that when you press the close button that you get a msgbox which asks if you want to quit without saving. it works when i put it in form_unload. but i have also buttons on the form that closes the form when you have clicked on it. it's a form...
  14. I

    Query problem

    yes i know that, but it is a variable that is somewhere in my vba code in access. so i want to know if it is possible to retrieve that variable from the vba code to the query without that pop-up box
  15. I

    Query problem

    i have a question, i don't know if it can be done i'm working with vba access. here is my problem. i have a table, from that table i made a query and from that query i made a report. he executes the query perfectly, but i've added a where clause to it and every time i run the query or the...
Back
Top Bottom