microsoft.public.access.macros | Forum profile

  Hi, No problem. What I wrote still applies. When I say to use the After Update event, I mean the After Update event of the control--your e-mail text box--not the After Update event of the form. To create a macro or an event procedure to do this right-click on the e-mail address text box and choose Properties. Click on the "Event" tab. Click in the "After Update" line. You will see a button with...

  I was afraid of that. Thanks for all the help though! At least I now know what the problem was. "Steve Schapel" wrote: > Genxer, > > You would need to re-create and save each macro to a standard macro or macro > group, and then assign this saved macro to the required event properties. > > Because of these types of problems, it is often recommended that databases >...

  Thanks again Bonnie. But that is way beyond me. All I was hoping to do was remove a row in Excel from Access. Didn't know it was going to be so complicated! "Jani" wrote: > I have a temp Excel file linked to an Access db. The Excel file will be on > either a home or network drive. I have a macro that works fine to move the > data from the Excel file and insert it in a SQL table, but I...

  Your welcome. Sorry I didn't have an easy fix. Bonnie http://www.dataplus-svc.com Jani wrote: >Thanks again Bonnie. But that is way beyond me. All I was hoping to do was >remove a row in Excel from Access. Didn't know it was going to be so >complicated! > >> I have a temp Excel file linked to an Access db. The Excel file will be on >> either a home or network drive....

  Genxer, You would need to re-create and save each macro to a standard macro or macro group, and then assign this saved macro to the required event properties. Because of these types of problems, it is often recommended that databases be developed using the earliest version of Access that will be used in practice for the deployment. -- Steve Schapel, Microsoft Access MVP "1genxer"...

  I'm going to add just a few details of the copying just to be a little more clear in what I'm hoping for. 1) Open excel file 1 2) Copy A2$:BR2 3) Insert Copy into "Master File" 4) Close excel file 1 5) Open excel file 2 6) Repeat step 2 7) Insert Copy in next row of "Master File" 8) Close and repeat. Also, there might be a slight problem opening a file from the File->Open menu....

  Oops - soory - I didn't understand the "access" part of the group name. "Clifford Bass" <CliffordBass@discussions.microsoft.com> wrote in message news:290078ED-C4CF-4974-A74B-FFDBCF5C673D@microsoft.com... > Hi, > > This is a discussion group for macros in Access, a database program. > You will need to repost your question a different discussion...

  Sorry - wrong NG!  

  Jeff!! So good to see you; i thought you'd abandoned us! :) "Jeff Conrad [MSFT]" <UseContactForm@mywebsite.com> wrote in message news:usJeWvTcJHA.1704@TK2MSFTNGP05.phx.gbl... > Hi Hubba, > > See this page on my site: > http://accessjunkie.com/faq_02.aspx > > -- > Jeff Conrad - Access Junkie - MVP Alumnus > SDET - XAS Services - Microsoft...

  "tina" <nospam@address.com> wrote in message: news:Y7g9l.266788$Mh5.116881@bgtnsc04-news.ops.worldnet.att.net... > Jeff!! So good to see you; i thought you'd abandoned us! :) Hi Tina, nice to see you too! Abandon?? Heck no, I'm an Access Junkie; I can't stay away. :-) I don't have as much time available to answer questions as I used to, but I'm around, trust me. ;-) --...