Search results

  1. C

    Code for checkboxes ..

    you can do with a query.. select ..... where <your_ckbox_field> = yes. this brings you the records that are checked in you DB
  2. C

    create a text box with vba

    What are you doing with the values after they are added to the text boxes? i will insert then in two different tables with the docmd.runsql command, with the exmple above, the 2 value will be insert on the row with the 1111 code in one table as the 3 value will be inserted on the row witk code...
  3. C

    create a text box with vba

    KenHigg Kind of like a continuous subform? yes ken, but i don´t know the way to read the value that user insert on the one of the text box's. bat wrote There is a limit to the number of controls that can be created on a form(regardless of wether they are deleted inbetween or not!) cant recal...
  4. C

    create a text box with vba

    i wanna create the number of text box's with a for loop depending the number of records retrieved from a query to db. this number can be 10 or 40
  5. C

    create a text box with vba

    hi all, does anybody knows how to create a text box with vba code? tks all
  6. C

    Load form with different values

    Hi all, I have to build a form that depends of the records that´s are retrieved by a query that is made to DB. The form must have the number of lines with some text box's as many the records is retrieved from the query, i.e. if the query brings me 5 records, the form must have 5 lines with some...
  7. C

    SQL UPDATE Statement in VBA (Troubles)

    try with DoCmd.RunSQL " update tblpromo set sno =15 where stockid =" & Forms!<forms_name>!stockid &";"
  8. C

    Form criteria using a list box

    try this, "[tblSettings.Line_number] = '" & Me.lstSearch.Column(0) & "' AND " _ & "[tblSettings.Part_number] = '" & Me.lstSearch.Column(1) & "'"
  9. C

    Delete Queries

    update the table instead of delete
  10. C

    insert in DB many records

    hi all, i have a form that shows me the result of a query.depending the query, this form can bring me a lot of records or few records.the default view of this form is continuous forms.for each row, the user must insert some information. anyone knows a way to when the user press the insert...
  11. C

    Counting specific records

    i dont know if i understood well you question but if you wanna sum the total price of eache category you can do a query with agrupate function, like this. SELECT category,sum(price) from <table_name> group by category; if you wanna the category and each price and then the sum of category, i...
  12. C

    field yes/no database

    field yes/no database solved hi all, when i put my post i had a sub form with the field that i wanna update, but i still can´t update the field. with your advices, i made some investigations and i alter my form. now, i don´t have a sub form but a form with the default view like continuous...
  13. C

    field yes/no database

    hi all, i have a query that select a field(yes/no field) from one table but this query includes some where fields that join two tables. if i run the query i get the field(yes/no) but i can´t check or uncheck this field. if a made a query that extract this field only based in one table, i can...
  14. C

    concatenate textbox name

    works, tks a lot
  15. C

    concatenate textbox name

    well. i think that i don´t explain my self very well. i have a do until cicle and the variable i is incremented at every cicle step, so, while not end of the cicle, the text box's name is changed with the i variable. here is my code: Set rst = db.OpenRecordset("select * from experience where...
  16. C

    concatenate textbox name

    hi guys, this is my first post because i start probramminh with vba just a few days ago a need some help. i need to concatenate a textbox name, i.e i have 10 textbox´s with names ns_1,ns_2,ns_... the 1 value must be catch from a variable and i need to concatenate that variable with the name...
View older results
Back
Top Bottom