How do I get a field to autofill the same value as the previous record when I
goto a new record.  The field's control source is the table field.  Can I use
autofill in Default value?

DoCmd.CopyObject """D:\ BackUp.mdb""", "tblTable1", acTable, "tbltable1"
I want to use array to give me sequence number for the tbltable1
I mean every time I use docmd.copyobject
Tbltable1 change to tbltable2 change to tbltable3 and so on

I have a database where i submit form data based on a serial number selected
from  a dropdown menu. I would like to be able to do this by scanning in the
serial numbers into a list box. Can anyone give me some pointers on how to
accomplish this?

I don't understand why this code not work
Dim StrPr1 As String
Dim StrPr2 As String
Dim StrPr3 As String

I added a button on my form that quits application. I used a wizard to make
it. When I click on a button it comes up with runtime error 2001 - you
cancelled previous operation. If database window is open - button works and
closes access, if only forms are visible it gives me the ...

i am having a problem in putting my newly added data in the list box. my list
box does not show on the first column the 1st data that i have entered. i
have a command button to add my data in the list box and i am using this code:
   DoCmd.OpenQuery "new_SY"

Is there any way to put a string into the command lines below that would
allow me to replace the "1" in each line with a 2 or a 3 or a 4 as needed? In
other words, can one single character in these lines be made into a variable
that I can manipulate?

This code is used to know Your Computer Processor Number
I think there are Missed reference or Module declaration section
First Question
Can any programmer Help me to complete this code and give me missed

Hi everyone!  Using A02 on XP.  I have a main form [ICSUpgrade2008MainForm]
with some data on it that I would like to copy down to my subform
[ICSUpgrade2008SubForm] when I click a button on the subform.  The Main Form
field is: [Forms]![ICSUpgrade2008MainForm]![Trustee] and the ...

Ok, I'm sure this is a syntax thing. I'm trying to find a record on a form
based on the members selected via two different criteria. For the following
statement
rs.FindFirst "[ConvActivityRtgID] = " & [TARSkillClusterID] =

Why when I goto a new record the date is blank?
Here is the code I'm using?
Private Sub PostDate_AfterUpdate()
Me.PostDate.DefaultValue = Chr(34) & Me.PostDate & Chr(34)

I am using Office 2000 and I have a form that contains a Microsoft Excel 2000
Chart. When the form is opened this chart is refreshed by a piece of VBA Code
which retrieves data from a database and puts it into the Sheet associated
with the Excel Chart and then formats the chart.

Sometimes the users can really be annoying with inane stuff but they sign my
checks.
My question is this:
When clicking into a text box, how do I get the cursor to automatically go

Before I print a report by clicking a command button [btnPrintRpt] I select
a record from a combobox list [cboCandidates].
This is then the basis of the report.
Firstly: How do I make the command button check to make sure that a record

I was wondering if it was possible to syncronize a textbox on a form to the
record selector on the bottom of the form. I want the user to enter the
current record number in the textbox. However, I want to syncronize it
because at times, records are deleted so I want to make sure ...