Search results

  1. M

    How to "press" cmd_btn at different form

    I use this code to "press" another command button that is on the same form, Private Sub Btn_B_Click() cmd_Btn_A_Click End Sub but how do I "press" a command button from another form?
  2. M

    Transfer data problem

    I have this code to transfer data from a table to a existing spreadsheet and it works fine. My question is: Is there a way to do the code more flexible so I could choose if I want to change row to transfer to? For example, I would like it to transfer first to B6 to T6 and then change to B26 to...
  3. M

    Add more controls than 755

    Hi! I think i´ve read that maximum controls in a report is 755 and I got this message when I try to add more controls: "Microsoft Office Access can´t create any more controls on this form or report" I guess there is 755 controls on my report right now but is there a way to go around this...
  4. M

    Copy text from form to report

    Hi! I use this code on a command button to copy a text from textbox 1 in form A, to textbox 2 in form B and this works great. Private Sub CmdA_Click() DoCmd.OpenForm "FormA", acNormal DoCmd.GoToRecord , , acNewRec Forms!FormA.Text1.Value = Forms!FormB.Text2.Value End Suband I use this code on a...
  5. M

    Open different forms when in runtime

    Hope you can understand me when english isn´t my language. I´ve done a database on my work and renamed it to .accdr in the end. What I want is a shortcut to open the form "a" for some people and for some other I would like a shortcut to open form "b". Is that possible? Hope this make sense...
  6. M

    Duplicate record

    Hey there, I've a form with some fields. when i fill all fields i want to duplicate that record x times. How? I thougt that i can have a independent field (textbox) where i can write the number of times i wanna duplicate that record but i don't know o to do it. Someone? thanks
  7. M

    Shortcut icon

    Is there a way to change the icon on a form shortcut? Thanks /Markus
  8. M

    Copy record

    Hi! I wonder if there is a macro that copy the record that I have open to a new record? If there is, is it possible to get it to change one field in the new record where I have the date to the day after? Thanks / Markus
  9. M

    Search with a textbox

    Hi! I´ve searched all day for this. Some threads are close to what I´m looking for, but is little more advanced than mine (i guess). I guess this is simple for most of you but I have no idea. All I want is a textbox on my form where I can search in my records, for exemple the number 20001. Hope...
Back
Top Bottom