Access and Graph Hi, It's not possible directly through the OM although you can apply customer markers manually using copy/paste where the marker is a autoshape or picture.Tag: Can WER File Mapping ignore application version numbers? If you have tried that, but it isn't recording everything that you need, or it doesn't play back correctly, then post what you do have, as well as any error it generates.Īlso, let us know what version of Office you're using, as that can affect what tools are available to you. Have you tried recording the manual steps into a macro If you don't know how to do that, then reply to that effect and I'll try to assist. Do you want to know how to write the macro, or how to assign a macro to a button More clarity on what part of this you want help with would assist us in helping you.
The short answer is almost certainly yes and yes.
Is there someway i can do this through VBA Like have the user enter a string into a form with the name of the person they are trying to find and then press a button and have it print I guess it's quiet on the forum because it's the weekend. Using VBA in Word to slect and print a particular Record (recipient) Hi JB,.Range(sCellList).Select There is probably a way add to the Range object directly, but I hope this helps, KW Tag: Can WER File Mapping ignore application version numbers? SCellList = "A1, C3, E5" 'comma seperated cell names I don't have a lot of experience using the Range object, but it sounds like you can solve you problem with a String that keeps track of the cells. adding a non-adjacent cell to a named/defined range Hi bilo_krewol,.Sub Test() Set ws = CreateObject("WScript.Shell") ws.Run ("Notepad") End SubĬathrine Tag: Can WER File Mapping ignore application version numbers? How to run *.vbs or *.bat in Excel VBS? Hey,.
You won't have your number sequence restored anyway. To undo the new record, you can use Me.Undo or Forms!YourForm.Undo. In order to work correctly in mlti-user environments, Jet discards the ID generated when a new record is opened (even when it's not saved).Īutonumber fields are recommended when you don't need continuous numbering (i.e., when "holes" are acceptable).
0 kommentar(er)
