Hello I need to create an Autokey macro but not sure how to do it. its
suppose to Insert the data from the same field in the previous record CTRL+'
can anyone help please

Desiree,

I am struggling to understand. You are apparently already aware of Access's
built-in Ctrl+' keyboard shortcut for this purpose. And now you want to use
AutoKeys to create another keyboard shortcut to do the same thing? Why?
What's wrong with using Ctrl+' and what advantage would it be to use
something else instead? You still tie up the same number of fingers!

--
Steve Schapel, Microsoft Access MVP


"desireemm" <(E-Mail Removed)> wrote in message
news:842113CC-8C53-44DE-A838-(E-Mail Removed)...
> Hello I need to create an Autokey macro but not sure how to do it. its
> suppose to Insert the data from the same field in the previous record
> CTRL+'
> can anyone help please

The reason is because I am using an ADP and it does not support CTRL +
Apostrophe only an MDB does. but I have SQL Server 2005 as the engine

"Steve Schapel" wrote:

> Desiree,
>
> I am struggling to understand. You are apparently already aware of Access's
> built-in Ctrl+' keyboard shortcut for this purpose. And now you want to use
> AutoKeys to create another keyboard shortcut to do the same thing? Why?
> What's wrong with using Ctrl+' and what advantage would it be to use
> something else instead? You still tie up the same number of fingers!
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "desireemm" <(E-Mail Removed)> wrote in message
> news:842113CC-8C53-44DE-A838-(E-Mail Removed)...
> > Hello I need to create an Autokey macro but not sure how to do it. its
> > suppose to Insert the data from the same field in the previous record
> > CTRL+'
> > can anyone help please
>
>

I was told to use this but I'm not sure how do I put this in the afterupdate
of the form properties . and is the control name the name of the subform??
Private Sub YourControlName_AfterUpdate()
Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """"
End Sub

"June7" wrote:

>
> Try something like:
> DoCmd.RunCommand acCmdRecordsGoToPrevious
> varData = fieldname
> DoCmd.RunCommand acCmdRecordsGoToNext
> fieldname = varData
>
>
> --
> June7
> ------------------------------------------------------------------------
> June7's Profile: http://www.thecodecage.com/forumz/member.php?userid=784
> View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=129660
>
>

I wanted to do this in the subform is this correct I put it in the
properties Afterupdate()
Private Sub Tanf_tblsubform_AfterUpdate()
Me.Tanf_tblsubform.DefaultValue = """" & Me.Tanf_tblsubform.Value & """"
End Sub
"desireemm" wrote:

> The reason is because I am using an ADP and it does not support CTRL +
> Apostrophe only an MDB does. but I have SQL Server 2005 as the engine
>
> "Steve Schapel" wrote:
>
> > Desiree,
> >
> > I am struggling to understand. You are apparently already aware of Access's
> > built-in Ctrl+' keyboard shortcut for this purpose. And now you want to use
> > AutoKeys to create another keyboard shortcut to do the same thing? Why?
> > What's wrong with using Ctrl+' and what advantage would it be to use
> > something else instead? You still tie up the same number of fingers!
> >
> > --
> > Steve Schapel, Microsoft Access MVP
> >
> >
> > "desireemm" <(E-Mail Removed)> wrote in message
> > news:842113CC-8C53-44DE-A838-(E-Mail Removed)...
> > > Hello I need to create an Autokey macro but not sure how to do it. its
> > > suppose to Insert the data from the same field in the previous record
> > > CTRL+'
> > > can anyone help please
> >
> >

Private Sub Tanf_tblsubform_AfterUpdate()
Me.Tanf_tblsubform.DefaultValue = """" & Me.Tanf_tblsubform.Value & """"
End Sub

ok here is what I got, now do I put the field names in there because they
would be inputing hours into the subform. do I put the field names where the
quotes are. [Catagory for hours] [Services Covered], [Earned hours] [contact
date] [purpose of contact]??


"desireemm" wrote:

>
> I wanted to do this in the subform is this correct I put it in the
> properties Afterupdate()
> Private Sub Tanf_tblsubform_AfterUpdate()
> Me.Tanf_tblsubform.DefaultValue = """" & Me.Tanf_tblsubform.Value & """"
> End Sub
> "desireemm" wrote:
>
> > The reason is because I am using an ADP and it does not support CTRL +
> > Apostrophe only an MDB does. but I have SQL Server 2005 as the engine
> >
> > "Steve Schapel" wrote:
> >
> > > Desiree,
> > >
> > > I am struggling to understand. You are apparently already aware of Access's
> > > built-in Ctrl+' keyboard shortcut for this purpose. And now you want to use
> > > AutoKeys to create another keyboard shortcut to do the same thing? Why?
> > > What's wrong with using Ctrl+' and what advantage would it be to use
> > > something else instead? You still tie up the same number of fingers!
> > >
> > > --
> > > Steve Schapel, Microsoft Access MVP
> > >
> > >
> > > "desireemm" <(E-Mail Removed)> wrote in message
> > > news:842113CC-8C53-44DE-A838-(E-Mail Removed)...
> > > > Hello I need to create an Autokey macro but not sure how to do it. its
> > > > suppose to Insert the data from the same field in the previous record
> > > > CTRL+'
> > > > can anyone help please
> > >
> > >