Search results

  1. P

    Using OR in a query from a text box

    Hi clever people. I wonder if you can help me I have a form with a text box and a query that has a criteria or [FORMS]![ThisForm]![ThistextBox] Is i enter say "apples" in the text box then the query shows be all records with the criteria of apples. If i enter "oranges" it shows me all records...
  2. P

    comparing 2 recordssets and updating

    Hi i have 2 recordset and i need to compare the two. If a record doesnt existing i need it to be added I have VBA that works but it seems very slow. Is there a better way of doing it Dim rs As DAO.Recordset Dim rs2 As DAO.Recordset Set rs = CurrentDb.OpenRecordset("SELECT * FROM...
  3. P

    Running a Macro from another form

    Hi, I have 2 forms and a macro in Form1 which runs throught every record to update the records, however.. I would like to run this macro from the main form (Form2) I have tried docmd.openform "Form1" Run Macro but it doesnt work:banghead: Any ideas ?? Thanks
  4. P

    run macro from other form

    Hi all, Hopefully an easy one but i can seem to find an answer on the net I have a form with a button which when pressed need to run a macro which sits on a different form i have tried run macro ad do cmd but none of these work. Help please ?
  5. P

    Can you use CASE and INSTR together ?

    Hi all, Newbie here. am writting some VBA for MS ACCESS and wondered if there is a better way of writting some code. I have a check for lots of different data in a string and wondered if i can use CASE or similar. Sample code reads... If InStr(1, Me.txt_sp, "Give & Take", 1) Then TM =...
Back
Top Bottom